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.

N8026QInternational Fun Place Hangar 32 LLC · Laughlin, NVBuilt 1996 · S/N 20082N80270Fisher Robert · Shoreacres, TXS/N 17266488N80277Usaeroflight LLC · Greenville, SCBuilt 1975 · S/N 17266490N80278Baur Ronald N · Gig Harbor, WABuilt 1975 · S/N 17266491N80279Tueller John D · Spring Creek, NVBuilt 1975 · S/N 17266492N8027FCyganski David · Palm Beach Gardens, FLBuilt 1976 · S/N 28-7715255N80282Nguyen Nhu-An T · Bethesda, MDBuilt 1975 · S/N 17266493N80283Barxbar Aviation LLC · Mesa, AZBuilt 1975 · S/N 17266494N80287Campbell Frederick G · Rigby, IDS/N 22902N80291Davidson Doug W · Newcastle, WABuilt 1975 · S/N 17266500N80295Legacy Skies Aviation LLC · Rogers, ARBuilt 1975 · S/N 17266502N80298N80298 LLC · Miami, FLBuilt 1975 · S/N 17266504N80299Mountain Air Aviation Inc · Bethesda, MDBuilt 1975 · S/N 17266505N8029NHeydenreich Jacob N · Hartford, ARBuilt 1968 · S/N 28-25274N8029PLong Trevor J · Flower Mound, TXS/N 24-3275N802CMN802cm LLC · Lebanon, MOBuilt 2002 · S/N 2843541N802FSShelton Shannon · Hampton, GABuilt 1971 · S/N 28-7125398N802PWFlying Mermaid LLC · Aiea, HIBuilt 1981 · S/N 17275194N802RGGandt Robert · Port Orange, FLBuilt 2003 · S/N 70215N802RHKnl Associates LLC · Mansfield, OHBuilt 2017 · S/N 74366N802UMLawrence Dayle A · Scotia, CABuilt 1972 · S/N 28-7225524N802WHMansfield Heliflight · Milton, VTS/N 0802N80304Matthews David A · Anchor Point, AKBuilt 1975 · S/N 17266510N80307Hughes Fredrick A · Oklahoma City, OKBuilt 1975 · S/N 17266511N8030DSunrise 6500 Inc · Wilmington, DEBuilt 2004 · S/N 22660N8030NWilson Mark A · Havana, FLBuilt 1968 · S/N 28-25275N8030WGosse Luke J · Waterloo, IABuilt 1964 · S/N 28-2096N8031WGraziano Michael A · Freeport, NYBuilt 1965 · S/N 28-2097N80322Mt Aviation LLC · Fairbanks, AKS/N 17266518N80326Fly Lugu LLC · Southwick, MABuilt 1975 · S/N 17266520N80327Highland Rim Aviation LLC · Springfield, TNBuilt 1975 · S/N 17266521N8032CAirwego LLC · Wilmington, DEBuilt 1975 · S/N 28-7690097N80331Johnson Shem E · Bonners Ferry, IDS/N 17266525N80332Lamb Joseph M · Conway, ARBuilt 1975 · S/N 17266526N80333Coeytaux Britton Marielle G · St Helena, CABuilt 1975 · S/N 17266527N80335Rawareo LLC · Warsaw, MOBuilt 1975 · S/N 17266529N80336Joyal Alfred N III · Marquette, MIBuilt 1975 · S/N 17266530N80338Maldonado Monell Julio · Carolina, PRBuilt 1976 · S/N 17266532N8033DLevinson Alan J · Delta Junction, AKBuilt 1957 · S/N 22-5558N80340Tangojuliet Aviation LLC · La Porte, INBuilt 1976 · S/N 17266534N80342Spanaflight LLC · Puyallup, WABuilt 1976 · S/N 17266535N80347Aero Maintenance Inc · Vancouver, WABuilt 1976 · S/N 17266538N8034DMyers Mark · Clovis, NMBuilt 1957 · S/N 22-5559N8034EHill Matthew E · Abingdon, VABuilt 1975 · S/N AA5B0191N8034WFieldgrove Kevin · Monroe, GABuilt 1965 · S/N 28-2101N80350Lobstein Michael R · Belleville, ILBuilt 1976 · S/N 17266541N80358Holmes Howard W · Lebanon, TNBuilt 1976 · S/N 17266547N8035DSchulz Garth · Anchorage, AKBuilt 1957 · S/N 22-5560N80363Corey Cathy Pike · Shelbyville, KYBuilt 1976 · S/N 17266551N80366Steranka Paul O Jr · Charleston, WVBuilt 1976 · S/N 17266553
Back to AD 80-04-03 R2