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.

N767XRegistered aircraftBuilt 2004 · S/N 70882N7680DHart Gary L · Fernwood, IDS/N 18-5902N7680FMag Avionics LLC · Woodlands, TXBuilt 1976 · S/N 28-7790217N7680GGulyash Michael J · Ukiah, CAS/N 17259380N7680RPotter Steven R · Grapevine, TXS/N MB-502N7680SHallsten Stephen B · Fairbanks, AKBuilt 1976 · S/N 221-76N7680WMearbell Kevin J · Niagara Falls, NYBuilt 1964 · S/N 28-1667N7681GCompass Aviation Inc · Shelby, NCBuilt 1970 · S/N 17259381N7681SCawley Jeffrey W · Buckley, WABuilt 1976 · S/N 907-76N7681YTaft Aviation LLC · Brookhaven, NYBuilt 1965 · S/N 30-759N7682DMckay Don · Soldotna, AKS/N 18-5904N7682HHumphrey Ronald D · Pace, FLBuilt 1946 · S/N 12-571N7682JAv Serv LLC · Dover, DEBuilt 1969 · S/N 28R-31083N7682MVan De Hei Mike · Pioneer, CABuilt 1959 · S/N 55982N7682RTrull Stephen G · Golden Valley, MNBuilt 1969 · S/N MB-452N7682WMcintosh Doyle · North Ogden, UTBuilt 1964 · S/N 28-1670N7683DYellow Bird Inc · Doral, FLBuilt 1957 · S/N 18-5905N7683FFisch David S · Leland, NCBuilt 1976 · S/N 28-7725103N7683GBalgoyen James T · Charlotte, MIBuilt 1970 · S/N 17259383N7683HNovember Alpha LLC · Dover, DEBuilt 2005 · S/N 3885N7683KArne Blair · Carpenter, SDBuilt 1950 · S/N 20-505N7683SSzabolscky Stephen L · Remington, VABuilt 1976 · S/N 257-76N7684DRegistration Pending · Destin, FLRegistration pendingBuilt 1957 · S/N 18-5906N7684FLettunich Mitchell C · Newcastle, CAS/N 28-7715238N7684HWellborn Ralph L · Kenai, AKBuilt 1946 · S/N 12-573N7684SStrehle Scott · Lewiston, IDS/N 934-76N7685DMcdonnell Chris M · Naknek, AKS/N 18-5908N7685SHull Kevin G · Sadler, TXBuilt 1976 · S/N 58276N7685YNehrbass Douglas J · Clarksville, TNBuilt 1965 · S/N 30-765N7686FBaremor Terry A · Brooklyn Park, MNBuilt 1976 · S/N 28-7715240N7686JCovic Craig A · Cordova, TNBuilt 1969 · S/N 28R-31087N7686WEcho Aviator LLC · Whitehouse, OHBuilt 1964 · S/N 28-1677N7686YMontana Leasing Group LLC · Park City, UTBuilt 1965 · S/N 30-766N7687MMckown Kevin · Edgewood, NMS/N 55987N7687RTaylor Edward P Jr · Spanishburg, WVBuilt 1970 · S/N M-1308N7687SLynn Robert W · Independence, WVBuilt 1976 · S/N 936-76N7688CCable Bradley D · Indianapolis, INBuilt 1975 · S/N 28-7625080N7688DMiller Gregory B · Wasilla, AKBuilt 1957 · S/N 18-5912N7688HHersrud John D · Wasilla, AKBuilt 1946 · S/N 12-577N7688JClapp Rollyn D · Volga, SDBuilt 1969 · S/N 28R-31266N7688LConsag LLC · Ainsworth, NES/N 187409122N7688RTrudeau Lemaster Productions · Woodland Hills, CABuilt 1969 · S/N MC-2N7688SJohnson Brian G · Goodridge, MNBuilt 1976 · S/N 937-76N7688WBurns Joyce A · Sparta, MOBuilt 1964 · S/N 28-1679N7689GMerrihew Jerry R · Ashby, NEBuilt 1970 · S/N 17259389N7689RDelehant Edward J III · Keller, TXBuilt 1970 · S/N M-1289N7689YGitlow Stuart · Woonsocket, RIBuilt 1965 · S/N 30-769N768AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843793N768ACBowe Joseph E · Ocklawaha, FLBuilt 1999 · S/N 1268-99N768AZStinker Air LLC · Reno, NVBuilt 2002 · S/N 81446
Back to AD 90-04-06 R1