OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,369

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.

N20826Lc Aviation LLC · Mocksville, NCBuilt 2004 · S/N 0182N2082HWalker John R · Spring, TXS/N 20-0045N20834Climb Maintain LLC · Morrisville, MOBuilt 1974 · S/N 17263850N20837Mjm Enterprise Holdings LLC · Drexel, MOBuilt 1974 · S/N 17263851N2083DSale Reported · Crystal, MNSale reportedBuilt 1978 · S/N 44-7995126N2083FDetroit Public Schools Community District · Detroit, MIS/N 17280671N2083QCardinal N2083q LLC · Churchville, PABuilt 1974 · S/N 177RG0483N20843St Louis Flying Club Inc · Ellisville, MOBuilt 1974 · S/N 17263853N2084ASunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 44-7995081N2084DWaves4days LLC · El Segundo, CABuilt 2004 · S/N SRG061N2084EBuchholz Steve DBA · Clarkston, MIBuilt 1978 · S/N 17271148N2084PSchalk Bretta J · Fountain Run, KYBuilt 1956 · S/N 23-672N2084THeiss Bryan G · Shelby, MIBuilt 1970 · S/N 28R-7135028N20858Vintage Flyers Inc · Napa, CABuilt 1974 · S/N 17263857N2085TBlue Skies Aircraft LLC · Kalispell, MTS/N 28R-7135029N2085VForbes Aviation LLC · Boise, IDBuilt 1979 · S/N 28-7990337N20864Dishart Bradley E · Gibsonia, PABuilt 1978 · S/N 28-7990026N20865Agasair LLC · East Hampton, NYBuilt 1974 · S/N 17263859N2086FN3793b Inc · De Smet, SDBuilt 1997 · S/N S1754N2086PSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1956 · S/N 23-674N2086QMillner Paul · Berkeley, CABuilt 1974 · S/N 177RG0486N2086RRobison Robert S · Collinsville, ILBuilt 1969 · S/N 28-5458N2086TEllis Amy E · Santa Rosa, CABuilt 1970 · S/N 28R-7135030N2086WSanders Flight Training Center LLC · Jasper, ALS/N TD-644N20871High Flight Academy LLC · Allison Park, PABuilt 1975 · S/N 17263862N20873Mang Aero Club · Belleville, MIBuilt 1978 · S/N 28-7990027N20876Ogalalla Land & Cattle Ltd · Douglas, WYS/N 17263863N2087EPcs Aviation LLC · La Canada, CABuilt 1978 · S/N 17271150N2087NRls Rental Co DBA · Joplin, MOBuilt 1979 · S/N 28-7916253N2088AGary Jet Center · Gary, INBuilt 1978 · S/N 28-7916092N2088BGeneral Aviation Support Corp · Rosamond, CABuilt 1978 · S/N 28-7916108N2088VMad Scientist Aviation LLC · Wilmington, DEBuilt 2002 · S/N 465-2002N20891Morristown Flying Service Inc · Talbott, TNBuilt 1974 · S/N 17263867N2089ESkyhawk N2089e Ltd · Deerfield, ILBuilt 1978 · S/N 17271151N2089KBrown Frank J · Cold Spring, NYBuilt 1978 · S/N 44-7995176N2089NSchroeder Reinhard · Poulsbo, WABuilt 1979 · S/N 28-7916255N2089QKelly Daniel W · Conway, SCBuilt 1974 · S/N 177RG0489N2089RSchwettmann Dennis E · Nampa, IDBuilt 1993 · S/N 17N2089TBeusekom Jeremy Van · Eden Prairie, MNBuilt 1970 · S/N 28R-7135033N208ATLeciejewski Darrell K · Mc Alpin, FLBuilt 1976 · S/N 17268379N208CAChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 4496161N208CKKarel Craig F · Filer, IDBuilt 1946 · S/N 12-569N208CWWawock Richard L · Murphy, IDBuilt 2014 · S/N 72141N208DCRay David L · Yelm, WABuilt 2001 · S/N 81103N208DWSteins Karl M · La Mesa, CABuilt 2009 · S/N 83-2N208EFAero208 LLC · Boise, IDBuilt 1966 · S/N 28-3632N208ETSaunders Warren C IV · Oklahoma City, OKS/N 82721N208GGPenn Yan Flying Club Inc · Penn Yan, NYBuilt 1975 · S/N 28-7690073N208HBair Sky LLC · Lovell, WYBuilt 1986 · S/N 208N208KKThomas Randall Darren · Exeter, CABuilt 2021 · S/N E571
Back to AD 90-04-06 R1