OpenAirDocs.org
AD 80-25-02 R2

Registered aircraft · 6,349

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
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-02-R2')
    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-02-R2')
  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.

N577FCFlight Club · Middle River, MDS/N WA-43N5780HPlane Fun Inc Tr Trustee · Snellville, GABuilt 1949 · S/N 16-393N5780ZBergstrom Robert L · Amelia Court House, VABuilt 1963 · S/N 22-9625N5782HTomas Douglas J · East Troy, WIBuilt 1949 · S/N 16-397N5783HBellas Bryan T · Geneva, OHBuilt 1949 · S/N 16-398N5783ZAlix Brian R · Valley Falls, NYBuilt 1963 · S/N 22-9627N5784HWright William J · Raeford, NCS/N 16-399N5785LVance Marc G · Canal Winchester, OHBuilt 1969 · S/N AA1-0185N5786HLynn Leroy D · New Carlisle, OHBuilt 1949 · S/N 16-402N5787HLagace Donald O · Augusta, MEBuilt 1949 · S/N 16-403N5787ZFaust David E · Windber, PAS/N 22-9631N5788HMillar George B · Le Claire, IABuilt 1949 · S/N 16-404N5789HBlumer Charles · Fullerton, CAS/N 16-405N5790LSeveca Ventures LLC DBA · Arcola, TXBuilt 1969 · S/N AA1-0190N5791LGuytek Aviation LLC · Margate, FLS/N AA1-0191N5793HZrelak Patrick · Apple Valley, CAFirst renewal noticeBuilt 1949 · S/N 16-409N5794HChristopherson Jack T Trustee · Overgaard, AZS/N 16-410N5794LVanhorn Wyatt A · Macon, GAS/N AA1-0194N5796ZJankow Edward W · Clinton Township, MIBuilt 1963 · S/N 22-9647N5798HKroenlein Donald G · Moweaqua, ILBuilt 1949 · S/N 16-414N5799LYoder George R · North Pole, AKBuilt 1969 · S/N AA1-0199N57KGGuy Kenneth L · Ocala, FLBuilt 1993 · S/N 2209N57MSStreitz Mark · Joliet, ILBuilt 1999 · S/N GB-2N57PKKitchen Phillip L · Waterloo, ILBuilt 2017 · S/N 1PKN5801HRodriguez Nicholas · Titusville, FLBuilt 1949 · S/N 16-417N5804ZColyer Gregory W · San Rafael, CABuilt 1963 · S/N 22-9657N5807HCollins James T · Blossvale, NYBuilt 1949 · S/N 16-424N5808HReady Aim Flyer LLC · Hockessin, DEBuilt 1949 · S/N 16-425N5809ZLuckett Dennis G · Upland, CABuilt 1963 · S/N 22-9665N5810HInternational Air Services Inc Trustee · Carson City, NVBuilt 1949 · S/N 16-426N5813HLoewen Walter · Kodiak, AKBuilt 1949 · S/N 16-430N5813ZSmith Gregory E · White Lake, MIBuilt 1963 · S/N 22-9670N5814HPapich William · Boston, NYBuilt 1949 · S/N 16-431N5815HZernechel Craig A · Rockford, ILBuilt 1949 · S/N 16-432N5816ZPerdew Paul T · Mcfarland, WIBuilt 1963 · S/N 22-9674N5817HPiper Aviation Museum Foundation · Lock Haven, PABuilt 1949 · S/N 16-434N5817ZLamb Matthew P · Edmond, OKBuilt 1963 · S/N 22-9644N5818HSlatter Lowell J · Buhl, IDBuilt 1949 · S/N 16-447N5819HGaniere Constance L · Kemp, TXFirst renewal noticeBuilt 1949 · S/N 16-435N5819ZCristando Robert J · Wolfeboro, NHBuilt 1963 · S/N 22-9676N5821HFifer Lucas J Trustee · Charlestown, INS/N 16-437N5821PCummings Mark R · Laveen, AZS/N 121N5822ZHogan Gerard T · Rockford, ILBuilt 1963 · S/N 22-9679N5832HForcey Charles F · Westville, INBuilt 1949 · S/N 16-450N5833HSchipul Melissa J · New Milford, CTBuilt 1949 · S/N 16-446N5833ZGrossman Larry R · White Pigeon, MIBuilt 1963 · S/N 22-9664N5834HPierce Gilbert H · Germantown, TNBuilt 1949 · S/N 16-453N5835ZNiemela Blair K · Wasilla, AKBuilt 1963 · S/N 22-9688N5836ZGaines Jesse B · Bryan, OHBuilt 1963 · S/N 22-9689N5838HPoliti Terris P · Lake Placid, NYFirst renewal noticeBuilt 1949 · S/N 16-457
Back to AD 80-25-02 R2