OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,370

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-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.

N275ACTsutsumi Erika E · Boston, MABuilt 1998 · S/N 1372-98N275GTPs N275gt LLC · Green Bay, WIBuilt 1978 · S/N 17271631N275MAFranzoy Steve · Salem, NMS/N 1014-2006N2760VFinish Line - N2760v LLC · Edmond, OKS/N 177RG0686N2760WHardin Robert S · Renton, WABuilt 1966 · S/N 1050N2762WRouth Frank D · Marion, NCBuilt 1966 · S/N 1052N2763GWilko Air LLC · Van Wert, OHBuilt 1967 · S/N 459N2765WBriseno Anthony · Virginia Beach, VABuilt 1966 · S/N 1168N2767PMatta Sam · Brookshire, TXBuilt 1976 · S/N 255-76N2767WMorrow Frank D · Wooster, OHBuilt 1966 · S/N 1055N2768VThree Spirit Ventures LLC · Wayne, PABuilt 1975 · S/N 177RG0691N2768WGlenn Larry W · Bunn, NCBuilt 1966 · S/N 3355N2769WHarper Leonard D · Peyton, COBuilt 1966 · S/N 3356N276CKHuckabee Charles J · Seadrift, TXBuilt 1982 · S/N R18201852N276RSchwam Julie R · Hayden, IDS/N 713-93N2770WSteele John A · La Habra, CABuilt 1966 · S/N 1056N2771WMooney Patrick D · Anacortes, WABuilt 1966 · S/N 1057N2772GSchultz Jason G · Crowley, LABuilt 1967 · S/N 460N2773VBeale Air Force Base Aero Club · Beale Afb, CABuilt 1975 · S/N 177RG0694N2774JPerez Guillermo · Castaic, CABuilt 1979 · S/N 17273649N2775EFaulkner Harry E Jr · Bethel, AKBuilt 1978 · S/N 17271316N2775RMiller David · Tyler, TXBuilt 1980 · S/N 172RG0624N2776EAugusta Flying Club Inc · Martinez, GABuilt 1978 · S/N 17271317N2776WBowers Curt E · Jennings, LAS/N 1060N2777ETop Flight Aviation Inc · Corona, CABuilt 1974 · S/N 17262885N2777TAviator Air Flight School LLC · Grand Prairie, TXBuilt 1972 · S/N 17261147N2778ZLarson Kris Kendrick · Fullerton, CABuilt 1978 · S/N 370-78N277CBN277cb LLC · Jacksonville, FLBuilt 1976 · S/N 17267516N277MANickell Paul D · Milo, IABuilt 2003 · S/N 1354-2003N277SLCharlies Wings LLC · Salisbury, NCBuilt 1973 · S/N 17261652N27808St George Flight Academy LLC · St George, UTBuilt 1971 · S/N 17260023N2783WCrain James D · Hood River, ORBuilt 1966 · S/N 3361N2784WBoeckman Thomas J · Carroll, IABuilt 1966 · S/N 3362N2785WNienaber David K · Colorado Springs, COBuilt 1966 · S/N 1065N2787WWhite Gary L · Ashland, KSBuilt 1966 · S/N 1067N2789WShort Robert N II · Lincoln, CABuilt 1966 · S/N 1169N278ACLetourneau University · Longview, TXBuilt 2001 · S/N 1385-2001N278GMAmerican Champion Aircraft Corp · Rochester, WIS/N 1239-2027N278PBP21000318 Inc Trustee · Wilmington, DEBuilt 1979 · S/N P21000318N278SAInternational Air Services Inc Trustee · Carson City, NVBuilt 1974 · S/N 177RG0571N2790WMoondogger LLC · Yakima, WAS/N 1068N2791WToothman John · Fairmont, WVS/N 1069N2793WSchneider Aerial Inc · Rugby, NDBuilt 1966 · S/N 3365N2795JEndeavour Flight Training Inc · Miami, FLBuilt 1979 · S/N 17273650N2796WPennington Jeffrey B · Wrightwood, CABuilt 1966 · S/N 1072N2797EPalm Beach Flyers LLC · Boca Raton, FLS/N 17271324N2797WWebb John H Jr · Paulding, OHBuilt 1966 · S/N 1073N2798CStone Aviation LLC · Sacramento, CABuilt 1978 · S/N R18200228N2798EPumpkin Eater LLC · Tavares, FLBuilt 1978 · S/N 17271325N2798WSb Enterprise LLC · Marshall, TXBuilt 1966 · S/N 3367
Back to AD 80-25-07 R1