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.

N7451VFox Business Advisors LLC · Mesa, AZS/N 22-1228N7452VBlose Kevin T · New Braunfels, TXS/N 22-1229N7453GNorthwoods Flyer LLC · Jacksonville, FLBuilt 1970 · S/N 17259153N7454GDaniel Dewey R · Okeechobee, FLBuilt 1970 · S/N 17259154N74553Young John H · Sheridan, WYBuilt 1961 · S/N 1945N74555Pieszala John W · Larksville, PABuilt 1961 · S/N 1947N74556Gutierrez Juan · Sarasota, FLBuilt 1961 · S/N 1948N7456GGregory Larry C Trustee · Farmington, MOS/N 129N7456VCollon Joseph · Bonita, CAS/N 22-1233N7457VGietzen Hilary H · Minot, NDBuilt 1975 · S/N 22-1234N7458VMooney Ventures LLC · Canton, GABuilt 1975 · S/N 22-1235N7459VPocket Aces LLC · Baton Rouge, LABuilt 1975 · S/N 22-1236N745FWWalther Frank C · Crawford, COBuilt 1980 · S/N 15283905N745LSWeaver Chris D · Hallam, NEBuilt 1974 · S/N 291-74N745MSSchamel Michael A · Salem, INS/N 126-74N745TWTumbleweed Leasing Co Inc · Salt Lake City, UTS/N 17269624N7461GKniphfer Krenson Hunter · Newington, GABuilt 1970 · S/N 17259161N7461VDrake Robert L · Ruston, LABuilt 1975 · S/N 22-1238N7462VBroken Pole Fishing Hole 4 Wounded Vets · Vancouver, WABuilt 1975 · S/N 22-1239N7463VHarper Abe L Jr · Daphne, ALBuilt 1975 · S/N 20-1157N7464VSpaeth Roger P · Roseville, CABuilt 1975 · S/N 20-1158N7465GLaird Charles A · West Chester, PABuilt 1970 · S/N 17259165N7466VBaker Ronald James · Queenstown, MDBuilt 1975 · S/N 20-1160N746MBTowler Brian A · Chillicothe, OHBuilt 1972 · S/N 332-72N746TWTumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 1977 · S/N 17268710N746ZXSlater R Winston Trustee · St Charles, ILS/N 21064368N7471MN7471m LLC · Sheridan, WYBuilt 1968 · S/N 680104N7474GBarnett Kevin · Simi Valley, CABuilt 1970 · S/N 17259174N7478GMckinney Brian M · Lakeville, MNS/N 17259178N7479GLebanon Flying Club Inc · Lebanon, TNBuilt 1970 · S/N 17259179N747ABFlyco Inc · Colorado Springs, COBuilt 1979 · S/N R18201302N747ARDay Aviation Inc · Wilmington, DEBuilt 1994 · S/N 24-3345N747BFMjm Enterprise Holdings LLC · Drexel, MOBuilt 1980 · S/N R18201581N747CFEast Hill Flying Club Inc · Ithaca, NYBuilt 1977 · S/N 24-0196N747GBBrogan Kenneth A Jr · Montesano, WABuilt 1972 · S/N 17259440N747GSMidwest Thermal Optics LLC · Walnut, ILBuilt 1976 · S/N 258-76N747JHJlm Machine Co Inc · Bradenton, FLBuilt 1978 · S/N 17270642N747KKHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 1976 · S/N 17267651N747LCKerwin Peter M · Naperville, ILBuilt 1992 · S/N 24-3259N747LPSimplifly LLC · Mesa, AZBuilt 1971 · S/N 17260272N747LWOlhughes LLC · Staplehurst, NEBuilt 2022 · S/N 1204-2022N747MLMaxwell Robert C · Fountain Hills, AZBuilt 1975 · S/N 177RG0719N747PCUmo Fight School LLC · Mount Olive, NCBuilt 1977 · S/N 17269156N747PPCp Aviation Inc · Santa Paula, CABuilt 1980 · S/N R18201587N747PTPrince Paul D · Spring Hill, FLBuilt 1974 · S/N 172-63247N747PYPrivitt Bret J · Forest Hill, TXBuilt 1994 · S/N 732-94N747VHAmerican Patrols Inc · Midland, TXBuilt 1976 · S/N 17266914N747WMDonkers David C Trustee · Nerstrand, MNBuilt 2003 · S/N 476-2003N747ZPAuburn Valley LLC · Farmington, MNBuilt 1977 · S/N 15279476N7480GPage Ralph W · Jennings, LABuilt 1970 · S/N 17259180
Back to AD 80-25-07 R1