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.

N36696Ovajet Group Inc · Miami, FLBuilt 1978 · S/N 34-7870353 N36749Air Smt LLC · Powell, OHBuilt 1978 · S/N 28R-7837291 N36777Litwin Linda J · Potomac, MDBuilt 1978 · S/N 28R-7837292 N36795Rudy Neal W · Peoria, ILBuilt 1978 · S/N 34-7870371 N36802United States Air Force- Owner · Hanscom Afb, MABuilt 1978 · S/N 28R-7837293 N36804Poplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1978 · S/N 28R-7837295 N36822Bream Bruce L · Beachwood, OHBuilt 1978 · S/N 28R-7803345 N36827Thaviation LLC · Louisville, KYBuilt 1978 · S/N 34-7870374 N36838Sapphire Air LLC · Keystone, COBuilt 1978 · S/N 28R-7837296 N368SAIrish Sidney D · Roosevelt, NYBuilt 1968 · S/N 28R-30919 N369ACAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 34-7870095 N36BAAuerbach Gregory Brian · Swansea, ILBuilt 1976 · S/N 32R-7680442 N36RDProflight Inc · Wilmington, DEBuilt 1958 · S/N 24-490 N36WALandreth Kevin R · Ponca City, OKBuilt 1964 · S/N 30-581 N3700QGorge Winds Aviation Inc · Fairview, ORS/N 28R-7737047 N3700TBrickner Gary K · North Highlands, CAS/N 28R-30004 N3701TStewarts Aircraft Service Inc · Waynesville, OHBuilt 1967 · S/N 28R-30005 N3702TDelp Thomas W · Rensselaerville, NYFirst renewal noticeBuilt 1967 · S/N 28R-30006 N3704MLacroix Robert Emile Jr · Orlando, FLS/N 28R-7837130 N3704TStevens Michael J · Punta Gorda, FLBuilt 1967 · S/N 28R-30008 N3705TN3705t LLC · Dallas, TXBuilt 1967 · S/N 28R-30009 N3706TFinished Work Aviation LLC · Redding, CABuilt 1967 · S/N 28R-30010 N3709TJudice Eric M · Elgin, ILFirst renewal noticeBuilt 1967 · S/N 28R-30013 N3711Gratech Management LLC · Washington, NCBuilt 1967 · S/N 28R-30015 N3716TN351xray LLC · Olga, WAS/N 28R-30021 N3718TRuder William A Jr · Council Bluffs, IAS/N 28R-30023 N3720TBrinmoore Aero LLC · Jacksonville, FLBuilt 1967 · S/N 28R-30025 N3724TGateway Flight Training LLC · Saint Louis, MOBuilt 1967 · S/N 28R-30030 N3727TN3727 Tango LLC · Baton Rouge, LABuilt 1967 · S/N 28R-30034 N373Clayland Walter · San Rafael, CABuilt 1966 · S/N 30-1374 N3730MWilcom LLC · Hammond, LABuilt 1978 · S/N 28R-7837133 N3730TNational Energy Conservers Inc · West Linn, ORBuilt 1967 · S/N 28R-30037 N3731MZim Air LLC · Wilmington, DEBuilt 1978 · S/N 28R-7803189 N3732TOancea Traian · Oakdale, CABuilt 1967 · S/N 28R-30040 N3733TTudor David M · Seaford, DEBuilt 1967 · S/N 28R-30041 N3736TVelivis Bernard K · Hollis, NHBuilt 1967 · S/N 28R-30045 N3737TKenny David Jack · Frederick, MDBuilt 1967 · S/N 28R-30046 N373CBCalifornia Baptist University · Riverside, CABuilt 2017 · S/N 2844174 N3740TBibbey Mark A · Chandler, AZBuilt 1967 · S/N 28R-30049 N3741TIowair Inc DBA · Atkins, IABuilt 1968 · S/N 28R-30957 N3744TAg Air Squadron One LLC · Saint Joseph, ILBuilt 1967 · S/N 28R-30054 N3745QBeer Aviation LLC · Santa Rosa Beach, FLS/N 28R-7737058 N3745THill James C · Grand Saline, TXS/N 28R-30055 N3746THeinemann Daniel J · Lynchburg, TNBuilt 1968 · S/N 28R-30958 N3748TBaki Christian · Ocoee, FLBuilt 1967 · S/N 28R-30058 N374CBCalifornia Baptist University · Riverside, CABuilt 2017 · S/N 2844175 N3750TNevius Matthew W · Freeport, FLBuilt 1967 · S/N 28R-30059 N3752TSharp Jim C · Stephenville, TXBuilt 1967 · S/N 28R-30061 N3753THalcyone Holding LLC · Santa Teresa, NMBuilt 1967 · S/N 28R-30062 N3754TWells Brian T · Gonzales, TXS/N 28R-30063

Back to AD 97-01-01 R1