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.

N6872WMergen Andrew John · Colorado Springs, COBuilt 1965 · S/N 28-21028N68735Pittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1978 · S/N 15282345N68736Lake Elmo Aero LLC · Lake Elmo, MNS/N 15282346N6873BBent James L Jr DBA · Palatine Bridge, NYS/N 18-5053N6873NWhitfield Jesse Leigh · Anacortes, WABuilt 1968 · S/N 680150N6873WUptegrove James L · Susanville, CABuilt 1965 · S/N 28-21029N68742Byars Cecil E · Tupelo, MSBuilt 1978 · S/N 15282351N6874BSale Reported · Mentor, OHSale reportedS/N 22-4118N6874PZide Joshua M · Newark, DEBuilt 1960 · S/N 24-2009N6874WEra Aviation LLC · Downers Grove, ILBuilt 1965 · S/N 28-21030N68750Poplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1978 · S/N 15282356N68754Ace Aircraft Leasing Inc · Nazareth, PABuilt 1978 · S/N 15282358N6875BCyr Kevin M · Brush, COS/N 22-4119N6875NKatlin Ethan W · Payson, AZBuilt 1968 · S/N 680151N6875TSkala James A · Hartselle, ALBuilt 2009 · S/N 90756N68767Snohomish Flying Service Inc · Snohomish, WABuilt 1978 · S/N 15282367N68768Harris Thomas W · Roseville, MNBuilt 1978 · S/N 15282368N6876HSt Charles County Flying Club LLC · Portage Des Sioux, MOBuilt 1975 · S/N 17265622N6876JN6876j LLC · Provo, UTBuilt 1976 · S/N 28-7690417N6876KAndrews Thomas J · Lakeview, ORS/N 16-717N6876NCunneen Casey Joseph · Studio City, CABuilt 1968 · S/N 680152N6876UVan Der Hart Mark H · Tekamah, NEBuilt 1963 · S/N 2580N68775Gruca Paul G · Riverdale, MIBuilt 1981 · S/N 15285337N6877HKoenig Ned · New Bremen, OHBuilt 1975 · S/N 17265623N6877KLaurienzo Andrew A · Clarence, NYBuilt 1949 · S/N 16-720N6877NElliott John O · Lathrop, MOBuilt 1968 · S/N 680126N6877WFriedrich David Paul · Frankfort, INBuilt 1965 · S/N 28-21033N68789Sinden Donald L · Puyallup, WABuilt 1978 · S/N 15282374N6878BCriner Brad W · Canby, CABuilt 1959 · S/N 18-5061N6878GRundell Lanny · Winnsboro, LABuilt 2015 · S/N 2464N6878JLake Stephen · Geary, OKBuilt 1976 · S/N 28R-7635355N6878KMitchell David R · Conover, NCBuilt 1949 · S/N 16-721N6878PLangley Richard A · Sheyenne, NDBuilt 1960 · S/N 24-2014N68799Smtm Holdings Inc · Wilmington, DEBuilt 1978 · S/N 15282382N6879CParis Air Inc · Vero Beach, FLBuilt 1978 · S/N 28-7816437N687AZZublin John A III · Murrieta, CABuilt 1968 · S/N 17256592N687JAYale Companies LLC DBA Hot Wings Aviation LLC · Indianapolis, INBuilt 2022 · S/N 28020087N687KBBoekelheide Kim · East Greenwich, RIBuilt 2002 · S/N 5687N687LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881266N687LPForgotten Heroes Foundation · Chesapeake, VAS/N 012N687NDAscent Aviation Inc · Duluth, MNBuilt 2014 · S/N 4496373N687SPBmg Aviation Inc · Bloomington, INBuilt 1999 · S/N 172S8098N687SSSciscoe William D · Dish, TXS/N MB-675N687VRGriffin Larry W · Wynne, ARBuilt 2018 · S/N 74363N68806G&M Aircraft Inc · Wheat Ridge, COS/N 15282383N68808Mrb Aviation Inc · Lexington, SCBuilt 1978 · S/N 15282384N6880BAllmaras Donald P · New Rockford, NDBuilt 1956 · S/N 18-5067N6880NLawrence John J · Cypress, TXBuilt 1968 · S/N 680127N6880PBryant Michael E · West Chester, PABuilt 1960 · S/N 24-2016N6880VCraft Steven W · Port Saint Lucie, FLBuilt 1975 · S/N 20-1167
Back to AD 90-04-06 R1