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.

N84036Wings Over Texas Holdings LLC · Denton, TXBuilt 1969 · S/N 17258308N8403EChurchill Scott W · Le Sueur, MNBuilt 1960 · S/N 2257N8403LAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 1983 · S/N 0347N8403RSenmounnarath Sam · Murfreesboro, TNBuilt 1966 · S/N 28-22280N8403YBlair Robert A · Red Bluff, CABuilt 1967 · S/N 301552N84048Kyzer Aviation Holdings LLC · Fort Mill, SCBuilt 1969 · S/N 17258314N8404CLudwick Paul W · Lighthouse Point, FLBuilt 1976 · S/N 28R-7635157N84050Alpenglow Air 2 LLC · Anchorage, AKBuilt 1969 · S/N 17258315N84054Far Horizons LLC · Ravenel, SCBuilt 1981 · S/N 28-8116257N8405BMiloud Chadd K · Fort Worth, TXBuilt 1981 · S/N 28-8116252N8405MWilson Howard C · Georgetown, TXBuilt 1981 · S/N 28-8116254N8405RShields Parker · Port Orange, FLBuilt 1966 · S/N 28-22345N8405SAlston Tony · Midland, TXBuilt 1981 · S/N 28-8116255N8405WTaylor Dale E · Kimball, SDBuilt 1965 · S/N 28-2621N8405YBjorkman Marvin S · Richardson, TXBuilt 1967 · S/N 30-1554N8406244 Flyers · Harlowton, MTBuilt 1969 · S/N 17258319N84063Rothermel Donald M · Mokena, ILBuilt 1969 · S/N 17258320N8406AColorado High Flyers LLC · Colorado Springs, COBuilt 1981 · S/N 28-8290017N8406HP A Flying LLC · Pueblo, COFirst renewal noticeBuilt 1981 · S/N 28-8190269N8406LVee Neal Aviation · Latrobe, PABuilt 1968 · S/N 17256606N8406WWright Jordan M · York, SCBuilt 1965 · S/N 28-2623N8406YPilgrim Robert C · Cape Coral, FLBuilt 1967 · S/N 30-1556N84071Roadrunner Flight School LLC · Farmington, NMBuilt 1969 · S/N 17258322N84072Ferre Taylor · Kirkland, WABuilt 1969 · S/N 17258323N84076Third Step 3 LLC · Gilbert, AZBuilt 1969 · S/N 17258325N8407DRegistration Pending · Manassa, CORegistration pendingBuilt 1957 · S/N 22-5660N8407LPlainwell Aviation And Stem Academy · Kalamazoo, MIBuilt 1968 · S/N 17256607N8407MJohnson Michele J · Buena Vista, COBuilt 1969 · S/N A1500107N8407PMark Gary Flying Service Inc · Inverness, MSBuilt 1965 · S/N 18-8295N8407WIsland Flyers LLC · Apopka, FLBuilt 1983 · S/N 58N8407YAwad Aviation LLC · Pooler, GABuilt 1967 · S/N 30-1557N84082Weinheimer Paul T · Amarillo, TXBuilt 1969 · S/N 17258326N84086Smoky Mountain Flyers · Murphy, NCBuilt 1969 · S/N 17258327N8408BCharlton Gary R II · Loudonville, NYBuilt 1981 · S/N 28-8116258N8408CDallas Secure Storage LLC · Dallas, ORBuilt 1976 · S/N 28-7625113N8408DAeromarine Consulting Inc · Brandon, FLS/N 22-5661N8408ECandace A Larned Enterprises Inc · Long Beach, CABuilt 1981 · S/N 28-8116259N8408LMacair Aviation LLC · Xenia, OHBuilt 1981 · S/N 28-8116261N8408RWilliams Christopher A · Kent, WAS/N 28-22285N84092Brown Stephen J · Chandler, AZBuilt 1969 · S/N 17258328N84093Hruska Coyle J · Lime Springs, IABuilt 1969 · S/N 17258329N84097Argoudelis Michael · Kalamazoo, MIS/N 17258331N8409DWinters David W · Gustine, TXBuilt 1957 · S/N 22-5662N8409LRegistered aircraftBuilt 1968 · S/N 17256609N8409PStevenson Gregory J · Sutter Creek, CABuilt 1964 · S/N 24-3665N8409RRatliff Christopher · Manteno, ILBuilt 1966 · S/N 28-22286N8409WMessam Andre · Snellville, GABuilt 1965 · S/N 28-2626N840ABDiamond Group Holdings LLC · Greenville, NCBuilt 2005 · S/N 40.478N840CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 2844182N840TCNorth Star Aviation Inc · Mankato, MNBuilt 2016 · S/N 2842416
Back to AD 90-04-06 R1