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.

N11272Williamson Brett O · Essex, MOBuilt 1973 · S/N 15075289 N1127DWings Over Texas Holdings LLC · Denton, TXBuilt 2006 · S/N 172S10247 N1127FPricemeyer Aviation LLC · St Pete Beach, FLS/N 17254722 N1127YWong David · Torance, CABuilt 1962 · S/N 15059527 N11281Solovjev Jadranka · Sarasota, FLS/N 15075295 N11283J F Aviation Inc · Joliet, ILBuilt 1973 · S/N 15075297 N11285Northeast Florida Aero Club Inc · Fleming Island, FLBuilt 1973 · S/N 15075299 N11289Phelps Aero Co LLC · Salem, ORBuilt 1973 · S/N 15075302 N1128CGibbs Wyatt R · Lodi, CABuilt 1978 · S/N 21062711 N1128FLockridge James · Adairsville, GAS/N 17254723 N1128UElw Inc · Bonners Ferry, IDBuilt 1976 · S/N 17266857 N1128YPerez Donna · Chico, CABuilt 1962 · S/N 15059528 N11290Safety In Motion Flight Center Inc · Puyallup, WABuilt 1973 · S/N 15075303 N11295Bancroft David J · Rio, WIBuilt 1973 · S/N 15075305 N11297Raley James C · Brandon, SDBuilt 1973 · S/N 15075307 N11299Creech John M · Brentwood, TNS/N 15075309 N1129CLanier Equipment Leasing LLC · Gainesville, GABuilt 2018 · S/N 172S12227 N1129DKogl John L · Valparaiso, INBuilt 1951 · S/N 15692 N1129FKoch Bradley D · Billings, MTBuilt 1966 · S/N 17254724 N1129KOrange County Flight Center Inc · Santa Ana, CABuilt 2006 · S/N 172S10315 N1129MTechair LLC · Playa Vista, CAS/N 17252240 N1129PBonzo Air LLC · Saint Petersburg, FLBuilt 2005 · S/N 18281584 N1129USchroeder Herbert D · Plano, TXBuilt 1976 · S/N 17266858 N112APAerospace Trust Management LLC Trustee · Wilmington, DES/N 17262038 N112DSCarter Erick D · Eugene, ORBuilt 1977 · S/N 18265826 N112EWKerwin Patrick C · Redwood City, CABuilt 1974 · S/N 21060504 N112GCSkywagon Ventures LLC · Chapel Hill, NCBuilt 1973 · S/N 18052387 N112LDMartin Joseph S · Carrollton, KYS/N 15076178 N112LNBruce James W · Searcy, ARBuilt 1972 · S/N 15073504 N112NBillingsley Carl · Henderson, TXBuilt 1956 · S/N 28584 N112NBCarew Enterprises Inc · Appleton, WIBuilt 1973 · S/N 15074671 N112NCFrance Jay D · Colbert, GABuilt 1970 · S/N 17701598 N112NL1st American Aviation Inc · North Miami, FLS/N 18258322 N112PFEastern Kentucky University · Richmond, KYBuilt 1998 · S/N 17280400 N112PZSkymaxx Inc · Daytona Beach, FLBuilt 2005 · S/N 172S9833 N112QBFloyd Austin · Searcy, ARBuilt 1955 · S/N 26952 N112RPTaylor Chad A · Enid, OKBuilt 1950 · S/N 19422 N112SPMinnesota Department Of Public Safety · Saint Paul, MNBuilt 2019 · S/N 18283086 N112SSOlsen John · Wasilla, AKS/N 18052510 N112SVGb Aviation Of Alabama LLC · Millry, ALBuilt 2003 · S/N 172S9380 N112VBHatley Ralph A · Eagle Creek, ORBuilt 1963 · S/N 18254937 N11305Logsdon Elizabeth M · Morganfield, KYBuilt 1973 · S/N 15075314 N11308Kaher Kevin G · Menlo Park, CABuilt 1973 · S/N 15075317 N1130FMonahan William T · Vestal, NYBuilt 1966 · S/N 17254725 N1130UTc Aviation LLC · Denham Springs, LAS/N 17266859 N1131MWhite Tom · South Charleston, WVBuilt 1975 · S/N 18264228 N1131WPrice Steven D · Healdsburg, CABuilt 1976 · S/N 18264584 N11322Creekside Speech Therapy LLC · Ocala, FLFirst renewal noticeBuilt 1973 · S/N 15075328 N11323Huckabay Timothy J · Red Bluff, CABuilt 1973 · S/N 15075329 N11329Burkhart Verlus L · Fairmont, MNBuilt 1973 · S/N 15075332

Back to AD 79-10-14 R1