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.

N6823WThomas Kevin A · Selbyville, DEBuilt 1965 · S/N 28-20961N68242Wilson Timothy J · Arlington, AZBuilt 1978 · S/N 15282205N68246M2g Aviation LLC · China Grove, NCBuilt 1978 · S/N 15282208N6824JMorrison Justin Gregory · Houston, TXBuilt 1976 · S/N 28-7625243N6824ULefevre Duane S · Grover, WYS/N 183N6824WRoberts John R Jr · Homestead, FLBuilt 1965 · S/N 28-20962N68253Conn Kenneth A · Fairfax, VAS/N 75-2416N68257Bates Steven B · Phelan, CAS/N 15282213N6825BAlborn Wyatt A · Homer, AKBuilt 1956 · S/N 22-4121N6825JByrd Mark L · Belpre, OHBuilt 1976 · S/N 28-7615368N6825NWilliams Jerry Riley Sr · Wabbaseka, ARS/N 680118N6825URipley Holdings Ltd · Santa Monica, CABuilt 1963 · S/N 184N6825VRegistered aircraftBuilt 1971 · S/N 21-0008N68260Flycarolina LLC · Rock Hill, SCBuilt 1978 · S/N 15282214N682666s Aviation Corp · Orlando, FLBuilt 1978 · S/N 15282218N6826NInterwest Management · Angwin, CABuilt 1968 · S/N 680109N6826VMcwilliams Michael K · Villa Ridge, MOBuilt 1971 · S/N 22-0008N6826WMartinak Charles J · Rehrersburg, PABuilt 1965 · S/N 28-20966N6827ULeong Thomas M · El Monte, CABuilt 1963 · S/N 186N6827VAerostar Air LLC · Kilgore, TXBuilt 1971 · S/N 20-0005N6827WShort Final Aviation LLC · Branson, MOBuilt 1965 · S/N 28-20967N68280Frint Michael R · Elk Grove, CABuilt 1978 · S/N 15282226N68287Lockwood Albert G · Eden, IDS/N 5-1475N6828BVantreese Jason B · Quanah, TXS/N 22-4125N6828JKdrd Holdings LLC · Texas City, TXBuilt 1976 · S/N 28R-7635337N6828NFisher Scott · Searcy, ARBuilt 1968 · S/N 680120N6828VEvanson Mark A · Wharton, TXBuilt 1971 · S/N 21-0009N6828WOleary David L · Framingham, MABuilt 1965 · S/N 28-20968N6829NWilliams Mark J · Ojai, CAS/N 680110N6829VE N Entertainment Inc · El Dorado Hills, CABuilt 1971 · S/N 22-0012N682ABPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010082N682ATTexas Flight Training Aircraft 8 LLC · Wilmington, DEBuilt 2010 · S/N 4496285N682DCSteele Aviation Inc · Walnut Cove, NCBuilt 1961 · S/N 22-8660N682FGlobal Flight Training Solutions Inc · Immokalee, FLBuilt 1969 · S/N 30-1955N682JAYale Companies LLC DBA · Indianapolis, INBuilt 2022 · S/N 28020082N682LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881245N682MAChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 172S8204N682RByrd Cattle Co Inc · Canyon, TXBuilt 2007 · S/N 71654N682TFAir Fleet Holdings LLC · Addison, TXBuilt 2025 · S/N 2881882N682TXHartman Joshua Albert · Andover, KSBuilt 2019 · S/N 91800N68302Fulltron Aviation LLC · Springfield, MOS/N 15282240N6830EJackson Thomas M · Florissant, MOBuilt 1960 · S/N 56330N6830UJilek Dominic A · River Falls, WIBuilt 1963 · S/N 201N6831HQuarry Jon C · Memphis, TNBuilt 1975 · S/N 17265600N6831KAbbott Cedric M · Buckfield, MEBuilt 1949 · S/N 16-667N6831VMirage Partners LLC · Biddle, MTBuilt 1975 · S/N 20-1161N68323Briggs Jeffery M Trustee · Royal Oak, MIBuilt 1978 · S/N 15282257N68324Registered aircraftS/N 75-7797N68329Ace Aircraft Leasing Inc · Nazareth, PAS/N 15282261N6832FJpf Ventures LLC · Owatonna, MNBuilt 1976 · S/N 28-7790165
Back to AD 90-04-06 R1