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.

N2645KFowlkes John M Trustee · Marfa, TXBuilt 1978 · S/N 18053024 N2645LMchugh Eric P · Cleveland, TXS/N 17255845 N2645SVenice Group LLC · Hopkinton, NHS/N 337-0945 N2645VPapp Adam · Raleigh, NCBuilt 1948 · S/N 18155 N2646Sliger David W · Floral City, FLBuilt 1950 · S/N 19379 N2646FAmerican Driveaway LLC · Cowden, ILS/N 18256746 N2646UEarly Patricia A · Palmyra, PABuilt 1963 · S/N 17250246 N2646VEsslinger David F · Zionsville, INBuilt 1948 · S/N 18156 N2647FGayneaux Kelly J · Midland, TXS/N 18256747 N2647GAllen Steven L · Thatcher, AZBuilt 1959 · S/N 51947 N2647JHumble Tony R · Signal Mountain, TNBuilt 1966 · S/N 15065647 N2647KBoice Petroleum Consulting LLC · Pinedale, WYS/N 18053025 N2647LCommonwealth Aviation Services LLC · Herndon, VABuilt 1967 · S/N 17255847 N2647RSaber Wings LLC · Sacramento, CABuilt 1967 · S/N 18258347 N26481Accessible Aviation Inc · Tupelo, MSBuilt 1998 · S/N 17280578 N2648FLincoln Sport Parachute Club Inc · Lincoln, NEBuilt 1965 · S/N 18256748 N2648JColonial Air Inc · New Bedford, MABuilt 1966 · S/N 15065648 N2648LZangs William J · Poplar Grove, ILBuilt 1967 · S/N 17255848 N2648QBuck Irrigation Inc · Elkhart, KSBuilt 1966 · S/N 18257848 N2648SRegistration Pending · Albuquerque, NMRegistration pendingBuilt 1968 · S/N 337-0948 N2648URock Kenneth L · Petersburg, AKBuilt 1963 · S/N 17250248 N2648VWhite Jeffrey W · Macon, GABuilt 1974 · S/N 177RG0642 N2648YSw Aviation Services Inc · Queen Creek, AZBuilt 1955 · S/N 31676 N26499Advanced Aviation Group LLC · Frederick, MDBuilt 1999 · S/N 17280730 N2649FSkylane 2649f LLC · Kalispell, MTBuilt 1965 · S/N 18256749 N2649GSwanson Gregory N · Meridian, IDS/N 51949 N2649JN2649j LLC · Palm City, FLBuilt 1998 · S/N 17280599 N2649RShah Aitazaz · Shady Shores, TXBuilt 1967 · S/N 18258349 N2649UMorrison Kent · Mccleary, WAFirst renewal noticeBuilt 1963 · S/N 17250249 N2649VStedingh Donald M · Anchorage, AKBuilt 1948 · S/N 18159 N2649XK-Mcj Equipment LLC · Longview, TXS/N P206-0149 N264CAChoice Aviation LLC · Hamilton, MTBuilt 1975 · S/N 17266035 N264CTDouglass Joyce M · Christiansburg, VABuilt 1978 · S/N 17270716 N264EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13504 N264MSanterre Phillip E Trustee · Chugiak, AKBuilt 1958 · S/N 50236 N264SFAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 172S13407 N265E&S Management LLC · Miami, FLBuilt 1975 · S/N P3370232 N26502Bugsmasher Aviation LLC · Benton, KSBuilt 1998 · S/N 17280600 N26504Vista Aviation Inc · Pacoima, CABuilt 1998 · S/N 17280601 N2650DBrekke Aviation Inc · Edmore, NDBuilt 1952 · S/N 20802 N2650FFlight Time LLC · Highland, MIBuilt 1966 · S/N 18256750 N2650GNewkirk Kevin J · Manhattan, KSS/N 51950 N2650JNoll Cheryl A · Franklin, NCBuilt 1966 · S/N 15065650 N2650LRholetter Eric W · Westminster, SCBuilt 1967 · S/N 17255850 N2651FMars Aviation LLC · Commerce City, COBuilt 1965 · S/N 18256751 N2651LJohnson Turner C II · England, ARBuilt 1967 · S/N 17255851 N2651RAtls Aviation LLC · Stuart, FLBuilt 1998 · S/N 17280542 N2651VHagl Aviation LLC · Sunray, TXBuilt 1976 · S/N R1722226 N2652DScheidler Jerome P · Greensburg, INBuilt 1952 · S/N 20804 N2652FMartindale Lloyd M · Bellingham, WABuilt 1965 · S/N 18256752

Back to AD 79-10-14 R1