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.

N1552HLewis Daniel Bryce · Waller, TXBuilt 1975 · S/N 177RG0726N1553HBuckner Robert M · Eufaula, OKBuilt 1975 · S/N 177RG0727N1555VGinther Michael P · Lemmon, SDBuilt 1974 · S/N 17263658N1557HOpequon LLC · Vanderbilt, PABuilt 1975 · S/N 177RG0731N1558EFlores Frank J · Ozark, MOBuilt 1978 · S/N 17271046N1559HCardair Inc · Allentown, PABuilt 1975 · S/N 177RG0733N155BCCallander John K · Oakland, CABuilt 2019 · S/N 599-2019N155CTOutsideloop LLC · Denver, COBuilt 1979 · S/N R18201277N155CWPotcake Aviation LLC · Mcminnville, ORBuilt 1975 · S/N 17265697N155DGJuliet Tango Flying Services LLC · Walnut Creek, CABuilt 1983 · S/N 21064815N155JHCrew Support LLC · Draper, UTBuilt 2014 · S/N 562-2014N155RCClark 155 LLC · Missoula, MTS/N 21064312N155SKPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1978 · S/N 15282657N1560EAmerican Airman Inc · Stony Brook, NYBuilt 1978 · S/N 17271047N1560HFly North Of Known LLC · Aurora, ORBuilt 1975 · S/N 177RG0734N1560VAvp Aviation LLC · La Jolla, CABuilt 1974 · S/N 17263663N1561HTorpey Richard T · Bay Shore, NYBuilt 1975 · S/N 177RG0735N1561VHenkel Douglas K · Olathe, KSBuilt 1974 · S/N 17263664N1563HSpokane Cardinal · Spokane Valley, WABuilt 1975 · S/N 177RG0737N1564EElizabethtown Flying Service Inc · Elizabethtown, KYBuilt 1978 · S/N 17271048N1565HSchornick Brad W · Oklahoma City, OKBuilt 1975 · S/N 177RG0739N1566HRohlfing Gregory C · Elmwood Park, ILBuilt 1975 · S/N 177RG0740N1567HKrimminger Michiel · Lancaster, SCBuilt 1975 · S/N 177RG0741N1567VRasmussen Bryan K · Wilsonville, ORS/N 17263668N1568HCorner Jeremy M · Peachtree City, GABuilt 1975 · S/N 177RG0742N1569HDekalb Cardinal LLC · Evanston, ILBuilt 1975 · S/N 177RG0743N156RACase Bruce · Verona, WIBuilt 2007 · S/N 1429-2007N156SKBrenny Christopher D · Burlington, WIBuilt 1981 · S/N 15285035N156SPOzium LLC · Henderson, NVS/N 24-3263N156XDBurgess Mark W · Greene, MES/N 17268718N1570VMcdermott John P Trustee · Redding, CABuilt 1974 · S/N 17263671N1571EMorgan Steven P · Roswell, GABuilt 1978 · S/N 17271049N1571HYork Ronald A · West Lafayette, INBuilt 1975 · S/N 177RG0745N1571VPeabody Jeffery L · Vinemont, ALBuilt 1974 · S/N 17263672N1572VWaldroup Anthony Wayne · Konawa, OKBuilt 1974 · S/N 17263673N1575HCardinal Shares Inc · Rochester, MNS/N 177RG0749N1575VMissouri Reliability Services LLC · Maryville, MOBuilt 1974 · S/N 17263675N1578HKramer Jason K · Longview, TXBuilt 1975 · S/N 177RG0752N157ACLandsburg Custom Services LLC · Sandusky, MIS/N 1379-2000N157DF157df LLC · Madison, WIS/N 17260646N157NHRegistered aircraftBuilt 1981 · S/N 15285106N157PSSchmidt Jay E · New Prague, MNBuilt 1980 · S/N 24-1059N157RFAir Direct Holdings LLC · Stow, MABuilt 1967 · S/N 108N157SKGriffith Aviation Inc · Griffith, INBuilt 1980 · S/N 15284820N157WBBhh Leasing #4 LLC · Pensacola, FLBuilt 2014 · S/N 1139-2014N1580EBermudez John M · Pembroke Pines, FLBuilt 1978 · S/N 17271051N1580HBrock Bobby Charles · New Braunfels, TXBuilt 1975 · S/N 177RG0754N1580VPrecision Curbs And Concrete LLC · Shady Cove, ORS/N 17263696N1581HNevarrow Leon · Spring Valley, CAS/N 177RG0755N1582HT G & P Enterprises LLC · Glendale, AZBuilt 1978 · S/N 177RG1364
Back to AD 80-25-07 R1