Registered aircraft · 56,579

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-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.

N11VYPritt Brian C · San Luis Obispo, CABuilt 1979 · S/N 18267086 N11WHT T Aero LLC · Pauls Valley, OKBuilt 1956 · S/N 33447 N11WSAviation Trust Company LLC · Oklahoma City, OKS/N P3370017 N11YJCrawley Frederick J · Virginia City, NVS/N 182-66498 N11YSBonanza N5745v LLC · Colorado Springs, COBuilt 1968 · S/N 15068608 N11YWBaldwin William E · Kula, HIBuilt 1970 · S/N 15072351 N11YZHuggins David R · Carmichael, CABuilt 1970 · S/N 18260401 N12000Bear Creek Air LLC · Helena, MTBuilt 1968 · S/N 18259487 N1200GHartmann Kaiser Robert · New York, NYBuilt 1972 · S/N 15073901 N1200L1st American Aviation Inc · North Miami, FLBuilt 1959 · S/N 17785 N1200USowers Harry D · S Bloomingvle, OHBuilt 1978 · S/N 17272035 N1200VTampa Bay Aviation Inc · Clearwater, FLBuilt 2006 · S/N 172S10394 N1200YMillner Jack A · Toledo, OHBuilt 1962 · S/N 15059600 N1201EN1201e LLC · Wilmington, DEBuilt 2006 · S/N 172S10352 N1201FRed Door Aviation LLC · Dover, DEBuilt 1979 · S/N 17272966 N1203CMirzaei-Nejad Hamid · Lake Stevens, WAS/N 17702685 N1203FRawson Aviation LLC · Collinsville, OKBuilt 1979 · S/N 17272968 N1203QMusick John Thomas · White Hall, ARBuilt 1971 · S/N 15072503 N1203YWyatt G Whitlow · Wshngtn Ct Hs, OHBuilt 1962 · S/N 15059603 N1204FMoroney Aviation LLC · Chugiak, AKBuilt 1975 · S/N 18502767 N1205BEngel Shane J · Willow, AKBuilt 1963 · S/N 205-0190 N1205CNorthern Aire Flying Club Ltd · Black Creek, WIBuilt 1977 · S/N 17702686 N1205UBordeaux Marvin · Willcox, AZBuilt 1976 · S/N 17266904 N12064Eastern Cincinnati Aviation Inc · Batavia, OHBuilt 2005 · S/N 172S9839 N1206FHarrah Daniel R · Juneau, AKBuilt 1975 · S/N 18502769 N1206UFxe Flightcenter Corp · Fort Lauderdale, FLBuilt 2006 · S/N 172S10417 N12077Crawley Michael P · Penn Valley, CABuilt 1965 · S/N 18255966 N1207UKasakoff Lloyd · Diamond Bar, CAS/N 17266906 N1207YDickman Matthew J · Cold Spring, KYBuilt 1962 · S/N 15059607 N12082Lopez George · Dover, DES/N 17261797 N1208DMusgrove James F · Burien, WABuilt 1955 · S/N 19762 N1208FYukon Air Service Inc · Fairbanks, AKBuilt 1975 · S/N 18502771 N1208YSnyder Jason D DBA · Oakland, MDBuilt 1962 · S/N 15059608 N12090Diaz Aviation LLC · Mount Upton, NYBuilt 1973 · S/N 17261800 N12091K D Farms Inc · Cosmos, MNBuilt 1973 · S/N 17261801 N12095Ciddio Mark S · Sebastopol, CABuilt 1975 · S/N 17702385 N12097Aerolease Aviation Rental LLC · Cartersville, GABuilt 1973 · S/N 17261807 N12098Traywick James D · Cope, SCBuilt 1973 · S/N 17261808 N1209MShook Steve Trustee · Boulder, COBuilt 1975 · S/N 18264243 N1209RRowley Timothy · Roopville, GABuilt 1954 · S/N 26152 N120DHHiester Donald J · Sicklerville, NJBuilt 1961 · S/N 17248694 N120FMRunamuck LLC · New Orleans, LABuilt 2024 · S/N 172S13210 N120GRStarlight Flight Aerial Tours LLC · Coppell, TXBuilt 1999 · S/N 18280430 N120HPRegistration Pending · Lawton, OKRegistration pendingBuilt 2006 · S/N 18281841 N120JHC&C Cessna LLC · Baltimore, MDBuilt 1977 · S/N U20603636 N120SSSoutheastern Oklahoma State University · Durant, OKBuilt 1976 · S/N 15078900 N120SUOklahoma State University · Stillwater, OKBuilt 2016 · S/N 172S11674 N120WEHarbor Air Inc · Ann Arbor, MIBuilt 2002 · S/N 18281117 N12100Tita LLC · Fajardo, PRBuilt 1973 · S/N 17261810 N12104Wings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17261812

Back to AD 79-10-14 R1