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.

N404CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881109N404DSDelaware State Universtiy · Dover, DEBuilt 1976 · S/N 28-7615141N404JEMedia Stew LLC · Carson City, NVBuilt 1993 · S/N 724-93N404MHCall One Inc · Clarinda, IABuilt 2018 · S/N 75-10615N404NDUniversity Of North Dakota · Grand Forks, NDBuilt 2026 · S/N 28010004N404QMezrah Realty Corp Inc · Tampa, FLS/N 1388N404RBMyrehn Bruce D · Carmel, INBuilt 1972 · S/N AA5-0101N404SEBaird Jonathan D · Saint Joseph, MIBuilt 1974 · S/N 28R-7435223N404SWWood Roger W · Sale Creek, TNBuilt 1968 · S/N 17256702N404TWRobison Dave · Roberts, IDBuilt 1997 · S/N 1348N404UXSimply Living LLC · Fort Myers, FLBuilt 1969 · S/N 28-5423N404ZMuehlberg Stephen E · Newcastle, OKBuilt 2025 · S/N 75-10404N405Burklund Joel H · Minneapolis, MNBuilt 1996 · S/N 1340N40506Dingler Larry G · Langtry, TXS/N 1753N4050GSpellbound Inc · White Bear Lake, MNBuilt 1991 · S/N 1776N4050NCrawford Reagan Matthew · Lumberton, TXBuilt 1968 · S/N 680026N4051PEagle 64 LLC · Stuart, FLBuilt 1958 · S/N 23-1528N40520Goodman Larry D Trustee · Prineville, ORBuilt 1975 · S/N 18-7509121N40523Gossett Owen L · Central Point, ORBuilt 1975 · S/N 18-7509123N4052AWard Daniel W · Boonville, NCBuilt 1979 · S/N DV0100N4052FG&M Aircraft Inc · Wheat Ridge, COBuilt 1976 · S/N 28-7790002N4052VBorror Eric F · Gerber, CABuilt 1956 · S/N 18-5218N4052ZMetro Service Air · Fairbanks, AKBuilt 1963 · S/N 18-8054N4053ZSpohnholz Randy K · Anchorage, AKBuilt 1963 · S/N 18-8056N40549Agnew Mark W · Wasilla, AKBuilt 1969 · S/N 18-8865N4054XLongmire Vaughn H · Tampa, FLS/N 5154N4054ZBiggs Craig P · Preston, IDBuilt 1963 · S/N 18-8059N4055Olegueoa Jesse V · Riverside, CABuilt 1951 · S/N 113N40552Peeler Jason B · Flooresville, TXS/N 18-7509126N40558Hill Casey J · Anchorage, AKBuilt 1975 · S/N 18-7509127N4055ZMartin Lawrence M · Clam Gulch, AKS/N 18-8060N4056MBarfield Anthur F · Fairborn, OHBuilt 1991 · S/N 1793N4056XHolliday Ralph C III · Coppell, TXBuilt 1970 · S/N 5156N4056ZG & L Airborne Inc · Wilmington, DEBuilt 1963 · S/N 18-8064N40575Evans Samuel F · Iuka, MSBuilt 1976 · S/N 18-7709018N40579Burwell Jeffery S · Wasilla, AKBuilt 1976 · S/N 18-7509129N4057MUsac Airways 693 LLC DBA · Fort Lauderdale, FLBuilt 1947 · S/N 12-2940N4057NMominee Jules T · Evansville, INBuilt 1968 · S/N 680027N4057ZBruegger Shannon B · Lance Creek, WYBuilt 1963 · S/N 18-8066N4058NHancock Randall G · Evanston, WYBuilt 1968 · S/N 680168N4058XLeading Edge Aviation Foundation Inc · Mountain Home, ARFirst renewal noticeBuilt 1970 · S/N 5158N405AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843738N405ASJagadeesh Akhil V · Chicago, ILBuilt 1972 · S/N 28-7205263N405CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881110N405CMHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 2000 · S/N 3096N405DSDelaware State University · Dover, DEBuilt 1976 · S/N 28-7715243N405DTSkiles Carl A · Leander, TXS/N 17702389N405FLRiggin Flight Service Inc · Madison, SDBuilt 1971 · S/N 28-7125181N405HHGuardian Aviation LLC · Lakeland, FLS/N 2417N405MAHigh Ways LLC · Colorado Springs, COBuilt 2005 · S/N 40.546
Back to AD 90-04-06 R1