OpenAirDocs.org
AD 80-25-02 R2

Registered aircraft · 6,348

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.

N2880GDixon Walter G · Fuquay Varina, NCBuilt 1967 · S/N 457N2880MAbalama Arthur C · Bethel, AKBuilt 1946 · S/N 12-1309N2883MRegistered aircraftBuilt 1946 · S/N 12-1423N2884ZSpurgeon Paul M · Brooksville, MSBuilt 1978 · S/N 1239-78N2888MLapoint Daniel L Jr · Bellevue, MIBuilt 1946 · S/N 12-1426N2888ZHonkomp Daniel · Euless, TXBuilt 1978 · S/N 1270-78N288LLWitold Siekaj · Port Townsend, WAS/N AA1B-0365N288RBBurton Ray A · Cheyenne, WYBuilt 1994 · S/N 288N288TBecker James · Torrington, WYBuilt 1953 · S/N 18-2402N2892MFoster Randy · La Grange, TXBuilt 1947 · S/N 12-1311N2895ZRao Enterprises LLC · Brighton, MIS/N 1242-78N2898MPutman John Vick · San Antonio, TXBuilt 1946 · S/N 12-1434N289TMahan Tyler J · King Salmon, AKFirst renewal noticeBuilt 1953 · S/N 18-2403N28FCFlight Club · Middle River, MDBuilt 1981 · S/N WA-266N28HAHonaker Group LLC · Sellersburg, INBuilt 1978 · S/N 17271942N28ZACendejas Agustin · Chino, CAFirst renewal noticeS/N 200028N2900MPiper Aircraft Inc · Vero Beach, FLBuilt 1962 · S/N 29-01N2901MRickard William A · Virginia Beach, VABuilt 1946 · S/N 12-1325N2902MKelsey Michael O · Carey, IDBuilt 1946 · S/N 12-1362N2903MKrog Steven L · Hartford, WIBuilt 1946 · S/N 12-1327N2907MKutschera Thomas C · Youngsville, NYBuilt 1946 · S/N 12-1322N2910MEkdahl John Edward · Freehold, NJBuilt 1946 · S/N 12-1436N2913Brown Engineering Solutions · Lafayette, INBuilt 2011 · S/N 200N2913MMccay Brian D · Earlysville, VABuilt 1946 · S/N 12-1444N2916MBradford Murvin L · Hensley, ARS/N 12-1417N2919MPiccione Joseph A · Washington, NJBuilt 1946 · S/N 12-1427N291PFarmer Aidan · Canton, MIBuilt 1982 · S/N 291N2920MLaney Charles A · Maiden, NCBuilt 1946 · S/N 12-1326N2923MCunningham David M · Eagle River, AKBuilt 1946 · S/N 12-1429N2923ZAnkole Watusi Cattle Company LLC · Leesburg, FLBuilt 1978 · S/N 1244-78N2925MBedgar Dean Jr · Lexington Park, MDBuilt 1946 · S/N 12-1428N2926WSessoms Keith V · Seagrove, NCS/N 15284388N2929MSale Reported · Casa Grande, AZSale reported, pending cancellationBuilt 1946 · S/N 12-1331N2929TTampa Bay Flying Club Corp · Tampa, FLS/N 22-9630N2930MYoung Timothy T · Wasilla, AKBuilt 1946 · S/N 12-1332N2933MAllen Glenn · Landenberg, PABuilt 1946 · S/N 12-1439N2934MConrad Donald C · De Pere, WIBuilt 1946 · S/N 12-1447N293ACWeaver Roger D · Sarasota, FLBuilt 1995 · S/N 1355-95N293THenderson Donald G · Bedford, INS/N 18-2407N2942MClark John T · Elbert, COBuilt 1947 · S/N 12-1337N2943GVan Ness James A · Buckley, WABuilt 1968 · S/N 517N2943MWidman Eric J · Palmer, AKBuilt 1946 · S/N 12-1336N29452Parsons Walter E · Clinton, NCS/N 4240TN2952MBrown Ben · Kasilof, AKBuilt 1946 · S/N 12-1347N2953MFawcett Walter L Jr · Wolfeboro, NHBuilt 1946 · S/N 12-1348N2956ZAm Flite Inc · Valley, NEBuilt 1978 · S/N 1245-78N295CMBesst John V · Lady Lake, FLBuilt 1979 · S/N 1424N295JFMartin Christian · Port Orange, FLBuilt 1991 · S/N 295N295THendrickson Elisabeth A · Kerrick, MNBuilt 1953 · S/N 18-2409N2963MSouthmost Aviation Inc · Brownsville, TXBuilt 1946 · S/N 12-1357
Back to AD 80-25-02 R2