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.

N78893King Eugene A · Rch Palos Vrd, CABuilt 1964 · S/N 2908N78894Gonzalez Francisco C · Biloxi, MSBuilt 1965 · S/N 2909N78897Knox Phillip A · Snellville, GABuilt 1964 · S/N 2912N78898Clawson Michael · Allentown, NJS/N 2913N7889GFricker Mark W · Avon, INFirst renewal noticeBuilt 1970 · S/N 17259589N7889PWalker Zachary R · Burlington, NDBuilt 1963 · S/N 2403N7889VPoorman Christopher · Burleson, TXBuilt 1964 · S/N 2851N7889WBetts Paula H · Valparaiso, INBuilt 1964 · S/N 28-1913N788BGSeminole Aircraft LLC · Wilmington, DEBuilt 2002 · S/N 4496143N788BWNelson Thomas H Jr · Chatham, MSBuilt 1997 · S/N 1230-97N788JAHot Wings Aviation LLC · Indianapolis, INBuilt 2022 · S/N 28020088N788MCRoberts James A · Edina, MNBuilt 1978 · S/N 17270430N788RKSalomonsson Mats E · Hayward, CAS/N 28-24831N788RVHigh Flight Aviation Inc · Wilmington, DEBuilt 2008 · S/N 82297N788SHSouthwest Technology Center School Dist No. 27 · Altus, OKBuilt 2004 · S/N 3631N788TDBurdick Kelly E · Wasilla, AKBuilt 1972 · S/N 18-9001N788XDonahue Patrick J · Carriere, MSBuilt 1997 · S/N 793-97N788ZStaton Robbie L · Lonoke, ARS/N 670N78901Emslie Ronald H · Sacramento, CABuilt 1961 · S/N 1915N78903Brar Kulbir Singh · Fresno, CABuilt 1961 · S/N 1917N78907Pritchard John A · Perry, KSS/N 1921N78909Takemura Chris · Mountain View, CABuilt 1961 · S/N 1923N7890GAltus Aircraft LLC · Taylor, TXBuilt 1970 · S/N 17259590N7890HTwo Feathers Industries LLC · Baker City, ORFirst renewal noticeBuilt 1946 · S/N 12-794N7890VDoherty Kevin R · Silver Spring, MDBuilt 1964 · S/N 2852N7890YMhr Leasing LLC · Hickory Corners, MIBuilt 1966 · S/N 30-977N78911Watt Charles D · Marietta, OHBuilt 1961 · S/N 1940N78912Mid America Plumbing LLC · Moscow, TNBuilt 1961 · S/N 1941N78913Ambrose Gary L · Camden, NCBuilt 1961 · S/N 1942N78914Collins Camden B · Millersport, OHS/N 1943N78915Hendryx Alec B · Coffeyville, KSBuilt 1961 · S/N 1944N78918Pearlman Fredric M · Southfield, MIBuilt 1962 · S/N 1952N7891AAce Aeromotive Inc · Miami, FLS/N 11-1466N7891GSam Aviation LLC · Long Beach, CABuilt 1970 · S/N 17259591N7891WN7891w LLC · North Las Vegas, NVBuilt 1964 · S/N 28-1916N78920Duncan Mark T · Orange Grove, TXBuilt 1961 · S/N 1954N78923Rodriguez Julian P · New York, NYBuilt 1961 · S/N 1957N78925Sale Reported · Winthrop, MESale reportedBuilt 1962 · S/N 2037N78927Sly David P · Nevada, IAS/N 1961N78928Lejcar Matthew J · Cumberland Furnace, TNBuilt 1961 · S/N 1962N78929Boccaccio Peter A · Burke, SDS/N 1963N7892VLambert Mathew Chase · Chapel Hill, TNBuilt 1964 · S/N 2854N7892WRegistered aircraftBuilt 1964 · S/N 28-1917N7892YHarrison Richard J · South Hamilton, MABuilt 1966 · S/N 30-979N78930Klingenberg Richard A · Idaho Falls, IDBuilt 1961 · S/N 1964N78934Harville Leonard W · Giddings, TXBuilt 1961 · S/N 1968N78936Napier James C · San Diego, CABuilt 1962 · S/N 1970N78937Reisen LLC · Stevensville, MTBuilt 1961 · S/N 1971N78938Wings Over Texas Holdings LLC · Denton, TXBuilt 1968 · S/N 17257794N7893BDykstra Donald J · Dorr, MIBuilt 1958 · S/N 2029
Back to AD 90-04-06 R1