Skip to content

Registered aircraft · 56,578

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.

N1854QSc Cardinal LLC · Wilmington, DEBuilt 1972 · S/N 177RG0254 N1854VSchmitt Rudy · Brookshire, TXBuilt 1974 · S/N 17263771 N1854YMikowski Charles A · Sparta, MIS/N 17249454 N1854ZBargabos William M · Wasilla, AKS/N 2050054 N18552Malecha James L Trustee · Wilmot, NHBuilt 1972 · S/N 15073937 N18554Lavelle Jonathan A · Berrien Springs, MIBuilt 1972 · S/N 15073938 N18558Gunderson Robert B · League City, TXBuilt 1972 · S/N 15073941 N1855CRowe James D · Nome, AKBuilt 1953 · S/N 25999 N18565Hughes Danny R · Hickory, NCBuilt 1972 · S/N 15073946 N18567Barros Da Silva Norton · Tyler, TXBuilt 1972 · S/N 15073948 N18568Green Tom H · Vega, TXBuilt 1972 · S/N 15073949 N18569Doyle Harley M · O Brien, FLBuilt 1972 · S/N 15073950 N1856QEmpty Hanger LLC · Traverse City, MIBuilt 1972 · S/N 177RG0256 N1856RRich Gary L · Anchorage, AKBuilt 1974 · S/N 18502571 N1856XRobert Yost Enterprises · Saint Francis, KSBuilt 1964 · S/N 18255956 N18572Stofka Joseph M · Erie, MIBuilt 1972 · S/N 15073952 N18574Reed Philip D · Millsboro, DEBuilt 1972 · S/N 15073954 N18576Cardinal-Bird LLC · Melbourne, FLBuilt 1976 · S/N 17702543 N18578Nauerth John III · Lakefield, MNBuilt 1972 · S/N 15073956 N18579Beck Roger M Trustee · Goode, VABuilt 1972 · S/N 15073957 N1857CSchlender Michael E · Clintonville, WIBuilt 1953 · S/N 26001 N1857VCare Central Inc · Minneapolis, MNS/N 17263772 N1857YKnudson Wayne L · Larimore, NDBuilt 1962 · S/N 17249457 N18580Kirk Bryan · Las Vegas, NVBuilt 1972 · S/N 15073958 N18582Voigts Bruce M · Clarion, IABuilt 1972 · S/N 15073960 N18583Niles Donald W · Wadena, MNBuilt 1972 · S/N 15073961 N18584Murphey Julian Ryan · Knoxville, TNS/N 15073962 N18586Flyit LLC · Camas, WABuilt 1972 · S/N 15073964 N18587Payne Frederick B · Fayetteville, GABuilt 1972 · S/N 15073965 N1858MCrowley Michael A · Wake Forest, NCBuilt 1972 · S/N 33701458 N1858QScott Air LLC · Cave Creek, AZBuilt 1972 · S/N 177RG0258 N1858XSalem Aero Club Inc · Bridgeton, NJBuilt 1964 · S/N 18255958 N1858YBlaich George F IV · Poplar Bluff, MOBuilt 1962 · S/N 17249458 N1858ZPairofminutes LLC · Marshville, NCS/N 205-0058 N18590Williams Michael · Williston, FLBuilt 1972 · S/N 15073968 N18594Robinson Ronald W · Saint Joseph, MIBuilt 1972 · S/N 15073970 N18596Baxter Wiley · Glennville, GABuilt 1972 · S/N 15073972 N18597Kiser Joshua Alan · Dry Ridge, KYS/N 15073973 N18598Gudgel Aviation · Lemoore, CABuilt 1972 · S/N 15073974 N1859FBaker Robert J · Ogema, MNBuilt 1966 · S/N 21058759 N1859UMustang Sally Aviation LLC · Camden, SCBuilt 2005 · S/N 172S9927 N185AAEoff Joe · Salem, ORS/N 185-0881 N185ABKinneen Simon N · Nome, AKBuilt 1981 · S/N 18504348 N185ADDurrett Aviation LLC · Anchorage, AKBuilt 1978 · S/N 18503576 N185AEDbl LLC · Hays, KSBuilt 1973 · S/N 18502125 N185AFTanada Lake Lodge LLC · Grand Junction, COBuilt 1973 · S/N 18502236 N185AHHattenburg Scott L · Chugiak, AKBuilt 1981 · S/N 18504263 N185AJKelly Christopher · Lantana, TXBuilt 1978 · S/N 18503560 N185AKFrench Joddy D · Wasilla, AKBuilt 1976 · S/N 18503006 N185ALBohannon James A III · Montgomery, TXBuilt 1961 · S/N 185 0047

Back to AD 79-10-14 R1