Registered aircraft · 25,369

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N139PCSavage David Edward · American Falls, IDBuilt 2002 · S/N 1339-2002 N13CBT&W Aviation LLC · Pinehurst, TXBuilt 1981 · S/N 17274805 N13EAHood Norman R · Austin, TXBuilt 1977 · S/N 15279914 N13HKSkycombers Flying Club Inc · Pacoima, CABuilt 1972 · S/N 17701810 N13JHL J H Consulting LLC · Greenleaf, IDBuilt 2021 · S/N 617-2021 N13JTHoltzclaw Timothy M · O Brien, FLBuilt 1972 · S/N 17261008 N13KKSanders Flight Training Center Inc · Jasper, ALBuilt 1977 · S/N 17268760 N13LGN13lg Aviation LLC · Dover, DEBuilt 2017 · S/N 1473-2017 N13MDMoorstein Mark A · Manassas, VABuilt 1967 · S/N 680025 N13NSThirteen November Sierra LLC · Herriman, UTS/N 24-3122 N13PBZimmerman Michael P · Verona, WIBuilt 2022 · S/N 1483-2022 N13PMFly High Aviation LLC · Melrose Park, ILBuilt 1977 · S/N 305-77 N13RHChrist Graham Charles · Mandeville, LABuilt 1973 · S/N 973-73 N13SKFlydreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1978 · S/N 17271183 N13TATextron Aviation Inc · Wichita, KSS/N 17276111 N13TEMaddox Eric L · Grover Beach, CABuilt 1978 · S/N 24-0700 N13TPLehman Aviation LLC · Remington, INBuilt 1976 · S/N 17267454 N13WLRegistration Pending · Bristol, SDRegistration pendingBuilt 2020 · S/N 605-2020 N13YCBuckin 307 Taildraggers LLC · Casper, WYBuilt 1976 · S/N 590-76 N13YPBlock Scott M · Chandler, AZBuilt 1968 · S/N 17257055 N1400Salour Michael M · Carlsbad, CABuilt 1979 · S/N P210-00277 N1401EUnited States Air Force Aero Club · Usaf Academy, COBuilt 1978 · S/N 17270986 N14038Eagle Aviation And Logistics LLC · Cheyenne, WYS/N 700017 N1403VSmith Dennis A Trustee · Salem, ORBuilt 1974 · S/N 17263550 N1404CAeroscalper LLC · Goshen, INBuilt 1977 · S/N 17702721 N14050M & K Flying Service Inc · Hot Springs Vill, ARBuilt 1975 · S/N 857-75 N1405UGuardian Aerial Patrol LLC · Edmond, OKBuilt 1976 · S/N 17267075 N1406CMcaninch Danny Ray · Pleasant Hill, CABuilt 1977 · S/N 17702722 N1407UN R I Flying Club · Walnut Creek, CABuilt 1976 · S/N 17267077 N1408CHaworth Michael R · Riverside, CABuilt 1977 · S/N 17702723 N140FPNorthwoods Air LLC · Orono, MEBuilt 1986 · S/N 17276539 N140PCNavigation Leasing LLC · Castle Rock, COBuilt 1976 · S/N 17268241 N140WTFly Whiskey Tango LLC · Scottsdale, AZBuilt 1984 · S/N 17276201 N1410URuffcorn Aviation Co · Bettondorf, IABuilt 1982 · S/N 21064693 N1411UOxley Kevin L · Huntington, INBuilt 1976 · S/N 17267080 N1412MLes Ailes Libres Inc Trustee · Wilmington, DEBuilt 1988 · S/N 24-1639 N1414VMoeller Rita L · Rescue, CABuilt 1974 · S/N 17263559 N1415USale Reported · Miami, FLSale reportedBuilt 1976 · S/N 17267083 N1416ESalem Pilots Association · Salem, ORBuilt 1978 · S/N 17270989 N1416UEddy Elizabeth H · Tunbridge, VTBuilt 1976 · S/N 17267084 N1417UWings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267085 N1417VSkyhawk Aviation LLC · Rutherfordton, NCS/N 17263562 N1418VBeverly Flight Center LLC · Middleton, MABuilt 1974 · S/N 17263563 N1419CVetrone Troy · Wisconsin Rapids, WIBuilt 1977 · S/N 17702724 N141BCAtkinson Air LLC · Dixon, CABuilt 2020 · S/N 602-2020 N141BHBob Hannah Aviation LLC · Caldwell, IDBuilt 2022 · S/N 623-2022 N141CHRegistered aircraftBuilt 1979 · S/N 324-79 N141JGCardinal 1jg LLC · Bakersfield, CABuilt 1968 · S/N 17700930 N141JSGeurin Ronnie C · Murray, KYBuilt 1979 · S/N 383-79 N141PFFordham Aviation Inc · Eastman, GABuilt 1978 · S/N 17271503

Back to AD 80-25-07 R1