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.

N8097QHissey Mark E · Fannettsburg, PABuilt 1980 · S/N 28-8090107N8097RPilkington Darrel R · Busby, MTBuilt 1995 · S/N 001N8097SBrookwood Plastering Inc · San Diego, CABuilt 1979 · S/N 28-8090108N80982Reiselt Paul T F · Corinth, MSBuilt 1976 · S/N 17266825N80985Mullins James C · Franklin, TNBuilt 1976 · S/N 17266826N8098BIowa Aircraft Inc · Burlington, IABuilt 1979 · S/N 28-8090110N8098ERegistered aircraftN-number assigned, not yet registeredS/N 17272140N8098MRock Solid Aviation LLC · Lake Charles, LABuilt 1979 · S/N 28-8090111N8098NBlessing Gary · Cape Coral, FLBuilt 1968 · S/N 28-25342N8098YPestair LLC · Wilmington, NCBuilt 1966 · S/N 30-1216N80991Flowers Robert Clyde III · Manchaca, TXBuilt 1976 · S/N 17266830N80996Halley Dan R · Avery, TXBuilt 1976 · S/N 17266832N8099WClarion County Flight Club LLC · Shippenville, PABuilt 1965 · S/N 28-2194N8099YMs Aero Inc · Lakeville, OHBuilt 1966 · S/N 30-1217N809AKeller Gene M · Bethlehem, PABuilt 1951 · S/N 22-114N809APPhillips William Wade · Lake Charles, LAS/N 21823N809BAAustein Amy S · Hernando, MSS/N 001N809BTLouisville Aircraft Leasing LLC · Louisville, KYBuilt 1976 · S/N 17267437N809MBerkshire Aviation Enterprises LLC · Great Barrington, MABuilt 1977 · S/N 28R-7837015N809STDiaz Natanael Luna · Toa Baja, PRS/N 17268873N809TFAir Fleet Holdings LLC · Missoula, MTBuilt 2024 · S/N 2881702N80AMGreat Lakes Aircraft LLC · Palmer Lake, COBuilt 1980 · S/N 0829N80ANStephany Peter T · Umatilla, FLBuilt 1980 · S/N 18-8109003N80BADelcambre Willard J · Grand Coteau, LABuilt 2009 · S/N 7093N80BDJtr Aviation LLC · Canton, TXBuilt 1980 · S/N 613-80N80BJRegistration Pending · Jasper, GARegistration pendingBuilt 1977 · S/N 18-7709191N80BN20right LLC · Chugiak, AKBuilt 1945 · S/N 1414N80BWBuhlig Myles A · Lexington, KYBuilt 1999 · S/N 1999N80CEGarden Kevin · Collierville, TNS/N EAGLE 0001N80CHMoyer Hunter · Rapid City, SDS/N AA5B-0496N80CZCarswell Gene H · Bermuda Dunes, CABuilt 1992 · S/N 008N80DDJvc Aviation LLC · Friendsville, PABuilt 2012 · S/N 3145N80DKAutoair Research Inc · Wilmington, DEBuilt 1994 · S/N 1685N80DLJetstream Aeronautics LLC · San Antonio, TXBuilt 1979 · S/N 15283230N80EEEagle Enterprise LLC · Granbury, TXBuilt 1982 · S/N MAY-0001N80EZHolliday Mathew J · Limerick, PABuilt 1988 · S/N 941N80FGFlightgest Academy LLC · Morrisville, NCBuilt 2022 · S/N 2881562N80FPCarastro Enterprises LLC · Montgomery, ALBuilt 1978 · S/N 17271343N80FTWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 2000 · S/N 2842078N80GGOgg Richard A · San Lorenzo, CABuilt 1996 · S/N 7N80GLNear William J · Weirsdale, FLBuilt 1980 · S/N 0GL-0125N80GSCassell Robert W · Wasilla, AKBuilt 2005 · S/N 5350N80HULast Waterhole LLC · West Richland, WAS/N 1326N80HYBrooks Eugene D IV · Cross Plains, TNBuilt 2005 · S/N 2288N80JVBaker Aviation Consulting LLC · Summerland Key, FLBuilt 2015 · S/N 1207N80KARowe Andrew · Palmdale, CABuilt 1972 · S/N 28R-7235166N80KDKnutson Kevin J · Lakeville, MNBuilt 2013 · S/N 24977N80KJAlbert Lea Airport Inc · Albert Lea, MNBuilt 2010 · S/N 75-7602N80LCHubbert Stephen A · Newcastle, OKBuilt 1993 · S/N 38N80LSClow Streeter M · Mansfield, OHBuilt 1976 · S/N 18-7609096
Back to AD 90-04-06 R1