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.

N38748Matthews Franklin L · Mc Alpin, FLBuilt 1941 · S/N 7222N3874MGott Michael · Fairbanks, AKBuilt 1947 · S/N 12-2785N3874PPearson Joshua J · Unionville, MOS/N 22-3567N3874TSmith Albert G Jr · Lake Jackson, TXBuilt 1967 · S/N 28R-30199N3874XTr Flying Service LLC · Milan, MNBuilt 1967 · S/N 173N3874ZSlinkard Justin W · Bakersfield, CABuilt 1961 · S/N 18-7734N3875MSky Ad Inc · Greenwich, CTBuilt 1947 · S/N 12-2786N3875PLonnevik Dennis F · Bigfork, MTBuilt 1955 · S/N 18-4701N3875QAerial Scouting Solutions LLC · Sioux Center, IABuilt 1971 · S/N 17259975N3875TMichael Jin · Renton, WABuilt 1967 · S/N 28R-30200N3875XTate Maurice J · Hope Valley, RIS/N 174N38760Davis Robby E · Plant City, FLBuilt 1969 · S/N 30-1999N3876PBreen George R · East Falmouth, MABuilt 1956 · S/N 18-4702N3876QKracke Spraying Service Inc · Fargo, NDBuilt 1971 · S/N 17259976N3876XFlying Weenie LLC · Henderson, TXBuilt 1967 · S/N 175N38771Bmaf LLC · Lewes, DEBuilt 1977 · S/N 28R-7737116N38773Gustafson David · Watertown, SDBuilt 1977 · S/N 28R-7737117N38777Medsker Doug S · Graham, MOBuilt 1977 · S/N 28-7816181N3877PBranson Derrick · Seward, AKBuilt 1955 · S/N 18-4703N3877ZAlsworth John H · Anchorage, AKBuilt 1961 · S/N 18-7668N38786Johnson David M · South Deerfield, MABuilt 1977 · S/N 28-7790588N3878TRoach Keith E · Chester, SCBuilt 1967 · S/N 28R-30203N3878ZWorrell Trevor S · Anchorage, AKBuilt 1961 · S/N 18-7672N38797Hopkins Elizabeth Reeves · Sunnyvale, TXBuilt 1941 · S/N 7274N38798Seltman Jack · Wichita, KSBuilt 1941 · S/N 7275N3879MMcgowan Patrick Joseph · Troutdale, ORBuilt 2010 · S/N 81094N3879PZimmer Chris P · Upham, NDBuilt 1955 · S/N 18-4705N3879RFox Pond Farm · Indian Trail, NCFirst renewal noticeBuilt 1970 · S/N 28-5851N3879TDupuis Kevin P · Waddell, AZBuilt 1967 · S/N 28R-30204N3879ZNelson Chad A · Buffalo, SDBuilt 1961 · S/N 18-7677N387JAAdams John W · Glennallen, AKBuilt 1987 · S/N 1986-A2N387JVBonura Rocco F Jr · Perkinston, MSS/N 24139N387MAAzul Services LLC · Bozeman, MTBuilt 1998 · S/N 17280387N387RCrossley Eber G · Farmington, NMBuilt 2004 · S/N EGC-01N387SPMsb Aviation LLC · Rockvale, TNBuilt 1999 · S/N 172S8284N38804H And R Aviation LLC · Jonesboro, ARBuilt 1977 · S/N 28-7790589N38809Somerset Air Service Inc · Bedminster, NJBuilt 1977 · S/N 28-7725250N3880QJ&J Hangars LLC · Newnan, GABuilt 1971 · S/N 17259980N3880TThoms Gregory S · Adkins, TXBuilt 1967 · S/N 28R-30206N3881MBaratto John Maynard · Cohasset, MNS/N 12-2779N3881WKincaid Bruce W · Garland, TXBuilt 1967 · S/N 32-827N3881XVincent Ricky M · Clinton, LABuilt 1967 · S/N 184N3882MBrabson Andrew R · Eagle River, AKBuilt 1947 · S/N 12-2778N3882QRiddle Kenneth G · Cherryville, NCBuilt 1971 · S/N 17259982N3882RPeterson Dennis W · Grenora, NDS/N 28-5855N3882ZHarwood Thomas K · Fairbanks, AKBuilt 1961 · S/N 18-7696N38830Jessen Dennis H · Pequot Lakes, MNBuilt 1941 · S/N 7317N38836Angelle Martin · Slidell, LABuilt 1977 · S/N 28-7790592N3883PMontana Air Service Corp · Big Timber, MTS/N 18-4713N3883QAir Williams LLC · Arlington, TXBuilt 1971 · S/N 17259983
Back to AD 90-04-06 R1