OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,471

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

N9174VFrink Jeff · Chandler, AZBuilt 1969 · S/N 690033N91751Aviators Cooperative LLC · Colorado Springs, COBuilt 1973 · S/N 17261509N9175JSommer Eric M · London, OHBuilt 1966 · S/N 28-3241N9176Elias Bernard J · Hampton, GABuilt 1970 · S/N 28PN9176DSmaha Daniel B · Glide, ORBuilt 1958 · S/N 22-6233N9176HSky Walker Flight School LLC · Adrian, MIBuilt 1975 · S/N 17265993N9176JPayson Aero Club LLC · Payson, AZBuilt 1966 · S/N 28-3242N9177DCheyann Jordan · Coupeville, WABuilt 1958 · S/N 22-6234N9177SNabeth Jeremy S · Austin, TXBuilt 1976 · S/N M-1789N9178VWingman Aviation Partners LLC · Wentzville, MOBuilt 1969 · S/N 690017N91793Oexmann James Bennett · Lexington, KYS/N 17261514N9179HMeteiver Lawrence J · Elkhart, INBuilt 1975 · S/N 17265995N9179SCharles Clarens · Brooklyn, NYBuilt 1976 · S/N M-1800N9179VVinter Mooney LLC · Philadelphia, PAS/N 690035N917DKEncore Jet Management LLC · San Antonio, TXBuilt 1998 · S/N 2843186N917FAAlpha Aircraft International LLC · Lake Worth, FLBuilt 1980 · S/N 17274062N917GKAmdel Holding LLC · Houston, TXBuilt 1978 · S/N 17271567N917KDRegistered aircraftBuilt 1976 · S/N AA5A0156N917PFBrown Charles James · Littlefield, TXBuilt 1995 · S/N 21339N917TCDebarros David · Ashland, VABuilt 1998 · S/N 2843167N917VKNorthern Lights Ventures LLC · Moose Pass, AKBuilt 1974 · S/N 18-7409056N917WSRv Time LLC · Cape Coral, FLBuilt 2000 · S/N 21657N917WTStamsta David T · Ennis, MTBuilt 2003 · S/N 00-1170N9180TMcguire Michael D · Lake Stevens, WABuilt 1996 · S/N 3250N91813Fallbrook Fly Girl LLC · Lakeside, ORBuilt 1973 · S/N 17261515N9181SFhs Aero Co Ltd · Olathe, KSBuilt 1976 · S/N M-1798N91823Perra John James Trustee · Gardnerville, NVBuilt 1973 · S/N 17261516N9182HMouton Charles · Gladewater, TXBuilt 1975 · S/N 17265997N9182JTremblay Christopher A · Albion, MEBuilt 1966 · S/N 28-3250N9182KRoth Howard R · Mott, NDBuilt 1976 · S/N 28-7625169N9182SBig Bend Community College · Moses Lake, WABuilt 1975 · S/N MB-786N9182WMoyer Aviation Inc · Tobyhanna, PABuilt 1989 · S/N 2841130N91834Skylink Xpress Inc · San Bernardino, CABuilt 1989 · S/N 2841141N9183KKoinzan Flying Service Inc · Elgin, NEBuilt 1996 · S/N 110N9183SToole William Barry · Goochland, VABuilt 1976 · S/N M-1802N9184LKindred Champ LLC · Hickson, NDBuilt 1971 · S/N 327-72N9184VCloud Distributing LLC · Austin, TXBuilt 1969 · S/N 690036N91854Sjostedt Brad D · Cordova, AKS/N 357-72N9185HFlyit LLC · Washougal, WABuilt 1975 · S/N 17265999N9185JRatcliff Dale A · Granville, OHBuilt 1966 · S/N 28-3253N9185LKnighten Ammon J · Gakona, AKBuilt 1971 · S/N 324-72N9185SGrushkin Jon S · Mazon, ILBuilt 1976 · S/N M-1799N91862Aire Services LLC · Barrigada, GUBuilt 1973 · S/N 17261519N9186DEckels Daniel R · Centerburg, OHBuilt 1958 · S/N 22-6244N9186KMock Joseph R · Huntsville, TXBuilt 1976 · S/N 28-7615181N9186LAshby Darrell T · Elko, MNBuilt 1971 · S/N 231-72N9186MBlazer Aviation LLC · Charlotte, NCBuilt 1992 · S/N 10122N9186SHigh Flyin LLC · Canton, MSBuilt 1976 · S/N M-1805N9187LGardner James Jr · El Campo, TXBuilt 1971 · S/N 328-72N9187MPhillips Tim · Blair, OKBuilt 2001 · S/N 3418
Back to AD 80-04-03 R2