OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,473

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.

N738EWWasowski Walter J · Riverside, CABuilt 1977 · S/N 17269929N738EYPettyjohn Nancy Paulette Sautebien · Dearborn, MIBuilt 1977 · S/N 17269931N738FAFly Maui LLC · Puunene, HIBuilt 1977 · S/N 17269933N738FCMontepiedra John Glenn R · Rch Palos Vrd, CAS/N 17269935N738FDAero Maintenance Inc · Vancouver, WABuilt 1977 · S/N 17269936N738FFTed Kingston Inc · Strathmere, NJBuilt 1977 · S/N 17269938N738FMFinefield James P · Cary, ILBuilt 1977 · S/N 17269943N738FYVero Technical Support Inc · Pensacola, FLBuilt 1977 · S/N 17269954N738FZSun Aviation Inc · Cambridge, MNBuilt 1977 · S/N 17269955N738GTj Air Holdings Inc Trutee · Wilmington, DEBuilt 1979 · S/N GA7-0106N738GACone Ira M · Frazier Park, CABuilt 1977 · S/N 17269956N738GBFlying Grass Hopper LLC · Barrington, ILBuilt 1977 · S/N 17269957N738GEPs Aviation Inc · Granada, MNBuilt 1977 · S/N 17269960N738GJJlinn Aviation Inc · Quinlan, TXBuilt 1977 · S/N 17269964N738GMNesher Aviation II LLC · Jacksonville, FLBuilt 1977 · S/N 17269966N738GSWestern Edge Aviation LLC · Dickinson, NDBuilt 1977 · S/N 17269971N738GVMolnar Raymond Jr · Ashford, CTBuilt 1977 · S/N 17269974N738GWJensen Rodney H · Sandy, UTS/N 17269975N738GZPickard Steve H DBA · Louisville, GABuilt 1977 · S/N 17269978N738HATerrill Mary C · Bloomingdale, ILBuilt 1977 · S/N 17269979N738HDG&M Aircraft Inc · Wheat Ridge, COBuilt 1977 · S/N 17269982N738HHPitre David E · Santa Fe, TXBuilt 1977 · S/N 17269986N738HJMcnamara Patrick J · Marstons Mills, MABuilt 1977 · S/N 17269987N738HKEini Yaakov · Valley Glen, CABuilt 1977 · S/N 17269988N738HPNidiffer Alan W · Brookings, ORBuilt 1977 · S/N 17269992N738HSFlycarolina LLC · Concord, NCBuilt 1977 · S/N 17269995N738HTRucci Daniel C · Saint Cloud, FLBuilt 1977 · S/N 17269996N738HXRick Aviation Inc · Newport News, VABuilt 1977 · S/N 17270000N738JDClover Management Systems Inc · Sanford, FLBuilt 1977 · S/N 17270006N738JFCopperhead Environmental Consulting Inc · Paint Lick, KYBuilt 1977 · S/N 17270008N738JGSullivan James F · Hamilton, ILBuilt 1977 · S/N 17270009N738JJGreat Lakes Aviation Inc · Batavia, NYBuilt 1977 · S/N 17270011N738JPHaskins Robert A · Salinas, CABuilt 1977 · S/N 17270016N738JSWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 17270019N738JTNorthwoods Air LLC · Orono, MEBuilt 1977 · S/N 17270020N738JULlano Masonry LLC · Lubbock, TXBuilt 1977 · S/N 17270021N738JWAllen Stephen R · Ventura, CABuilt 1977 · S/N 17270023N738JXSuperior Flying Services LLC · Superior, WIBuilt 1977 · S/N 17270024N738KAFlying Aces Aero Fleet Inc · Guyton, GABuilt 1977 · S/N 17270027N738KCCarter Flygare Inc · Sacramento, CABuilt 1977 · S/N 17270029N738KFShouling & Philip Enterprise · Lancaster, CABuilt 1977 · S/N 17270032N738KG738 Kilo Golf LLC · Southern Shores, NCBuilt 1977 · S/N 17270033N738KJFly Compton Aeronautical Education Foundation · Compton, CAS/N 17270035N738KKSpradley Amanda · Greenwood, SCFirst renewal noticeBuilt 1977 · S/N 17270036N738KPJupiter Flight Service And Investing LLC · Lithonia, GABuilt 1977 · S/N 17270040N738KQYeomans James S · Harvey Cedars, NJBuilt 1977 · S/N 17270041N738KTGetaway Aviation LLC · Spring Lake, MIS/N 17270044N738KUBoehmlehner Steven A · Rosholt, SDBuilt 1977 · S/N 17270045N738KWAvetrani Jose A · Miami, FLBuilt 1977 · S/N 17270047N738LCCruise Flight Academy Inc · Dalton, GABuilt 1977 · S/N 17270053
Back to AD 80-04-03 R2