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.

N47553Turbine Mentor LLC · Granbury, TXBuilt 1977 · S/N 32R-7880012 N47557M & M Aircraft LLC · Cresson, TXBuilt 1977 · S/N 34-7770414 N47589Radke John A · Cedar Falls, IABuilt 1977 · S/N 28R-7703404 N475TVPaine Twin Comanche LLC · Redmond, WABuilt 1966 · S/N 30-1366 N47605Lovaas Darryl G Trustee · Crescent City, CABuilt 1977 · S/N 28R-7703406 N47630Adolph Gerald · New Rochelle, NYBuilt 1977 · S/N 32R-7880016 N47631Ordway Daniel F · Corona, CABuilt 1977 · S/N 34-7770420 N47632Famalette Christopher · Havre De Grace, MDBuilt 1977 · S/N 28R-7703367 N47642Wes Hughes Corporation · Waldron, KSBuilt 1977 · S/N 28R-7703413 N47646Span Development LLC · Madera, CABuilt 1977 · S/N 32R-7880017 N47662Milo Michael E · Evansville, WYS/N 28R-7703417 N47670Stanberry Wallace A · Shreveport, LABuilt 1977 · S/N 34-7770424 N47680New Mexico Flying Eagle DBA · Tucson, AZBuilt 1977 · S/N 28R-7737173 N47681C Mf Inc · Bloomington, ILBuilt 1977 · S/N 28R-7703421 N47682Byerly James · Virginia Beach, VABuilt 1977 · S/N 28R-7703422 N476JBArchipelago Group LLC · Alexandria, VABuilt 1977 · S/N 28R-7703419 N47700Indian River Flying Club Inc · Rockledge, FLBuilt 1977 · S/N 28R-7837001 N47707Stateler Mickey S · Fort Worth, TXS/N 28R-7803001 N47709Bedy David P · Albuquerque, NMBuilt 1977 · S/N 28R-7803002 N47711N47711 LLC · Sheridan, WYBuilt 1977 · S/N 32R-7880019 N47723Six Drew · Clinton, OHS/N 28R-7837002 N47726Pier To Plateau Aviation Services LLC · Wilmington, DES/N 28R-7803005 N47728Jr Aircraft Services LLC · Oxford, MIBuilt 1977 · S/N 28R-7803006 N47738Coady Thomas J · Wausau, WIBuilt 1977 · S/N 28R-7837003 N47739Tnl Management LLC · Cullman, ALBuilt 1977 · S/N 28R-7803008 N47740Media Stew LLC · Carson City, NVBuilt 1977 · S/N 28R-7803009 N47742Jmd Enterprises LLC · Thompsons Station, TNBuilt 1977 · S/N 28R-7803011 N47743Majic T Air LLC · Bradfordwoods, PABuilt 1977 · S/N 32R-7880020 N47761Engholm Jeffrey H · Bauxite, ARBuilt 1977 · S/N 28R-7803012 N47763Premier Management Co · Mobridge, SDBuilt 1977 · S/N 28R-7803014 N47764Wl Aviation LLC · Olney, MDBuilt 1977 · S/N 32R-7880021 N47766N47766 LLC · Pembroke Pines, FLBuilt 1977 · S/N 34-7870002 N477DMiller Clark · Grapevine, TXBuilt 1977 · S/N 32R-7780367 N477MERegistration Pending · Webster, NYRegistration pendingBuilt 1969 · S/N 28R-35030 N47805Premier Aviation LLC · Sioux Falls, SDS/N 28R-7803016 N47810Nrg Systems N W LLC · Gresham, ORBuilt 1977 · S/N 28R-7803019 N47815Fino Plane Co · Farmington, MIBuilt 1977 · S/N 34-7870004 N47826Rogerson Andrew C · Kingsland, TXBuilt 1977 · S/N 28R-7803021 N47827Alford James L · Mckinney, TXBuilt 1977 · S/N 28R-7803022 N47839Ohara Daniel J · Naknek, AKS/N 28R-7837006 N47842S&L Farm And Ranch LLC · Roseburg, ORS/N 28R-7803025 N47848Sloan Paris Company LLC · Lake Worth, FLBuilt 1977 · S/N 34-7870008 N47869N47869 LLC · Spanish Fork, UTBuilt 1977 · S/N 28R-7837008 N47874Matthews John M · Mount Pleasant, TXBuilt 1977 · S/N 28R-7803032 N47877Trying Harder Flight LLC · Cheyenne, WYBuilt 1977 · S/N 34-7870010 N47878Hunt Michael A · Siloam Springs, ARBuilt 1977 · S/N 34-7870011 N47891Pearson Joe D · Boise, IDBuilt 1977 · S/N 28R-7803035 N47895Seneca Aeronautical Services LLC · Wilmington, DEBuilt 1977 · S/N 34-7870012 N478WTBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 24-4634 N47912Maxey Russell J · Midland, TXFirst renewal noticeS/N 28R-7803037

Back to AD 97-01-01 R1