Skip to content

Registered aircraft · 10,639

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:99-01-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-01-05-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:99-01-05-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-01-05-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:99-01-05-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-01-05-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N805AHolder Steven M · Hartwell, GABuilt 1951 · S/N 22-108 N8060DBrooks Ronald L · Loveland, OHFirst renewal noticeBuilt 1957 · S/N 22-5583 N8061CCape May Aerial Advertising LLC · Rio Grande, NJBuilt 1954 · S/N 18-3409 N8061DMartin Malcolm Rudy · Fairbanks, AKBuilt 1957 · S/N 22-5584 N8062DRosengrant Walter P · Tunkhannock, PABuilt 1957 · S/N 22-5585 N8063VMiller Wade L · Roberts, MTS/N 18-8009057 N8066CSchachle Vernon E · Wasilla, AKS/N 18-3417 N8067DBurgess Bruce A · Saint Johns, MIS/N 22-5590 N8069DCasey Michael B · Hemingford, NEBuilt 1957 · S/N 18-6051 N806TDWall Joseph J · Chamberlain, SDBuilt 1957 · S/N 22-4840 N8070CKnutson Wayne R · Tioga, NDBuilt 1954 · S/N 18-3464 N8070HBagley Sherell G · Suwanee, GAS/N 22-8147 N8071LRogers Jonathan T · College Place, WABuilt 1959 · S/N 16-550 N8072CBixler Brett M · Eielson Afb, AKBuilt 1954 · S/N 18-3471 N8073DPetersen Mark A · Willow, AKBuilt 1957 · S/N 18-6056 N8074DVan Hatten Michael Sr · Fairbanks, AKBuilt 1957 · S/N 18-6057 N8075PAir Ads Inc · El Cajon, CABuilt 1963 · S/N 18-8050 N8076CStuart Chris W · Fairbanks, AKBuilt 1954 · S/N 18-3476 N8077CDavis Kern M · Saint Petersburg, FLBuilt 1954 · S/N 18-3478 N8077DSkyport Inc · Las Vegas, NVRevoked, canceledBuilt 1957 · S/N 18-6060 N8077ULeavitt Erin G · Lewiston, IDBuilt 1947 · S/N 12-1084 N8078DStevenson William E · Sutton, AKBuilt 1957 · S/N 18-6061 N8079CFlying D Farm Inc · Kerhonkson, NYBuilt 1958 · S/N 18-3480 N8079DScheidel Ranches · Pleasant Grove, CABuilt 1957 · S/N 18-6062 N807EJBaldmans Aircraft Services LLC · Wilmington, DES/N 18-3519 N8081CBartlett Branden S · Eagle River, AKBuilt 1953 · S/N 18-3485 N8081DZwiacher John W · Green Lake, WIBuilt 1957 · S/N 18-6072 N8082CGilbert Ray E · Buffalo, SDBuilt 1954 · S/N 18-3486 N8082DYork Richard L · Rockport, MABuilt 1957 · S/N 18-6073 N8083DRegistered aircraftBuilt 1957 · S/N 18-6074 N8083GWells Kris G · Barron, WIS/N 18-2129 N8086CRoeloffs Arie · Wendell, IDBuilt 1954 · S/N 18-3491 N8086DHinderberger Bryan J · Juneau, AKBuilt 1957 · S/N 18-6079 N8088CVouk Frank E · Firth, IDBuilt 1954 · S/N 18-3495 N808PTDancing Bear Alaska LLC · Talkeetna, AKBuilt 1956 · S/N 22-4644 N8091COlson Christian A · Hayward, WIBuilt 1954 · S/N 22-2237 N8091DJohnston Zach H · Soldotna, AKS/N 18-6086 N8093DSmith Ihler M · Fairbanks, AKBuilt 1957 · S/N 18-6084 N8094DHigh Exposure Inc · Wilmington, DEBuilt 1957 · S/N 18-6089 N8095CBryant Stephen C · Anchorage, AKBuilt 1954 · S/N 22-2241 N809AKeller Gene M · Bethlehem, PABuilt 1951 · S/N 22-114 N80ANStephany Peter T · Umatilla, FLBuilt 1980 · S/N 18-8109003 N80BJRegistration Pending · Jasper, GARegistration pendingBuilt 1977 · S/N 18-7709191 N80LSClow Streeter M · Mansfield, OHBuilt 1976 · S/N 18-7609096 N80TRRender Thomas R · Eden Prairie, MNFirst renewal noticeBuilt 1956 · S/N 18-4844 N8100YHagaman Boynton C · Berryville, VABuilt 1967 · S/N 18-8582 N8101AGryczemski John Z · Olive Branch, MSBuilt 1977 · S/N 187709060 N8102DReilly Herbert V · Bloomingburg, NYBuilt 1958 · S/N 18-6467 N8102YAlexander Wesley L · Nenana, AKBuilt 1967 · S/N 18-8584 N8103YBleazard William D · Sandy, UTBuilt 1967 · S/N 18-8585

Back to AD 99-01-05 R1