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.

N246PAHugie Lucas R · Logan, UTS/N 18257487 N246SFAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 172S13442 N246SPWingsleasing LLC · Wichita, KSBuilt 1977 · S/N 17269023 N246TRegistered aircraftBuilt 1981 · S/N 18268091 N246VTAkwe River Flying And Guide Service LLC · Yakutat, AKBuilt 1975 · S/N U20602822 N2470BAlpha International Aircraft Inc · Lewes, DEBuilt 2005 · S/N 172S10069 N2470CMcclymond Tyler L · Grand Junction, COS/N 30770 N2470FMeridian Aviation LLC · Lincolnton, NCBuilt 2000 · S/N 18280890 N2470GBaillargeon Richard W · Springville, IABuilt 1959 · S/N 51770 N2470LSmith Joseph · Sycamore, ILBuilt 1966 · S/N 17255670 N2470NAlpha International Aircraft Inc · Lewes, DENon-citizen corporation, flight hours not reportedS/N 172S10187 N2470PFisher Air LLC · Cardington, OHBuilt 2000 · S/N 18280891 N2470QCities Aviation Services LLC · Dubberly, LABuilt 1966 · S/N 18257670 N2470UT C I Aviators LLC · Lewes, DEBuilt 1963 · S/N 17250070 N2471CCavjet LLC · Bonham, TXBuilt 1954 · S/N 30771 N2471DWestern Edge Aviation LLC · Dickinson, NDBuilt 2000 · S/N 18280892 N2471JKrisch Garry A · Kenedy, TXBuilt 1966 · S/N 15065571 N2471QThomas Salvatore J · Lenoir City, TNBuilt 1966 · S/N 18257671 N2471RFykerud Eric J Sr · Bend, ORBuilt 1964 · S/N 18255571 N2471YRegistered aircraftBuilt 1962 · S/N 17249771 N2472FParr Crawford B · Anchorage, AKBuilt 1966 · S/N 18051674 N2472QSalzman Denise M · Cameron Park, CABuilt 1966 · S/N 18257672 N2472RVac New Inc · China Village, MENon-citizen corporation, flight hours not reportedBuilt 1964 · S/N 18255572 N2472UMustang Sally Aviation LLC · Camden, SCBuilt 2005 · S/N 172S10074 N2472XPhillips Robert Frank · Tabernacle, NJBuilt 1965 · S/N 18256372 N24738H2link Co · Lewes, DEBuilt 2001 · S/N 172S8789 N2473CLewis Eddy L · Cortez, COBuilt 1954 · S/N 30773 N2473GFly For Fun Aircraft LLC · Baltimore, MDBuilt 2001 · S/N 17281019 N2473RRonald O Holcomb LLC · Lapeer, MIBuilt 1964 · S/N 18255573 N2473ZGulf Coast Aviation LLC · New Orleans, LABuilt 2005 · S/N 172S10082 N24748Delta State University · Cleveland, MSBuilt 2001 · S/N 17281051 N2474CArchitectural Industrial Rentals LLC · Wilmington, DEBuilt 2001 · S/N 18280978 N2474DDavidson Chad E · Roxton, TXBuilt 1952 · S/N 20626 N2474EBas Part Sales LLC · Greeley, COS/N 17271297 N2474JSingleton Addison L · New Bedford, MABuilt 1966 · S/N 15065574 N2474NWestbank Fishing LLC · Kiln, MSS/N 18280980 N2474QBurnet Aviation Group LLC · Bertram, TXBuilt 1966 · S/N 18257674 N2474SEllison William K · Tipton, INBuilt 1967 · S/N 337-0774 N2474UPistor Elise D · Colleyville, TXBuilt 1963 · S/N 17250074 N2474XKramer William L · Wellington, FLBuilt 1965 · S/N 18256374 N2474YLogan Air Services LLC · Logan, UTBuilt 2005 · S/N 172S10083 N24756Wings Over Texas Holdings LLC · Denton, TXBuilt 2005 · S/N 172S10086 N2475CHansen Curtis · Merrimack, NHBuilt 1954 · S/N 30775 N2475DGresley Ross A · Catawba, NCS/N 20627 N2475LDeralex Airways LLC · Miami, FLBuilt 2001 · S/N 17280990 N2475QStumpf Walter · Tulsa, OKBuilt 1966 · S/N 18257675 N2475XJohnston Bruce W · Puyallup, WABuilt 1965 · S/N 18256375 N2476CBrown Jack P · Anchorage, AKBuilt 1954 · S/N 30776 N2476ESkyspot Advertising LLC · Lakeland, FLBuilt 2001 · S/N 172S8784 N2476JCrosshares Aircraft Holdings LLC · Plymouth, INBuilt 2001 · S/N 172S8785

Back to AD 79-10-14 R1