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.

N3251YCarlson Andrew J · Ashville, NYBuilt 1962 · S/N 18254251 N3252ABuddenberg Bradford C · Anchorage, AKBuilt 1953 · S/N 25896 N3252DQuigg Aircraft LLC · Muskegon, MIBuilt 1955 · S/N 32050 N3252LElizabethton Aerobatic Club Inc · Elizabethton, TNS/N 17256152 N3252SWhite Robert E · Woodlawn, TNBuilt 1964 · S/N 18255752 N3252TFugfugosh Mahdi A · Castro Valley, CABuilt 1967 · S/N 17700552 N3253SCobb Darrell V · Corsicana, TXBuilt 1964 · S/N 18255753 N3253VWilliams Cecil R · Clarksville, TNBuilt 1974 · S/N 15076443 N3254CCoon Vernon Ray · Atmore, ALBuilt 1967 · S/N 17256156 N3254JCarreiro Myriah L · Candia, NHBuilt 1966 · S/N 15065954 N3254LSelby Thomas A · Fenton, MIBuilt 1967 · S/N 17256154 N3254SAllen John C · Austerlitz, NYBuilt 1964 · S/N 18255754 N3254UWright Ronald J · Olympia, WABuilt 1963 · S/N 18254654 N3254VRegistration Pending · Bolivar, MORegistration pendingBuilt 1974 · S/N 15076444 N3255DAzul Aviation Inc · Fort Worth, TXS/N 32053 N3255LPatton Steven W · Fayetteville, ARS/N 17256155 N3256JMyers Benny R · Wasilla, AKBuilt 1966 · S/N 15065956 N3256TWoodfill Kyle · Lake Jackson, TXBuilt 1967 · S/N 17700556 N3256YCowden Mark T · Kerrville, TXBuilt 1962 · S/N 18254256 N3257DAlaska Dall Sheep Guides LLC · Anchorage, AKBuilt 1955 · S/N 32055 N3257EFlycarolina LLC · Concord, NCBuilt 1978 · S/N 17271482 N3257LBeene Jerry · Bulverde, TXBuilt 1967 · S/N 17256157 N3257SFelton Frank B III · Thorndale, TXBuilt 1964 · S/N 18255757 N3257YGilbert Donald L Jr · Ligonier, PABuilt 1962 · S/N 18254257 N3258SRockwood Spa LLC · Houston, MOBuilt 1964 · S/N 18255758 N3258VBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 1974 · S/N 15076445 N3258YByra Paula A · Pagosa Springs, COS/N 18254258 N3259AHalle Michael P · Livingston, TXBuilt 1953 · S/N 25903 N3259DLutes Stacy J · Mooresville, NCBuilt 1955 · S/N 32057 N3259JPreflight Aviation Inc · Oregon, WIBuilt 1966 · S/N 15065959 N3259RGlobal Marc Aire Inc · Dallas, TXBuilt 1973 · S/N U20602215 N3259UMoore Christopher · Canton, PABuilt 1963 · S/N 18254659 N3259VMaynard Richard L · Vilonia, ARBuilt 1974 · S/N 15076446 N3259YGrantham William Edward · Doerun, GAS/N 18254259 N325DDQuick Michael D · Middletown, CAS/N 21062748 N325MMBirdie Aviation LLC · Marble Hill, GABuilt 2007 · S/N 18281907 N325SPTfs Air LLC · Loveland, COBuilt 1999 · S/N 172S8251 N325SWSheroyair LLC · Sarasota, FLBuilt 2020 · S/N 18283097 N325UKilo Fox Aviation LLC · Saint Joseph, MIBuilt 1974 · S/N 15076531 N326Nardi Greg · Missoula, MTS/N P33700238 N3260LHerring Rhett H · College Station, TXBuilt 1967 · S/N 17256160 N3260SAbner Aviation LLC · Advance, NCS/N 18255760 N3260YOneal Gary · Springdale, ARBuilt 1962 · S/N 18254260 N3261DCastorina John Salvatore · Anthem, AZBuilt 1955 · S/N 32059 N3261MDyas Chris · Fairhope, ALBuilt 1998 · S/N 18280347 N3261SBig Island Gravity LLC · Kapaau, HIS/N 18255761 N3262JBlock Oliver L · Nashville, TNS/N 15065962 N3262LKd3262 LLC · Downers Grove, ILBuilt 1967 · S/N 17256162 N3262SIlair LLC · Manassas, VABuilt 1964 · S/N 18255762 N3263JCorrigan Air Center LLC · Hondo, TXS/N 18803623

Back to AD 79-10-14 R1