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.

N12885Above & Beyond Aviation LLC · Sandy Hook, CTBuilt 1973 · S/N 17262342 N12886Wings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17262343 N12887Slipstream Aviation LLC · Calera, ALBuilt 1973 · S/N 17262344 N1288DConner Brent F · Medford, ORBuilt 1951 · S/N 19861 N1288MRagsdale Michael R · Eustis, FLS/N 33701288 N1288QCahill Chad · Edmond, OKS/N 15072588 N1288SFrench Oil Co · Midland, TXBuilt 1976 · S/N 18264855 N1288VRegistration Pending · Wallace, CARegistration pendingS/N R1722159 N12893Weiss Lyle D · Faith, SDBuilt 1973 · S/N 17262348 N12897Foothill Aircraft Sales & Service Inc · Upland, CABuilt 1973 · S/N 17262352 N12898Nova Ivan · Hackensack, NJS/N 17262353 N12899Lyon Kimberly J · Layton, UTBuilt 1973 · S/N 17262354 N1289DAeronautical Technical Service Inc · Collierville, TNS/N 19865 N1289QLong Jeffrey K Trustee · The Villages, FLBuilt 1971 · S/N 15072589 N1289UKavak Air Inc · Middletown, DEBuilt 1982 · S/N 21064682 N1289YBravo Leasing LLC · Daytona Beach, FLBuilt 2005 · S/N 172S9851 N128BWRodriquez Roy L DBA · Martin, TNBuilt 1969 · S/N 18260080 N128CGMontaez Torrez Raul · Guaynabo, PRBuilt 1968 · S/N 17256621 N128EPPalicki Anthony J · Huntsville, ALBuilt 1985 · S/N 172-76482 N128HRDerenick Aviation LLC · Aguadilla, PRS/N 17262679 N128JRMorris Dylan L · Garden Plain, KSBuilt 1976 · S/N 18264785 N128MAFca Flight Center Inc · Fitchburg, MABuilt 1975 · S/N 17263941 N128RVande Hei Joshua G · Kaukauna, WIBuilt 1968 · S/N 17256984 N128RRRegistered aircraftS/N 15070734 N128SCIasco Flight Training Inc · Redding, CABuilt 1999 · S/N 172S8250 N128SHCalifornia In Nice Inc DBA · San Jose, CABuilt 2020 · S/N 172S12457 N128SWRegistered aircraftBuilt 1966 · S/N 18051699 N128TTWarner Wings LLC · Yakima, WABuilt 1979 · S/N U20604991 N12901American Patrols Inc · Midland, TXBuilt 1973 · S/N 17262356 N12902Total Flight Aircraft Leasing LLC · Apex, NCBuilt 1973 · S/N 17262357 N12908M & R Management Consulting Inc · Fort Meade, FLNon-citizen corporation, flight hours not reportedS/N 17262362 N1290FKilm LLC · Wilmington, NCBuilt 2007 · S/N 18282045 N1290KN1290k LLC · Dover, DEBuilt 1965 · S/N 18256650 N1290MGardner Michael John · Ashland, ILBuilt 1975 · S/N 18264275 N12916Jacobs Airways Inc · Wilson, WIBuilt 1973 · S/N 17262369 N12917Dewhurst Donna A · Anchorage, AKBuilt 1973 · S/N 17262370 N12918Ashland/Boyd County Regional Airport Authority · Worthington, KYBuilt 1973 · S/N 17262371 N12919Gibson Aviation Services LLC · Menomonie, WIBuilt 1973 · S/N 17262372 N1291FRegistered aircraftBuilt 1979 · S/N 17272986 N1291MCon Air Aviation LLC · Westerville, OHBuilt 1975 · S/N 18264276 N1291PPowers Elbie L · Roseboro, NCBuilt 1965 · S/N 18256573 N1291SAvidyne Corp · Melbourne, FLBuilt 1976 · S/N 18264858 N12923Roberts Cody A · Lueders, TXBuilt 1973 · S/N 17262375 N12926Norton Boe L · Carlsbad, NMBuilt 1973 · S/N 17262378 N1292CTrout Island Transit LLC · Glen Ellyn, ILBuilt 1977 · S/N 17702696 N1292DKlaerner John D · San Antonio, TXBuilt 1951 · S/N 19868 N1292FRustair Inc · Anchorage, AKBuilt 1975 · S/N 18502668 N1292MCool Change Rentals LLC · Beaufort, NCBuilt 1975 · S/N 18264277 N1292UFlynn James M · Plain City, OHBuilt 1976 · S/N 17266986 N1292YCarbiener Ross E · Kewanee, ILBuilt 1962 · S/N 15059692

Back to AD 79-10-14 R1