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.

N898GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881470N898JRKokosa Vernon R · Dennis, MABuilt 1975 · S/N AA5-0706N898JWWeiswasser Jonathan M · Montclair, NJBuilt 2004 · S/N 81639N898PTitus Aviation LLC · Fresno, CAS/N 28-7515403N898SCBmsb Aviation LLC · Bogart, GABuilt 2007 · S/N 80533N898SYGordon Brett · Ewa Beach, HIBuilt 1988 · S/N 2020N898TTMayes Kevin A · Rockwall, TXBuilt 2014 · S/N 83363N898WRegistered aircraftBuilt 2007 · S/N 80792N8990FDeon Esterhuizen Inc · Clearwater, FLBuilt 1974 · S/N 640313N8990JStites Charles Harold · Chapel Hill, NCBuilt 1966 · S/N 28-3014N8991CSpicer Luke J · Seneca, SCS/N 22-1564N8991JCavoto Allyn E III · Adrian, PABuilt 1965 · S/N 28-3015N8991LSky Clock LLC · Mesa, AZBuilt 1974 · S/N AA1B-0441N8991YWaldemar Mojica · Arecibo, PRBuilt 1974 · S/N 18-7409133N8992JMid-Atlantic Air Ventures Inc · Richmond, VABuilt 1965 · S/N 28-3016N8992RBcm Consulting Inc · Wilmington, DEBuilt 1992 · S/N 20605N8992VFreeze Otis C · Frankston, TXBuilt 1974 · S/N 17264347N89933Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15282920N89934Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15282921N8993DKey James M · Hermiston, ORBuilt 1958 · S/N 18-6397N8993JHealy Law Offices Pc · Tyler, TXBuilt 1965 · S/N 28-3017N8993RMiller Scott A · Piney Flats, TNBuilt 1960 · S/N 7GCB-22N8993VBmg Aviation Leasing LLC · Bloomington, INBuilt 1974 · S/N 17264348N8993YAirglas Inc · Anchorage, AKBuilt 1974 · S/N 18-7409135N8994JBatham Carin C · Yuba City, CABuilt 1965 · S/N 28-3018N8994RT & H Aviation LLC · Rector, ARS/N 45N8995DGraham William Franklin III · Port Alsworth, AKBuilt 1958 · S/N 18-6403N8995JBloomquist Eric R · Phoenix, AZBuilt 1965 · S/N 28-3019N89963Wardall Wesley David · Ione, CABuilt 1978 · S/N 15282931N8996EHooligan Air LLC · Ponce Inlet, FLBuilt 1976 · S/N 28-7690217N8996VBaumgartner Scot W · Colby, WIBuilt 1974 · S/N 17264351N8996YJohnk Thomas · LyngbyNon-citizen corporation, flight hours not reportedBuilt 1974 · S/N 18-7409138N8997DFinley Peter T · Bismarck, NDBuilt 1958 · S/N 18-6405N8997JKakuska Michael · Madison, WIBuilt 1965 · S/N 28-3021N8997LBaldwin Rodger D · Decatur, ILBuilt 1974 · S/N AA1B-0447N8997VHusker-Hawkeye Distributing Inc DBA · Omaha, NEBuilt 1974 · S/N 17264352N89980Ace Aircraft Leasing Inc · Nazareth, PABuilt 1978 · S/N 15282937N8998EGeorgetson Michael J · Sayre, PABuilt 1976 · S/N 28-7690219N8998JObrien Robert · Warrens, WIBuilt 1966 · S/N 28-3022N89994Lon Aviation LLC · Aspen, COS/N 18-8510N8999DPadgett Benjamin C · Anchorage, AKBuilt 1958 · S/N 18-6407N8999RDetroit Lakes Aviation Inc · Detroit Lakes, MNBuilt 1960 · S/N 7GCB-35N899AVGilbert Charles L · Belleair, FLBuilt 1980 · S/N ME-353N899CMMoore Andrew · Mills River, NCBuilt 2002 · S/N 2943N899CVJolovich Matthew J · Cheyenne, WYBuilt 2001 · S/N 90040N899DHSchiffer Patrick M · Ovid, MIFirst renewal noticeBuilt 2010 · S/N 4517N899JDMiranda Michael R · Enterprise, ALBuilt 1989 · S/N 856N899JLMeise Wendell G · Port Orange, FLBuilt 2011 · S/N 91858N899NRichards Vallin J · Spearfish, SDS/N 4472N899PGivens Steve · Pendleton, INBuilt 1989 · S/N 313
Back to AD 90-04-06 R1