Registered aircraft · 56,580

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.

N2909DPainter Kelly A · Cantwell, AKBuilt 1955 · S/N 26852 N2909SFatla Gregory F · Hixton, WIBuilt 1967 · S/N 15066809 N290CPCivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 18283321 N290FCRegistration Pending · Greenwood, MSRegistration pendingBuilt 1965 · S/N 18256135 N290FGTextron Aviation Inc · Wichita, KSS/N 172S13638 N290PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2022 · S/N 172S12864 N290RMCxairco LLC · Yuma, AZBuilt 2010 · S/N 18282215 N290TWChristiansen Aviation LLC · Wilmington, DEBuilt 2001 · S/N 172S9020 N290UOhio University · Albany, OHBuilt 2000 · S/N 172S8551 N291Northern Sky LLC · Dover, DEBuilt 1976 · S/N P3370234 N29107Wrong Brothers Aviation LLC · Brighton, MIBuilt 1974 · S/N 17264100 N2910DDomke Daniel Carl · Anchorage, AKS/N 26857 N2910JWeldy Mark L · Etna Green, INBuilt 1966 · S/N 15065710 N2910XTallman Richard E · Lykens, PABuilt 1967 · S/N 17700310 N29110Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1968 · S/N U206-1080 N29113Figueroa Angel Lara · Winfield, ALBuilt 1973 · S/N 21059806 N29114Grey Goose LLC · Wasilla, AKBuilt 1968 · S/N U206-1084 N2911DPagano Ralph V · Cranbury, NJBuilt 1979 · S/N 18267459 N2911EAsphaltresource.Com LLC · Schwenksville, PABuilt 1982 · S/N 18268220 N2911FRegistration Pending · Fayetteville, ARRegistration pendingBuilt 1966 · S/N 18257011 N2911UNight Sky LLC · Canton, SDBuilt 1963 · S/N 17250511 N2911XRobbins Donald V · Anchorage, AKBuilt 1967 · S/N 17700311 N2911YBennett John M · Cameron, NCBuilt 1962 · S/N 18253911 N29127Shivers William L Jr · Friday Harbor, WABuilt 1968 · S/N U206-1097 N2912CMarshalee Arizona LLC · Tempe, AZBuilt 1954 · S/N 30812 N2912DSatanta Flying Service Inc · Satanta, KSS/N 26855 N2912SWard Ascher · Oxnard, CAS/N 15066812 N29130Ernst Gregory R · Eagle Creek, ORS/N U206-1100 N29138Allen Brent H · Mammoth Lakes, CABuilt 1973 · S/N 21059815 N2913CUnable Direct LLC · Kalispell, MTBuilt 1954 · S/N 30813 N2913DSale Reported · Nome, AKSale reportedS/N 26856 N2913EG & M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 17271371 N2913JMulti Engine Training Co Inc · Tuttle, OKS/N 15065713 N2913SMartin Richard E · Palmyra, WIBuilt 1967 · S/N 15066813 N29142Hall Darryl Wayne II · Wasilla, AKS/N U206-1112 N2914CSterkel Jared · Anchorage, AKBuilt 1954 · S/N 30814 N2914FHarris Zadok · Upland, CABuilt 1965 · S/N 18257014 N2914JMaverick Aviation Holdings LLC · Sheridan, WYS/N 15065714 N2914KWildness Aviation Limited · Morrison, COS/N 18053127 N2914USethi Inderdeep S · Tracy, CABuilt 1963 · S/N 17250514 N29151Inland Aerial Surveys Inc · Riverside, CABuilt 1968 · S/N U206-1121 N29159Southridge Developments Inc · San Miguel, CAFirst renewal noticeBuilt 1974 · S/N 17264103 N2915CField Jeff H · Simi Valley, CAFirst renewal noticeBuilt 1954 · S/N 30815 N2915DUlrich Craig T · Albany, ORS/N 26858 N2915FStoffregen Thomas S · Milton, WVBuilt 1966 · S/N 18257015 N2915SKoch Kenneth Scott · Coolidge, AZS/N 15066815 N29160Felber Dave A · Florissant, MOBuilt 1974 · S/N 17264104 N29164Iturriria John · Kuna, IDBuilt 1968 · S/N U206-1133 N29168Galer Michael J Jr · Lockwood, MOBuilt 1974 · S/N 17264105 N2916AMetro Service Air Inc · Fairbanks, AKBuilt 1953 · S/N 30116

Back to AD 79-10-14 R1