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.

N69DLIndy Air Sales LLC · Anderson, INS/N 24-0363 N69GCEwald John · Seguin, TXBuilt 2022 · S/N 621-2022 N69LNValiair Limited Co Trustee · Casper, WYBuilt 1979 · S/N 24-0764 N69RMDicicca Yolanda L · BitontoBuilt 1977 · S/N 177RG1204 N69WAKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1982 · S/N 21064707 N6ABCenterline Holdings Inc · Camden, DEBuilt 1969 · S/N 17258164 N6BCBest John · Cave Creek, AZBuilt 1993 · S/N 707-93 N6BEZephyr Enterprises Inc · Wilmington, DEBuilt 1977 · S/N 177RG1151 N6BNDevencenty Natalia · Pueblo, COBuilt 2022 · S/N 1201-2022 N6FDScud Air 6fd LLC · Morgan, UTBuilt 1991 · S/N 649-91 N6FVAlexis Asplundh Studio LLC · Atlantic Beach, FLBuilt 1978 · S/N 177RG1365 N6HMHenning Nancy E · Hardinsburg, KYBuilt 1972 · S/N 362-72 N6HNTalbott Philip A · Galena, OHBuilt 1971 · S/N 172-60326 N6MBSierra Whiskey Aircraft LLC · Oakland, CABuilt 1968 · S/N 17257279 N6NTNevada Defense Group LLC · Henderson, NVBuilt 1978 · S/N P21000109 N6TVTravelaire Service Inc · Wilmington, DES/N 17275278 N6WADue North Aviation LLC · League City, TXBuilt 1971 · S/N 17701676 N6ZPAmerican Patrols Inc · Midland, TXBuilt 1980 · S/N 17274020 N700Dailey Jeffrey D · Weirton, WVBuilt 1971 · S/N 317-71 N70000Carson Mark L Trustee · Northfield, MNBuilt 1976 · S/N 17267178 N70004Gbl Aviation LLC · Laurel, MSBuilt 1976 · S/N 17267179 N70032Alpha Wings Inc · Willoughby, OHBuilt 1976 · S/N 17267180 N70046Zane Newton F · Rllng Hls Est, CAS/N 17267183 N7004GMcgreen John R · Albany, NYBuilt 1969 · S/N 17258704 N70052Hastings Heidi · Wasilla, AKBuilt 1976 · S/N 17267185 N7005GHamilton Peter D · Bear, DEBuilt 1969 · S/N 17258705 N7005QCentral Arkansas Flying Club Inc · Bryant, ARBuilt 1971 · S/N 17260305 N70063Welch Thomas R DBA · Modesto, CABuilt 1974 · S/N 18801827T N7006QToney Edward L · Hampton, GABuilt 1971 · S/N 17260306 N70095Eastern Kentucky University · Richmond, KYBuilt 1976 · S/N 17267192 N7009QJoiner Legacy Enterprises LLC · Joliet, MTS/N 17260309 N700AGMash Kity J LLC · Grand Rapids, MIBuilt 1981 · S/N 172RG0670 N700CDCrahen William F · Merrimac, WIBuilt 1975 · S/N 177RG0788 N700CNHoleshot Aviation LLC · Lodi, CABuilt 1977 · S/N 961-77 N700CROneglia Francis G · Hawthorne, FLBuilt 1996 · S/N 24-3383 N700CWDelta Sierra Aviation LLC · Wills Point, TXBuilt 1980 · S/N 24-1055 N700DLArthur Aaron · Gold River, CABuilt 1981 · S/N 18267819 N700MGGeorgia Aviation Authority · Eastman, GABuilt 2018 · S/N 1176-2018 N700MTJoey O'S LLC · Darlington, PAS/N R18200996 N700PJShort Stephen A · Lake Placid, NYBuilt 1977 · S/N 17702628 N700RSTransavia LLC · Wilmington, DEBuilt 1981 · S/N P21000716 N700TPCreedon Robert A · Lompoc, CABuilt 1994 · S/N 24-3322 N7010GStavair LLC · Gulf Breeze, FLBuilt 1969 · S/N 17258710 N7010QMosman Matthew J · Nezperce, IDS/N 17260310 N7010VCompass Aviation Maintenance LLC · Shelby, NCBuilt 1976 · S/N 22-1362 N7010XCarrolls Auto And Aircraft Sales LLC · Muncie, INS/N 15285079 N7011GChase Development Aviation LLC · Oakland Park, FLBuilt 1969 · S/N 17258711 N7013GSaeid Abdelmasih · Euless, TXBuilt 1969 · S/N 17258713 N7013QVeil Casey J · Jamestown, NDBuilt 1971 · S/N 17260313 N7013VForsman Robert J · Yelm, WABuilt 1976 · S/N 22-1365

Back to AD 80-25-07 R1