OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,472

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.

N2572PRegistration Pending · Roanoke, TXRegistration pendingS/N 18-4312N2572UVan Scoy Bridget Anne · Shavertown, PAS/N 28-8016038N2572WFlournoy Thomas H · Port Republic, NJBuilt 1965 · S/N 3273N2572ZRunia Jerry L · Estelline, SDBuilt 1977 · S/N 1000-77N2573JBusch Bruce K Trustee · Cerritos, CABuilt 1979 · S/N 18-7909132N2573WTrail Air LLC · Springdale, ARBuilt 1965 · S/N 3274N2574XBuckman Warren E III · Pennsburg, PABuilt 1985 · S/N 28-8516047N2575UCavu Aircraft LLC · Salisbury, NCBuilt 1979 · S/N 28-8016042N2576PWiltz Brothers Inc · Krotz Springs, LAFirst renewal noticeBuilt 1955 · S/N 18-4316N2577MBales Colton E · Wasilla, AKBuilt 1946 · S/N 12-1051N2577WSiegel Theodore Matthew · Merritt Island, FLBuilt 1965 · S/N 3275N2578WCain Mitchell J · Ellisville, MOBuilt 1965 · S/N 3276N2578ZMcclaskey Leslie Paul · New Albany, OHBuilt 1977 · S/N 348-77N257ACClassic Aviation Inc · Pella, IABuilt 1999 · S/N 1257-99N257ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496071N257CTLane Community College · Eugene, ORBuilt 1978 · S/N 287816053N257DCWeaver Lloyd J Jr · Spearfish, SDBuilt 2001 · S/N 2N257DFHawkins Ian N · Kingwood, TXS/N 117N257FK257fk LLC · Marathon, FLBuilt 1977 · S/N 17269126N257RAReynolds Darryl G · Wills Point, TXFirst renewal noticeBuilt 1975 · S/N 17266240N257RD4 Flying Z'S LLC · Murfreesboro, TNS/N M-2137N257SDDanmeier Stephen R · Irving, TXS/N 319RN257WDWatts James F · Lone Tree, COBuilt 2022 · S/N 70654N2580RFlight Club Academy LLC · Palmetto Bay, FLBuilt 1969 · S/N 28-5650N2581Humphreys Kenneth G · Moriarty, NMBuilt 1969 · S/N 1N2581FShields Mitchell · Millville, NJBuilt 1965 · S/N 27N2581MSpencer David W · Anchorage, AKBuilt 1947 · S/N 12-1049N2581PWick Melvin D · Palmer, AKBuilt 1955 · S/N 18-4323N2582SHigh Exposure Inc · Wilmington, DEBuilt 1979 · S/N 18-7909161N2582WPetersen Bennett David · Ashland, OHBuilt 1965 · S/N 3277N2583PHudzinski Thomas E · Wasilla, AKBuilt 1955 · S/N 18-4325N2583WRuckel Daniel A · Floyds Knobs, INBuilt 1965 · S/N 3278N2584SStrouckel Jesse · Roscoe, SDS/N 18-7909162N2585SWright George E · Homestead, FLS/N 18-7909164N2586GJeppesen Thomas L · Stanton, MIS/N 7N2586XPiper Kffc LLC · Peachtree City, GABuilt 1985 · S/N 28-8690003N2587JCastle Chad · Sunnyside, WABuilt 1979 · S/N 18-7909133N2587WOrourke Timothy L · Laguna Niguel, CABuilt 1965 · S/N 3279N2588POkonek Kellie L · Girdwood, AKBuilt 1955 · S/N 18-4332N2588WJohnson Mitchell R · Bismarck, NDBuilt 1965 · S/N 3280N258ACMcquack Aviation LLC · Belding, MIS/N 001N258AKThompson Nick · Eagle, AKBuilt 1994 · S/N 1258N258ALLong Jeffrey · Dothan, ALBuilt 1976 · S/N 28-7615365N258BWEastern Kentucky University · Richmond, KYBuilt 1981 · S/N 17274811N258CVandelay Industries I Inc · Wilmington, DEBuilt 1999 · S/N 2014N258ERLewis Carlos Brandon · Indian Mound, TNBuilt 1978 · S/N 17270891N258RAReynolds Darryl G · Wills Point, TXBuilt 1978 · S/N 17270533N2590XC B W Landscaping Construction Co Inc · Framingham, MAS/N 679MN2590ZWollaston Dean E · Hazel Green, WIBuilt 1977 · S/N 260-77N2592PRogers Lee B · Anchorage, AKBuilt 1955 · S/N 18-4336
Back to AD 80-04-03 R2