AD 90-04-06 R1

Registered aircraft · 68,377

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:90-04-06-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
  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.

N8029CFlying Zoo LLC · Collinston, UTBuilt 1954 · S/N 22-2216N8029GIndy Air Sales LLC · Anderson, INBuilt 1970 · S/N 177RG0029N8029MDixon Kenneth P · Arvada, COS/N KD 002N8029NHeydenreich Jacob N · Hartford, ARBuilt 1968 · S/N 28-25274N8029PLong Trevor J · Flower Mound, TXS/N 24-3275N802ATFlight School Of Texas LLC · Wilmington, DEBuilt 2013 · S/N 4496330N802CMN802cm LLC · Lebanon, MOBuilt 2002 · S/N 2843541N802DDN802dd Corp Trustee · Wilmington, DEBuilt 1979 · S/N 17272605N802ERValiair Lc Trustee · Casper, WYBuilt 2003 · S/N 40.306N802FSShelton Shannon · Hampton, GABuilt 1971 · S/N 28-7125398N802PWFlying Mermaid LLC · Aiea, HIBuilt 1981 · S/N 17275194N802RCCollum Aviation LLC · Milton, FLBuilt 1967 · S/N 28R-30299N802RGGandt Robert · Port Orange, FLBuilt 2003 · S/N 70215N802RHKnl Associates LLC · Mansfield, OHBuilt 2017 · S/N 74366N802SPEdb Air Inc · Wilsonville, ORBuilt 1999 · S/N 172S8107N802UMLawrence Dayle A · Scotia, CABuilt 1972 · S/N 28-7225524N802WCHrabe Daren L · Tea, SDBuilt 2018 · S/N 82408N802WHMansfield Heliflight · Milton, VTS/N 0802N80300Ryther Jonathan W · Redlands, CAS/N 17266506N80304Matthews 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-2096N8030YPaden Frank G · Lawrenceburg, KYBuilt 1966 · S/N 30-1139N8031GFletcher Craig B · Willis, TXBuilt 1970 · S/N 177RG0031N8031WGraziano Michael A · Freeport, NYBuilt 1965 · S/N 28-2097N8031XRegistration Pending · Camas, WARegistration pendingBuilt 2003 · S/N 60565N8031YBresin Sharon M · Kamas, UTS/N 30-1140N8031ZCoppen Walter G · Orange Park, FLS/N P-354N8032Kelly Patrick E · Carson City, NVBuilt 1974 · S/N 1-0020N80322Mt 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-7690097N8032HWintringham Henry J Jr · Max Meadows, VABuilt 2003 · S/N 6-4186N8032YCain Jeffrey J · Denver, COBuilt 1981 · S/N 6N8033Stafy Ronald F · Pottstown, PABuilt 1974 · S/N 1-0021N80331Johnson 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-5558N8033GStoltz Curtis · Winter Haven, FLBuilt 1970 · S/N 177RG0033N80340Tangojuliet 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-5559
Back to AD 90-04-06 R1