OpenAirDocs.org
AD 80-25-02 R2

Registered aircraft · 6,349

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.

N5895ZMerrick Richard W · Bernville, PABuilt 1963 · S/N 22-9761N58ATTurner Michael A · Cartersville, GABuilt 1994 · S/N 1266N58JBThayer Alan R · San Leandro, CABuilt 2007 · S/N 310N58LJL&J Aviation Inc · Atwater, CABuilt 1985 · S/N 15285959N58MTMchenry Mark · Mc Lean, VABuilt 1985 · S/N 1442N58WLLitherland Wayne A · Agency, MOBuilt 1985 · S/N 1581N58YTatko Philip J · Middle Granville, NYBuilt 1963 · S/N 22-9652N5900ZLindsay Clyde M Jr · Rowland, NCBuilt 1963 · S/N 22-9765N5901HBerreman Jeffrey · Yakima, WAS/N 16-523N5901LDuff John R · Farmers Branch, TXBuilt 1969 · S/N AA1-0201N5901ZGroom Ronald Ollie · Brownwood, TXBuilt 1963 · S/N 22-9766N5902HGage Ricky D · Lewiston, IDS/N 16-526N5902LWaffle Matthew · Bainbridge Island, WABuilt 1969 · S/N AA1-0202N5902ZRegistration Pending · Kenai, AKRegistration pendingBuilt 1963 · S/N 22-9767N5904HN5904h LLC · Winter Haven, FLS/N 16-524N5904LRegistration Pending · Orem, UTRegistration pending, pending cancellationBuilt 1969 · S/N AA1-0204N5906LSonshine Unlimited LLC · Canfield, OHBuilt 1969 · S/N AA1-0206N5909HDelaney John D · Mineral Point, WIBuilt 1949 · S/N 16-533N5910HKlann Jason · Yorkville, ILS/N 16-534N5910ZBishop David E · Butlerville, INBuilt 1963 · S/N 22-9777N5911ZDavis Jim F · Poteau, OKBuilt 1963 · S/N 22-9778N5913HMesserla David M · Manhattan, KSBuilt 1949 · S/N 16-527N5914HFambrough Todd W · Ocala, FLBuilt 1949 · S/N 16-538N5916HHainline James L · Klamath Falls, ORBuilt 1949 · S/N 16-537N5917LHill Jeffrey A · Boise, IDBuilt 1969 · S/N AA1-0217N5917ZKoch Christopher P · Batavia, NYBuilt 1963 · S/N 22-9785N5918HHarvey Michael V · Port Leyden, NYBuilt 1949 · S/N 16-541N5918LRobello Mel K · San Jose, CAFirst renewal noticeBuilt 1969 · S/N AA1-0218N5919HKidder Robin G · Burlington, KYS/N 16-543N5919LMckee Marty R · Lenoir City, TNBuilt 1969 · S/N AA1-0219N5920HZakrzewski Patrick J · Waterford, WIBuilt 1949 · S/N 16-532N5920LSharratt Mark M · Ogilvie, MNBuilt 1969 · S/N AA1-0220N5922HGifford Gary W · Lighthouse Point, FLS/N 16-544N5922LJokerst Kenneth · Saint Louis, MOBuilt 1969 · S/N AA1-0222N5922ZBellamy John Mark · Freeville, NYBuilt 1964 · S/N 22-9791N5927HParley Michael D · Carmel, CABuilt 1949 · S/N 16-549N5927LTri State Airmotive LLC · Berryville, ARBuilt 1969 · S/N AA1-0227N592RJWood Roger E · Waxhaw, NCBuilt 1969 · S/N 702N5930ZBrue Peter Gary · Cedar Rapids, IABuilt 1964 · S/N 22-9800N5931LLuft Aviation Inc · Wilmington, DES/N AA1-0231N5934HAlden Aviation Management LLC · New Smyrna Beach, FLBuilt 1949 · S/N 16-557N5934ZNew Daniel A · Deming, WAS/N 22-9804N5936ZMeulenberg Jacobus M J · Schenevus, NYS/N 22-9806N5937HFrasier Samuel R · Archer, FLBuilt 1949 · S/N 16-560N5938LMidland Avionics LLC · Louisville, KYBuilt 1969 · S/N AA1-0238N5940ZMoore Roger W · Poinciana, FLS/N 22-9811N5941ZByler Jonathan P · Inman, SCBuilt 1964 · S/N 22-9812N5942HHendrickson Jacob N · Central, AKBuilt 1949 · S/N 16-564N5942LSimulation International Management Inc · Tulsa, OKBuilt 1969 · S/N AA1-0242N5943HPleiman Jeffrey S · Minster, OHBuilt 1949 · S/N 16-566
Back to AD 80-25-02 R2