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.

N400CBSamper Aviation LLC · Easton, PABuilt 1969 · S/N 28R-31123N400CXCoker Steve L III · Tyler, TXBuilt 1967 · S/N 470N400EDHotovec John W · Las Cruces, NMBuilt 1977 · S/N 570N400FLSouthard Joseph P · Greer, SCBuilt 1971 · S/N 28-7125174N400GBReed Daniel B · Salina, KSBuilt 1996 · S/N 573N400GEFreeway Airport Inc · Mitchellville, MDBuilt 1981 · S/N 17275445N400HA15 Corp · Lansing, MIBuilt 1970 · S/N 17701484N400HVReilly Herbert V · Bloomingburg, NYBuilt 2006 · S/N 400N400JCRegistered aircraftBuilt 1965 · S/N 28-2121N400JGParsons David E · Panama City Beach, FLBuilt 1969 · S/N 17701347N400JRAirspeed Investments LLC · Springfield, TNBuilt 1982 · S/N 28-8316007N400JWAirfleet Holdings LLC · Beverly Hills, CABuilt 1974 · S/N 28-7405276N400KBArrowhead Circle Leasing LLC · Cedar City, UTBuilt 1997 · S/N 1234-97N400LDreher Steve · Bettendorf, IABuilt 1967 · S/N 17700278N400MAPetersen Jacob R · Wasilla, AKBuilt 1978 · S/N 18-7809126N400MJHaney Michael W · Tehachapi, CAS/N 23-1627N400NEKisska Michael K · Long Beach, CABuilt 2003 · S/N 0040N400RNGuirguis Samuel · Fort Myers, FLS/N US001N400SDLeonard Tyler D · Newbury Park, CABuilt 1996 · S/N 3612N400VVCarver Aero LLC · Muscatine, IABuilt 2001 · S/N 4496105N4010BEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1990 · S/N 1418MN4010ZDickey Livestock Inc · Mackay, IDBuilt 1963 · S/N 18-7961N4011EFredericks Harry III Trustee · Woodland, CAS/N 1385N4011PWelke Paul R · Beaver Island, MIBuilt 1958 · S/N 23-1486N4012FNational 967.LLC · Rock Hill, SCBuilt 1976 · S/N 28-7725001N4012TStull Joshua S · Tacoma, WABuilt 1968 · S/N M-1119N4012ZHronkin Jesse G · Palmer, AKBuilt 1963 · S/N 18-7963N4013ERogers Twyla M · Windham, MEBuilt 1977 · S/N 18-7809018N4013REquipment Plus LLC · Culpeper, VABuilt 1990 · S/N 1430N4013XN4013x LLC · Great Falls, MTS/N 5113N4014EMoriarty Gerald Joseph · Anchorage, AKBuilt 1978 · S/N 18-7809019N4014PGriffing Flying Service Inc · Port Clinton, OHBuilt 1958 · S/N 23-1489N4014XFournier Ronald A · San Diego, CAS/N 5114N4015TBauries Brian W · Abilene, TXBuilt 1968 · S/N M-1122N4016ZLong Island Soaring Assoc · Yaphank, NYBuilt 1963 · S/N 18-7966N4017EJelinek Ed · Denton, MTBuilt 1977 · S/N 18-7809021N4017FHansen Drew A · Miami Springs, FLBuilt 1976 · S/N 287715002N4017P17p LLC · Caddo Mills, TXS/N 23-1492N4017ZB4b Co · Ridgeview, SDBuilt 1963 · S/N 18-7968N4018EWilliams Matthew S Trustee · Anchorage, AKBuilt 1977 · S/N 18-7809040N4018TMalfaro William J · Boyertown, PABuilt 1968 · S/N M-1125N4019XBoswell Joey L · Comanche, TXBuilt 1969 · S/N 5119N4019ZPercy Nolan C · Saint Francisville, LAS/N 18-7971N401BJJohnson William L · Union City, INS/N 1N401DKBuford Copter Co LLC · Colorado City, TXBuilt 1988 · S/N 0929N401DTKairos Holdings LLC · Huntsville, ALBuilt 1981 · S/N 17275165N401FLRinaldi Isaac Paul · Richardson, TXBuilt 1971 · S/N 28-7125175N401HXThree Forks Flying Club Inc · Three Forks, MTFirst renewal noticeBuilt 1974 · S/N 17263490N401LALee Hunter · Colorado Springs, COBuilt 1965 · S/N 2949N401LDBrady Kevin J Trustee · Afton, OKBuilt 1977 · S/N AA5B0511
Back to AD 80-04-03 R2