OpenAirDocs.org
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.

N3785XWalker Dennis H · Tyler, TXBuilt 1968 · S/N 280N37869Hayden Jr Robert E · Anaheim, CABuilt 1941 · S/N 1016N3786BWright B Flyer Inc · Miamisburg, OHBuilt 1981 · S/N 001N3786MHuismann John C · Seaside, ORBuilt 1947 · S/N 12-2715N3786TSunrise Aviation Inc · Ormond Beach, FLBuilt 1967 · S/N 28R-30099N3786XTinaglia J Dean · Hot Springs, SDBuilt 1968 · S/N 281N3787CArmstrong Michael K · Spokane, WAS/N 04002N3787MWilliams Jamey P · Thompson Falls, MTBuilt 1947 · S/N 12-2553N3787POdonnell Daniel V · Dover, DES/N 510N3787ZEasterday Jay A · Wilder, IDS/N 18-7473N37887Metzler Kevin W · Rosamond, CABuilt 1982 · S/N 112N3788APassmore Sandra A · Lacrosse, WABuilt 1953 · S/N 18-3055N3788MHendrickson Eric J · Brunswick, MEBuilt 1947 · S/N 12-2716N3788TMason Kenneth Lee · Siloam Springs, ARBuilt 1967 · S/N 28R-30101N3789ABilton Nicholas J · Bozeman, MTBuilt 1953 · S/N 18-3056N3789TGullett John H II · Jacksonville, FLBuilt 1967 · S/N 28R-30102N378ASpicer Michael W · Phillipsburg, KSS/N 39N378ACRagwing Aviation LLC · Palo Alto, CABuilt 1999 · S/N 1378-99N378AKRegistration Pending · Anchorage, AKRegistration pendingBuilt 2025 · S/N 01N378BLBlue Line Aviation LLC · Smithfield, NCBuilt 2024 · S/N 2881778N378BPBlue Sky Education Inc · Louisville, KYBuilt 1964 · S/N 28-1547N378DSMaya Air Services LLC · Lee, NHBuilt 2004 · S/N 40.442N378JAYale Companies LLC DBA · Indianapolis, INBuilt 2022 · S/N 28020078N378JGByrkit Dale D · Clay Center, NEBuilt 1992 · S/N 680-92N378JPN8zw LLC · East Hampton, NYBuilt 2005 · S/N 980-2005N378MARussell Robert Q · Genoa City, WIBuilt 1999 · S/N 172S8078N378RSKempton Larry J III · Grand Junction, COBuilt 1978 · S/N 28R-7837239N378VSSuciv Andronic · Orangevale, CAS/N 886N3791TMakowski Edward J · Barberton, OHBuilt 1967 · S/N 28R-30104N3792TBrowning Marvin Robert · Berthoud, COBuilt 1967 · S/N 28R-30105N3793DElliott Randy K · Wasilla, AKS/N 105N3793MVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1947 · S/N 12-2718N3793ZHentges Jerry J · Morris, MNS/N 18-7479N3794K10 Skies LLC · Rockport, TXBuilt 1967 · S/N 28-23731N3794NLc Aviation LLC · Hartland, WIS/N 680120N3794PBellamy Flying LLC · Elwood, NEBuilt 1955 · S/N 18-4694N3795BCanyon Aero LLC · Fresno, CABuilt 1955 · S/N CH-302N3795HMartin Timothy · Queen Creek, AZBuilt 1980 · S/N 24-0943N3795MFoothills Aviation LLC · Buhl, IDBuilt 1947 · S/N 12-2722N3795TCrossen Executive LLC · Missouri City, TXBuilt 1967 · S/N 28R-30108N3795ZDieffenderfer John C · Palmer, AKBuilt 1960 · S/N 18-7486N37960Buth Eugene · Wellborn, TXBuilt 1979 · S/N 1306N37961Gerwig Joseph L · Sutton, AKBuilt 1941 · S/N 5-832N3796ASpinner Family Limited Partnership · White City, ORBuilt 1953 · S/N 18-3063N3796TWhitmore Allen R · Crestview, FLBuilt 1967 · S/N 28R-30109N3796VMace Wade L · Ottawa, KSBuilt 1949 · S/N 15217N3797MNorlin William E · Greencastle, INBuilt 1947 · S/N 12-2721N3797TMarshall Patrick R · Trail, ORBuilt 1967 · S/N 28R-30110N3797ZMerriner Scott L · Anchorage, AKS/N 18-7492N37983Spani Wayne W · Corona, CAS/N 809
Back to AD 90-04-06 R1