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.

N8948YKilpatrick Kerry · Somerset, NJBuilt 1971 · S/N 39-109N89492Pilot Farm LLC · Grant, NEBuilt 1946 · S/N 8524N8949CMorgan Aviation LLC · Greensboro, NCBuilt 1976 · S/N 28R-7635186N8949JSchmidt Roger L · Plattsmouth, NEBuilt 1965 · S/N 28-2969N8949RMorten Jesse L · Larimore, NDBuilt 1960 · S/N 7GC-165N8949ZBills Mark W · Willow, AKS/N MB 101N894ACAri Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881413N894ALLancaster Wesley A · Saint Augustine, FLBuilt 2003 · S/N 894N894CDSykes Richard D · Longmont, COBuilt 1995 · S/N 20893N894FSMiller Dietrick J · Monte Vista, COS/N 1507N894MAHot Wings Aviation LLC · Indianapolis, INBuilt 2023 · S/N 28020134N894MJWaite Richard H · Sun Valley, IDBuilt 1989 · S/N 1809035N894RVCox Aaron D · Kalama, WAS/N 1666N894YPodunk Planes LLC · Boulder, COBuilt 2009 · S/N 80151N895Ghosh Abhimanyu · Mojave, CABuilt 1978 · S/N AA5A0564N89503Menne Aviation LLC · Brooklyn Park, MNBuilt 1983 · S/N 17276007N8950FAloft · Haiku, HIS/N 15-0026N8950MPacific Flight Academy LLC · Honolulu, HIBuilt 1963 · S/N TD-558N8950UManley Steven T · Dallas, TXBuilt 1965 · S/N TD-641N8951DChadwick Stewart · Yuba City, CABuilt 1958 · S/N 22-6114N8951JMoehle Colleen M · Lincoln, ILBuilt 1966 · S/N 28-2971N8951LWoolslayer John P · Tulsa, OKBuilt 1974 · S/N AA1B-0401N89531Glynco Manning Aviation Inc · Brunswick, GABuilt 1978 · S/N 15282771N89533Ashby Shawn Alan · San Luis Obispo, CABuilt 1978 · S/N 15282773N89539Jkg LLC · Murfreesboro, TNBuilt 1978 · S/N 15282775N8953DVassal Ministries · North Pole, AKBuilt 1958 · S/N 22-6112N89549Jodkin Jason J · Confluence, PAFirst renewal noticeBuilt 1978 · S/N 15282781N8955YCarter Howard A III · Stafford, VABuilt 1971 · S/N 39-115N8956Martini Philip D · Bethel Park, PABuilt 1973 · S/N 123-74N8956CCosper Rodney S · Killeen, TXS/N 18-2934N8956JBays Bob D · Jasper, MOBuilt 1965 · S/N 28-2977N8956YDark Side Aeronautical Inc · Wilmington, DEBuilt 1971 · S/N 39-116N8957CTracon Aviation LLC · Winter Springs, FLBuilt 1976 · S/N 28-7625137N8957JAirplane LLC · Farmington, UTBuilt 1965 · S/N 28-2978N8957VN8957v LLC · Fort Lauderdale, FLBuilt 1974 · S/N 17264313N8958English John H · Pittsburg, TXBuilt 1973 · S/N 610-74N89585Vinland Flight School LLC · Topeka, KSBuilt 1978 · S/N 15282796N89588Jet & Rotor Aviation LLC · Sacramento, CABuilt 1978 · S/N 15282797N8958CWinter John T · Tucson, AZBuilt 1976 · S/N 28-7625138N8958DPoulton Daniel D · Belton, SCBuilt 1958 · S/N 226121N8958JDavis William M · New Lenox, ILBuilt 1966 · S/N 28-2979N8958LBarron John C · Tulsa, OKBuilt 1974 · S/N AA1B-0408N8958VHyldburg Aviation Inc · Plymouth, MABuilt 1974 · S/N 17264314N89594Executive Aviation LLC · Peoria, AZBuilt 1983 · S/N 17276009N8959CHanson Dan H · Lusk, WYBuilt 1954 · S/N 18-3260N8959JRegistration Pending · Fairmont, WVRegistration pendingS/N 28-2980N895AGProffetty Stephen D · Bridgewater, MABuilt 2010 · S/N 25235N895DSGuida Associates Consulting Inc · Sandpoint, IDS/N 20530N895VSpurlock Ricky DBA · Jensen, UTBuilt 1958 · S/N 18-6736N89600Philbrick Rodney C DBA · Bishop, CABuilt 1978 · S/N 15282801
Back to AD 90-04-06 R1