OpenAirDocs.org
AD 80-25-07 R1

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

N79ACTen G LLC · Waddell, AZS/N 708-93N79DVDiscovery Associates Inc · Midland, TXBuilt 1979 · S/N P21000233N79GLJones Robert B · Fresno, CABuilt 1977 · S/N 0754N79MJ79mj LLC · Mercer Island, WABuilt 1979 · S/N R18201109N79MRMarbes Daniel · De Pere, WIBuilt 1979 · S/N R18201271N79QBBaer Marcus R · Aubrey, TXBuilt 1965 · S/N 48N79RARegistered aircraftBuilt 2001 · S/N 1312-2001N79RCBach II LLC · Lafayette, LABuilt 1982 · S/N 21064697N79STAllevato Eugenio · Northridge, CABuilt 1978 · S/N R18200222N79VK3g'S Aviation LLC · St Simons Island, GABuilt 1979 · S/N 21063322N7AFN7af LLC · Ronkonkoma, NYBuilt 1975 · S/N 17264850N7ALFlying Fortress Of Swfl LLC · Fort Myers, FLS/N 21063261N7BVHartman Gregory S · San Mateo, CAS/N R18200432N7DFSkyshoe III LLC · Beverly, MABuilt 2007 · S/N 1055-2007N7DGElizabeth City State University · Elizabeth City, NCBuilt 1977 · S/N 17268586N7DTPeet Edward V · Lady Lake, FLS/N 577-76N7JBB F Service Inc · Bloomington, INBuilt 1994 · S/N 727-94N7KSilverman Kenneth Lack · Jefferson, NCBuilt 1980 · S/N R18201465N7LPFirth Leonard F · Navasota, TXBuilt 1975 · S/N 17265467N7LUNorber Howard S · Chicago, ILBuilt 1991 · S/N 24-3214N7LVBas Part Sales LLC · Greeley, COBuilt 1980 · S/N P21000506N7MFBarger Christopher H Trustee · Mesa, AZBuilt 1980 · S/N P21000583N7QJDeremer Eric B · Kissimmee, FLBuilt 1978 · S/N 38-79A0308N7RRTavan Richard M · Saratoga, CAS/N 21063468N7VJM E L LLC · Wilmington, DEBuilt 1978 · S/N 177RG1361N7XPInternational Air Services Inc Trustee · Carson City, NVBuilt 2001 · S/N 1309-2001N7XVPagenkopf Joseph C · Juneau, AKBuilt 1974 · S/N 132-75N7XYHewett Nancy A · Tacoma, WAS/N 17261254N7YZAeronautical Enterprises LLC · Woodinville, WABuilt 1970 · S/N 17258814N7ZXRobinson Leslie C · Colorado Springs, COS/N 177RG1119N8001GWilliams Matthew L · Longview, TXS/N 177RG0001N8005GBertolino Vincent · Canton, CTBuilt 1970 · S/N 177RG0005N8006GGecin Taner · Wallingford, CTBuilt 1970 · S/N 177RG0006N80079Ramos Anthony K · Fresno, CABuilt 1975 · S/N 17266356N8007GBradford Steven M · Muscatine, IABuilt 1970 · S/N 177RG0007N80087Kazmer Gary W · North Windham, CTBuilt 1975 · S/N 17266360N80088Wolgat Alexander · White Lake, MIS/N 17266361N8008GMentgen William P · Greencastle, INBuilt 1970 · S/N 177RG0008N80090Cloud Hoppers II LLC · Chicago, ILBuilt 1975 · S/N 17266363N80092Bronco Flying Service · Coldwater, MIBuilt 1975 · S/N 17266364N80094Hartshorn Michael P · Danville, ILBuilt 1976 · S/N 17266366N80095Ivy James E · Alba, TXBuilt 1975 · S/N 17266367N80097Yates Gregory A · Murrayville, ILBuilt 1975 · S/N 17266368N800DPAbbey Nelson D III Trustee · Canton, OHBuilt 1966 · S/N 992N800FCFargo Curt J · Vacaville, CAS/N 17256726N800LGPlane Fun Inc Tr Trustee · Snellville, GABuilt 1981 · S/N P21000669N800MDPark Whitney Foutz · Boulder, COBuilt 1977 · S/N 17269123N800TBHamaoui Ness · Santa Ynez, CABuilt 1984 · S/N 24-1514N800TGAftg Aviation LLC · Hopkins, MIBuilt 1978 · S/N R18200683N800TYAvcorp Holdings Inc · Jackson, MIBuilt 1978 · S/N 15282202
Back to AD 80-25-07 R1