Skip to content

Registered aircraft · 40,401

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

N1223UKoren Richard D · Brea, CABuilt 1976 · S/N 17266919 N1223XAirspeed Consulting LLC · Mounds, OKBuilt 1963 · S/N 194 N12240Wings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17261901 N12243Phoenix Sky Aviation LLC · Gilbert, AZBuilt 1973 · S/N 17261903 N12245Donnelly Terrence A · Eleele, HIBuilt 1973 · S/N 17261905 N12246Bowles Thomas M · Olivehurst, CABuilt 1973 · S/N 17261906 N12247Rebecca'S Wings 247 LLC · Greenville, KYBuilt 1973 · S/N 17261907 N1224UGoss Selby · Baytown, TXBuilt 1976 · S/N 17266920 N1224XAlpha Aviation Mission Outreach Center Inc · Muskogee, OKBuilt 1963 · S/N 195 N1225XSuda Inc · Lindsborg, KSBuilt 1963 · S/N 196 N12261Davis Danny R · S Coffeyville, OKBuilt 1973 · S/N 17261909 N1226AWalsh Brendan · Seattle, WAS/N 18-841 N1226FSnoopys Group Inc · Westerly, RIBuilt 1979 · S/N 17272978 N1226TLinde Glenn F Jr · Juneau, WIBuilt 1972 · S/N 28-7205269 N1226UAirborne LLC · Wilmington, DEBuilt 1976 · S/N 17266922 N1227UKelly William W · Springfield, ORBuilt 1976 · S/N 17266923 N1227XVan Hoosen Ronald L · Goldsby, OKBuilt 1963 · S/N 198 N1228REcko Air LLC · Springfield, MOBuilt 1989 · S/N 2841266 N1228UBig Sky Aviation LLC · Glenmora, LABuilt 1976 · S/N 17266924 N12290Read Andrea · Austin, TXBuilt 1973 · S/N 17261912 N12291Cisek Jason M · Westfield, MABuilt 1973 · S/N 17261913 N1229UMcdonald Air Services LLC · Saint Johns, MIBuilt 1976 · S/N 17266925 N1229WScott George H · Springdale, ARBuilt 2000 · S/N 5258 N122AKBarker Paul II · Rainbow City, ALBuilt 1991 · S/N 2028 N122BPDiggins Charles J · Middleboro, MABuilt 1997 · S/N 22912 N122BRHollon Blake D · Douglas, WYBuilt 1958 · S/N TD-65 N122EZLawley Frederick Ellsworth III · Castro Valley, CAS/N 1297 N122HSafeline Aviation LLC · Apache Junction, AZBuilt 1999 · S/N 1274-99 N122HSMarbury Sherri E · Jackson, TNBuilt 1965 · S/N 28-2377 N122JDGrasshopper Aviation LLC · Hockley, TXBuilt 2000 · S/N 1301-2000 N122KCRomero Garcia Moises · Park City, UTBuilt 2003 · S/N 2105-L N122MJHyper Flight Inc · Seattle, WABuilt 1977 · S/N 17270043 N122MLLutz Michael A · Findlay, OHBuilt 2000 · S/N 645 N122NAGilded Gull Aviation LLC · Middletown, RIBuilt 1981 · S/N 28-8216068 N122PLSlip Stream Aviation Inc · Fort Mill, SCBuilt 2001 · S/N 3265 N122PPStout Andy · Livingston, TXBuilt 1990 · S/N 526 N122RFDaniels Ronald C · Poughkeepsie, NYS/N 3397 N122SSGrain Belt Aviation LLC · Malcolm, NEBuilt 1975 · S/N 17264842 N122XXGloss Mountain Aviation Foundation · Meno, OKBuilt 1990 · S/N 9001 N1230EMcmahan Johnny W · Gakona, AKBuilt 2020 · S/N 001 N1230MGoos Farms Inc · Silver City, IABuilt 2002 · S/N 1327-2002 N1231PTwin Oaks Airpark Inc · Hillsboro, ORBuilt 1955 · S/N 23-251 N1231WMusa Adam · Princeton, NJBuilt 1967 · S/N 670099 N1232TAlexander Charles W · Slidell, LABuilt 1972 · S/N 28-7225430 N1232UOrganization Of Black Aerospace Professionals Inc · Westchester, ILS/N 17266928 N1232WMilam David N · Hannibal, MOBuilt 1967 · S/N 670088 N12330Liller Kenneth F · New Port Richey, FLBuilt 1973 · S/N 17261932 N12331N Conti Inc · Boyertown, PABuilt 1973 · S/N 17261933 N12335Truscott Jon M · Sunfield, MIBuilt 1973 · S/N 17261935 N12336Qualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 17261936

Back to AD 79-10-03 R2