Skip to content

Registered aircraft · 5,443

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:2016-07-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-07-21') 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:2016-07-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-07-21')
  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:2016-07-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-07-21')
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.

N47653Fat Chance Airlines LLC · Hillsville, VAS/N 28-7816113 N47656Adventure North Flying Service LLC · Aitkin, MNFirst renewal noticeBuilt 1977 · S/N 28-7816115 N47660Edwards Mikiko S · Hoover, ALBuilt 1977 · S/N 28-7890111 N47661Wopuna And Son LLC · Vancouver, WABuilt 1977 · S/N 28-7890112 N4766FPrairie Fox Aviation LLC · Olathe, KSBuilt 1976 · S/N 28-7790060 N47673Falcon View Aviation LLC · Mckinney, TXBuilt 1977 · S/N 28-7816117 N47674Sides Blake A · Jackson, TNBuilt 1977 · S/N 28-7816118 N47675Czeck Steven S · New Hope, PABuilt 1977 · S/N 28-7816119 N47676Wulfekuhler Louis E · Lansing, MIBuilt 1977 · S/N 28-7890113 N47680New Mexico Flying Eagle DBA · Tucson, AZBuilt 1977 · S/N 28R-7737173 N47687Acevedo Gabriel Jr · Rego Park, NYBuilt 1977 · S/N 28-7816120 N47693Denton Max L · Marion, OHBuilt 1977 · S/N 28-7890118 N47694Aircraft Owners And Pilots Assn · Frederick, MDBuilt 1977 · S/N 28-7890119 N47699Swinney Audie G · Henryetta, OKBuilt 1977 · S/N 28-7816123 N476PCSaint Louis University · Saint Louis, MOBuilt 2019 · S/N 2881199 N476TAAtp Taa LLC · Wilmington, DES/N 2881318 N47700Indian River Flying Club Inc · Rockledge, FLBuilt 1977 · S/N 28R-7837001 N47702Braudis Russell P · Pittsburg, TXBuilt 1977 · S/N 28-7890120 N47705Tidona Robert J · Berwyn, PABuilt 1977 · S/N 28-7890121 N47706Coast 2 Coast LLC · Pensacola, FLBuilt 1977 · S/N 28-7890122 N4770FHamblen Scott · Tucson, AZBuilt 1976 · S/N 28-7790061 N47714Bradford Matthew Corin · Murrieta, CAS/N 28-7890088 N47718Ap Midway Inc · Palos Hills, ILBuilt 1977 · S/N 28-7816127 N47719Webb Bennie Kenneth · Fitzgerald, GABuilt 1977 · S/N 28-7816128 N47723Six Drew · Clinton, OHS/N 28R-7837002 N47737N47737 Holdings LLC · Gonzales, LABuilt 1977 · S/N 28-7890129 N47738Coady Thomas J · Wausau, WIBuilt 1977 · S/N 28R-7837003 N47767Capps Clinton Wyatt · Navasota, TXBuilt 1977 · S/N 28-7816132 N47768Registered aircraftBuilt 1977 · S/N 28-7816133 N47771Harris Richard P · Kings Park, NYS/N 28-7890135 N47773Walo Barry F · Cresson, TXBuilt 1977 · S/N 28-7890137 N477AMSpicher Samuel C Jr · Groveland, FLBuilt 2021 · S/N 28020017 N477PCSaint Louis University · Saint Louis, MOBuilt 2019 · S/N 2881200 N47818Fischer Scott R · Spanaway, WABuilt 1977 · S/N 28-7816134 N47819Candace A Larned Enterprises Inc · Long Beach, CABuilt 1977 · S/N 28-7816136 N47820Vascular Wings LLC · Friendswood, TXBuilt 1977 · S/N 28-7890139 N47824Morris-Reade Jeffrey M · Blaine, WABuilt 1977 · S/N 28-7890140 N47833Rtt Aviation LLC · Columbus, NEBuilt 1977 · S/N 28-7816138 N47835Paddock Andrew S · Ainsworth, NES/N 28-7816139 N47837Kolek Kirk A · Marion, IABuilt 1977 · S/N 28-7816141 N47839Ohara Daniel J · Naknek, AKS/N 28R-7837006 N47868Heartland Airplanes LLC · Olathe, KSFirst renewal noticeS/N 28-7890147 N47869N47869 LLC · Spanish Fork, UTBuilt 1977 · S/N 28R-7837008 N47881Griffin Jack D · Hamilton, OHBuilt 1977 · S/N 28-7816151 N47882Trident Aircraft Inc · Easton, MDBuilt 1977 · S/N 28-7816152 N47885Dynasty Adventure Inc · Mentone, CABuilt 1977 · S/N 28-7890148 N47886N47886 LLC · Dover, DEBuilt 1977 · S/N 28-7890149 N47899Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1977 · S/N 28-7816153 N478AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843746 N478PCSaint Louis University · Saint Louis, MOBuilt 2019 · S/N 2881201

Back to AD 2016-07-21