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.

N725BKAmerican Patrols Inc · Midland, TXBuilt 1971 · S/N 17259821 N725CMScholz Mark W · Atchison, KSBuilt 1997 · S/N 794-97 N725ECDraco Flight School Inc · Chino, CABuilt 1972 · S/N 17260842 N725HEOtt Edward C · Walnut Creek, CABuilt 2000 · S/N 441-2000 N725JMRegistered aircraftBuilt 1997 · S/N 798-97 N725RJWilliams Sol F · Jacksonville, FLBuilt 1971 · S/N 17260254 N725ZNLaramie Flying Club Inc · Laramie, WYBuilt 1979 · S/N 17272734 N7261GKindblade Aeronautics LLC · Casper, WYBuilt 1970 · S/N 17258961 N7261QSchilling Aviation Services LLC · Salina, KSS/N 17260561 N7262QFlikins Barbara L · Fillmore, CABuilt 1972 · S/N 17260562 N7263GHardy Chad A · Rush City, MNBuilt 1970 · S/N 17258963 N7263QWyatt Barbara Louise · Cheyenne, WYBuilt 1972 · S/N 17260563 N7264QAdams Rick B · Ashford, WABuilt 1972 · S/N 17260564 N7266DMelbourne Flight Training LLC · Melbourne, FLBuilt 1979 · S/N 17272912 N7266QLima-001 LLC · Muscatine, IABuilt 1972 · S/N 17260566 N7267GWells Jack D · Newtown, MOBuilt 1970 · S/N 17258967 N7269GBranson Barry R · Shasta Lake, CABuilt 1970 · S/N 17258969 N7269QBaker Mark · White Bear Lake, MNBuilt 1972 · S/N 17260569 N726ACGrass Roots Aviation LLC · Bend, ORBuilt 1999 · S/N 1276-99 N726AJStarr Alan D · Senoia, GABuilt 1969 · S/N 17701378 N726AWPhilbin Andrew Patrick · Cleveland, OHBuilt 2013 · S/N 1118-2012 N726JHClearview Flying Club Inc · Westminster, MDBuilt 1977 · S/N 17269494 N726MBBurgos Orlando · Venice, FLBuilt 1982 · S/N 17275766 N726MMRiverside Flight Academy LLC · Riverside, CABuilt 1979 · S/N 17272970 N7270GBruneau Paul G Jr · Madison, MEBuilt 1970 · S/N 17258970 N72727Hice Michael D · Cookeville, TNBuilt 1971 · S/N 177-01678 N727DCCalianno David · Spring Hill, FLBuilt 1974 · S/N 17702086 N727FValiair Ltd Co Trustee · Casper, WYBuilt 1981 · S/N P21000727 N727FWVoler Dans La Gloire LLC · Narberth, PABuilt 2012 · S/N 1121-2012 N727JBjdr Aero Corp · Wilmington, DEBuilt 1968 · S/N 680113 N727KCWest Michigan Flying Club Inc · Norton Shores, MIBuilt 1994 · S/N 24-3350 N727KRRogers Ronald J · Crystal Lake, ILBuilt 2022 · S/N 1221 N727LBMcnamee John B · Sugar Land, TXBuilt 1974 · S/N 177RG0626 N727LGYouth & Aviation Inc · Thiensville, WIBuilt 1968 · S/N 17256938 N727METruesdell Shannon · Stephenville, TXBuilt 1976 · S/N 17268426 N727MRUnavex Inc · Pensacola, FLBuilt 1979 · S/N 494-79 N727PANorat Richard N V · Kerrville, TXBuilt 1967 · S/N 670097 N727PMMiddlebrook Paul E · Penn Yan, NYBuilt 1981 · S/N 17275485 N727RCKelley Aircraft LLC · Weyers Cave, VABuilt 1974 · S/N 17263887 N727SFRenko Steven E · Elmira, NYBuilt 1968 · S/N 17256791 N727TLLangebrake Lawrence C · Saint Petersburg, FLBuilt 1977 · S/N 17269372 N727TSStreng Terry E · Columbus, OHBuilt 1973 · S/N 17262367 N727WSRobey Sean C · Camden, NCFirst renewal noticeBuilt 1978 · S/N 21063140 N7284GFisher Global LLC · Faulkner, ARBuilt 1970 · S/N 17258984 N7286QLacombe Bryan K · Rockwall, TXBuilt 1972 · S/N 17260586 N7287GTen Mile Ranch Inc · Vale, ORBuilt 1970 · S/N 17258987 N72884Hawkeye Aviation LLC · Miami, FLBuilt 1974 · S/N 17264315 N7288QAerosmith Aviation LLC · Marietta, GAFirst renewal noticeS/N 17260588 N728GLMartin James D · Graford, TXBuilt 1976 · S/N 0728 N728JBBex Inc · Wilmington, DEBuilt 2014 · S/N 560-2014

Back to AD 80-25-07 R1