Skip to content

Registered aircraft · 6,915

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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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.

N38703Ollieboy Productions LLC · Kalispell, MTBuilt 1977 · S/N 28R-7703261 N3870TEast Coast Autoline LLC · Whitehall, PABuilt 1967 · S/N 28R-30194 N38716Spartan Aviation Group LLC · Williamsburg, VABuilt 1977 · S/N 28R-7737109 N38717Meiller Richard S · Kill Devil Hills, NCBuilt 1977 · S/N 28R-7737110 N38718Vgw LLC · Morgantown, WVBuilt 1977 · S/N 28R-7737111 N3871TSzd Property Management LLC · Oceanside, CABuilt 1967 · S/N 28R-30195 N38720Arrow N38720 LLC · West Des Moines, IABuilt 1977 · S/N 28R-7703264 N38725Maynard Geoffrey · New Marlborough, MABuilt 1977 · S/N 32R-7780465 N3872TTucker Zane Griffin · Albany, ORBuilt 1967 · S/N 28R-30196 N3873MMorris Air LLC · Hopkinsville, KYBuilt 1978 · S/N 28R-7803198 N3873TDerby City Aviation LLC · Vero Beach, FLBuilt 1967 · S/N 28R-30197 N38741Hoyda Jeffrey A · Tiffin, OHBuilt 1977 · S/N 28R-7703267 N38746Campbell David A Trustee · Bolivar, MOBuilt 1977 · S/N 32R-7780466 N38749Epperson Matthew · Moraga, CABuilt 1977 · S/N 32R-7780467 N3874TSmith Albert G Jr · Lake Jackson, TXBuilt 1967 · S/N 28R-30199 N38750Mike Mcfadden Enterprises Inc · Laurel, MDBuilt 1977 · S/N 34-7770336 N38752Leblanc Richard · Mclean, VABuilt 1977 · S/N 32R-7780468 N3875TMichael Jin · Renton, WABuilt 1967 · S/N 28R-30200 N38760Davis Robby E · Plant City, FLBuilt 1969 · S/N 30-1999 N38768Ovajet Group Inc · Miami, FLBuilt 1977 · S/N 34-7770085 N38771Bmaf LLC · Lewes, DEBuilt 1977 · S/N 28R-7737116 N38773Gustafson David · Watertown, SDBuilt 1977 · S/N 28R-7737117 N38776Warnock Air LLC · Eagle, IDBuilt 1977 · S/N 28R-7703274 N3878TRoach Keith E · Chester, SCBuilt 1967 · S/N 28R-30203 N38791Gehl Timothy E · Houston, TXBuilt 1977 · S/N 28R-7703276 N38792Tysdan Aviation LLC · Lake Worth, FLBuilt 1977 · S/N 28R-7703277 N38793Siegfried Todd · Brentwood, CABuilt 1977 · S/N 28R-7703278 N3879TDupuis Kevin P · Waddell, AZBuilt 1967 · S/N 28R-30204 N3880TThoms Gregory S · Adkins, TXBuilt 1967 · S/N 28R-30206 N38818Rogers Jason · Limerick, PABuilt 1977 · S/N 32R-7780475 N3883TPaul Novak Mdpc · Des Moines, IABuilt 1967 · S/N 28R-30210 N3885TN3885t LLC · Howell, MIS/N 28R-30213 N38871Arrow Blue N38871 LLC · Turpin, OKBuilt 1977 · S/N 28R-7703281 N38875Landau Victor M · Lake City, FLBuilt 1977 · S/N 28R-7703282 N3888TBoyd Joshua A · Greenville, SCBuilt 1967 · S/N 28R-30216 N3889TBroten Paul B · Topping, VABuilt 1967 · S/N 28R-30217 N388LBSdgair LLC · Port Orange, FLBuilt 1964 · S/N 30-511 N38908Mollere Michael E · Marion, TXBuilt 1977 · S/N 32R-7780487 N38911Sams Aviation LLC · Decatur, ILBuilt 1977 · S/N 32R-7780488 N38912Congco Antoine Mark J · New Caney, TXBuilt 1977 · S/N 32R-7780489 N38919Sale Reported · Sarasota, FLSale reportedBuilt 1977 · S/N 28R-7737123 N3891FJjcw Aviation Inc · Athens, TXBuilt 1976 · S/N 32R-7680407 N3891TJones Rodney D · Corcoran, CABuilt 1967 · S/N 28R-30220 N38944Lewis David A · Fairfield, CAFirst renewal noticeBuilt 1977 · S/N 28R-7703284 N38945Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1977 · S/N 32R-7780490 N3894TBsa Leasing LLC · Pocatello, IDBuilt 1967 · S/N 28R-30223 N3895FGreever Steven M · Spearman, TXBuilt 1977 · S/N 28R-7737002 N3895TPaetzold Carson · Jacksonville, FLBuilt 1967 · S/N 28R-30224 N3896FEssary Larry R · Mc Neal, AZS/N 28R-7635376 N38981Kreck Blake T · Terrell, TXBuilt 1977 · S/N 28R-7703290

Back to AD 97-01-01 R1