Skip to content

Registered aircraft · 26,231

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:94-05-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:94-05-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:94-05-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:94-05-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:94-05-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:94-05-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.

N517TGMcdonald Richard Reid · Rock Island, WAS/N 18517 N517WPenell Mark A · Palmetto, FLBuilt 1949 · S/N 15255 N5180AWarmack Holdings LLC · Englewood, FLBuilt 1956 · S/N 28180 N5180FUnited States Air Force Owner · Hanscom Afb, MABuilt 1965 · S/N 17253108 N51828Flannery Robert P · Durango, COBuilt 1947 · S/N 5287 N5182FAmerican Flight Museum Inc · Topeka, KSBuilt 1965 · S/N 17253116 N5184FScott Alan M · Othello, WABuilt 1965 · S/N 17253124 N5185ACardan Aircraft Services Inc · Red Bluff, CAS/N 28185 N5186ATengwall Kevin A · Watford City, NDS/N 28186 N518RAPeterson Maeve M · Sonoma, CABuilt 1960 · S/N 15059082 N518RWAkro Attitudes Inc · Lighthouse Point, FLFirst renewal noticeS/N 1885 N519Malaska Jacob L · Orefield, PABuilt 1966 · S/N 15064303 N5191ABurdeaux Barry S · Orting, WAS/N 28191 N5192AGenitempo Serge · Studio City, CABuilt 1955 · S/N 28192 N5193AGustaf John A · Lowell, MIBuilt 1956 · S/N 28193 N5196AParker Todd S · Kaysville, UTBuilt 1956 · S/N 28196 N51986Experimental Aircraft Association Inc · Oshkosh, WIBuilt 2010 · S/N 16200004 N5198YExperimental Aircraft Association Inc · Oshkosh, WIBuilt 2010 · S/N 16200003 N5199DRainier Flight Service LLC · Renton, WABuilt 2010 · S/N 16200005 N5199KHiller Joseph · Port Orange, FLBuilt 2011 · S/N 16200076 N51DVBennett Gabriel J C · Hillsboro, ORBuilt 1946 · S/N 2024 N51ETRodopoulos Phillip · North Royalton, OHBuilt 1946 · S/N 8305 N51FACoffey Michael A · White Lake, MIBuilt 1962 · S/N 17249754 N51FSBabes Fly II LLC · Hutchinson, MNBuilt 1946 · S/N 15327 N51GEaa Aviation Foundation Inc · Oshkosh, WIBuilt 1959 · S/N 105 N51HJJones Stephen C · Wadsworth, ILBuilt 1992 · S/N 01 N51KSBook Paul A · Richvale, CAS/N 626 N51LTDennis William V · Bend, ORBuilt 1959 · S/N 69 N51WCPoe Rex A · Conway, ARS/N JS-1 N52023M&L Flight Inc · Newcastle, WABuilt 2010 · S/N 16200014 N5202FUnited States Air Force (Owner) · Millington, TNBuilt 1965 · S/N 17253189 N5202QRosso Matthew J · Mancos, COS/N 15073102 N52030Hb963 LLC · Gig Harbor, WABuilt 2010 · S/N 16200016 N5203FDale County Sheriffs Office · Ozark, ALBuilt 1965 · S/N 17253192 N5203QMatteis Vincent M · Lyndonville, VTBuilt 1971 · S/N 15073103 N52040Robinson John · Auburn, NHBuilt 2010 · S/N 16200019 N52049West Racer Ltd · Agoura Hills, CAS/N 16200021 N5204FUnited States Air Force · Offutt Afb, NEBuilt 1965 · S/N 17253195 N5204QWarren County Career Center · Lebanon, OHBuilt 1971 · S/N 15073104 N5204UCasiere Eugene A · Lake Hopatcong, NJBuilt 2010 · S/N 16200018 N52054Ubelhor Blaine · Derby, INBuilt 2010 · S/N 16200022 N52056206 Aviation LLC · Bainbridge Island, WABuilt 2010 · S/N 16200023 N5207BGuss Rigby Flight School LLC · Rigby, IDBuilt 2010 · S/N 16200024 N5207FUnited States Air Force Owner · Clovis, NMBuilt 1965 · S/N 17253206 N5207RConfluence Systems Consulting · San Jose, CABuilt 2010 · S/N 16200025 N5208FUnited States Air Force Owner · Beale Afb, CABuilt 1965 · S/N 17253209 N5208QEmerick Benjamin F · Foster, RIBuilt 1971 · S/N 15073108 N5208VLa Flight School Inc · Van Nuys, CABuilt 2010 · S/N 16200027 N5209QTulsa Technology Center School District No 18 · Tulsa, OKS/N 15073109 N520JCSisson Christopher S · Sarah, MSS/N 15073129

Back to AD 94-05-05 R1