OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,375

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.

N33931Boehm Darryl K · Mountain Grove, MOFirst renewal noticeBuilt 1941 · S/N 2781N3393RBay Richard G · Sparks, NVBuilt 1969 · S/N 28-5672N3393TWilcox Russell J · Salinas, CABuilt 1967 · S/N 17700693N3393XJohnson Terence A · Caldwell, IDBuilt 1966 · S/N 1102N3393ZWilliams Shane · Union, ORS/N 18-7279N3394MBrown Harold J · Hobbs, NMBuilt 1947 · S/N 12-2059N3394TPekrul Eric C · Frankfort, MIBuilt 1968 · S/N 17700694N3394ZNord Margie N Trustee · Cantwell, AKBuilt 1960 · S/N 18-7281N3395MPapendick Greg J · Hudsonville, MIS/N 12-2237N3396QRomanair Wdr Inc · Winder, GABuilt 1977 · S/N 28-7790455N3396XS R Gilliam Construction Inc · Carthage, NCS/N 3388N3396ZPineland Holdings LLC · Gibsland, LABuilt 1960 · S/N 18-7285N3397MSievert Randall L · Storm Lake, IABuilt 1947 · S/N 12-2248N3397TMckinney Adrian R · Mineral Wells, TXBuilt 1967 · S/N 17700697N3398MMott William R · Beach Lake, PABuilt 1976 · S/N 1037N3398R3y3 Piper Group LLC · Saint Charles, IABuilt 1969 · S/N 28-5671N3398XWinkers John W Jr · Woodstown, NJBuilt 1966 · S/N 1105N33997Mitchell Trans · Timnath, COFirst renewal noticeBuilt 1941 · S/N 2849N33999Athol Orange Aero Club Inc · Athol, MABuilt 1941 · S/N 2851N3399PThornton Curtis J · Ebro, FLBuilt 1954 · S/N 22-2380N3399ZAsquith-Heinz Quinn · Juneau, AKBuilt 1960 · S/N 18-7254N339AMills Scott I · Littleton, COBuilt 2005 · S/N 90493N339AGGirard Albert J · Portsmouth, RIBuilt 2017 · S/N 92001N339ASMarkone Health LLC · Shelby, NCBuilt 2009 · S/N 60554N339BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2022 · S/N 2881525N339CSmith Cole · Parrish, FLBuilt 1999 · S/N 2044N339DLFriedrich Robin K · Houston, TXS/N 90206N339EEvans James W Jr · Wake, VABuilt 1985 · S/N 759N339ECBlackmore Marc A · Hilltop Lakes, TXBuilt 1977 · S/N 20017N339EZPico Andres V · Hollywood, MDS/N 1339N339GOrsolits Robert M · Maitland, FLBuilt 2011 · S/N 361N339JCNorman Robert Alan · Zanesville, OHBuilt 1973 · S/N 17262119N339MKNorth Star Aviation · Mankato, MNBuilt 2019 · S/N 2881097N339NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2006 · S/N 28010012N339PJWallace James R · Aumsville, ORBuilt 2006 · S/N 90589N339RVBillips Robert A · Bluefield, VABuilt 2016 · S/N 92170N339SCSea Seven LLC · Weatherford, TXBuilt 2014 · S/N SC007N339TLeroux Todd C · Palmer, AKBuilt 1953 · S/N 18-2453N339WLawson Richard Brandon · Ararat, NCBuilt 2000 · S/N 5657N33ANBarnes Gary Aaron · Huntsville, ALBuilt 1993 · S/N 625-320-0370FBN33ATKrebs Bernd R · Sandwich, ILBuilt 1969 · S/N 17258784N33AVMaurer Sara Ann · Anchorage, AKBuilt 1996 · S/N 1332N33AWWeigle Alan B · Seward, NEBuilt 2001 · S/N 489N33BGifford Steven K · Buskirk, NYBuilt 1946 · S/N 12-784N33BP33bp LLC · Sand Springs, OKBuilt 1992 · S/N 691-92N33BRMarchant William · Cleveland, GAS/N 166N33BYSellmeyer Flying Service · Knobel, ARBuilt 2005 · S/N 990-2005N33CBShepperson Frank Lester · Midwest, WYBuilt 1958 · S/N 18-6682N33CDElliott Kathy · South Thomaston, MEBuilt 1973 · S/N 17260989N33CLBills Jacqueline Trustee · Willard, MOBuilt 1979 · S/N 28R-7918067
Back to AD 90-04-06 R1