OpenAirDocs.org
AD 90-06-03 R1

Registered aircraft · 20,687

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-06-03-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-06-03-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.

N7643TGarcia Yonhara Fortun Faedo · Norco, CABuilt 1960 · S/N 47243N7643XBrackman Aviation LLC · Twin Falls, IDBuilt 1960 · S/N 17248143N7644GSkypark Inc · Wadsworth, OHBuilt 1970 · S/N 17259344N7646GSky Aviation LLC · Encinitas, CABuilt 1970 · S/N 17259346N7646XGeorge James D · Aurora, INS/N 17248146N7647GIowa Lakes Community College · Estherville, IAS/N 17259347N7647THolmen Roger A · Carlsbad, NMS/N 47247N7648TAppel Jacob · Redfield, SDS/N 47248N7649TScott Steve W · Antioch, CAS/N 47249N764AAWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17265624N764BKFairmont State University · Fairmont, WVBuilt 1976 · S/N 17266891N764SPColonial Air Inc · New Bedford, MABuilt 2001 · S/N 172S8697N7651XHappy Landings Aviation LLC · Maple, NCS/N 17248151N7655TMorrell Nathaniel A · Pelham, GABuilt 1960 · S/N 47255N7655XMedical Surgical Clinic LLC · Fort Scott, KSBuilt 1960 · S/N 17248155N7656XMiranda Maria J · Santa Maria, CABuilt 1960 · S/N 17248156N7657TGuarno Adam C · Milton, FLBuilt 1960 · S/N 47257N7657XGordon Christopher R · Moose Pass, AKBuilt 1960 · S/N 17248157N7659TKano Yoshio W · Barrington, ILBuilt 1960 · S/N 47259N765SATextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13580N7660GKorn Clifton A · Hayward, WIBuilt 1970 · S/N 17259360N7660XAdams John S · Roselle, ILBuilt 1960 · S/N 17248160N7662GB&R Aircraft LLC · Wadsworth, OHBuilt 1970 · S/N 17259362N7662TTriana David · Goose Creek, SCBuilt 1960 · S/N 47262N7663TTc Flight LLC · Lincoln, NES/N 47263N7665XAvz Aviation.Inc · Knoxville, TNS/N 17248165N7666GHudson Daryl J · Redwood Valley, CABuilt 1970 · S/N 17259366N7666XSidaras Al · Salado, TXBuilt 1960 · S/N 17248166N7667GBrooks Alan G · Kernersville, NCBuilt 1970 · S/N 17259367N7667THembree Roy C Jr · Covington, GABuilt 1960 · S/N 47267N7667XMatthews Thomas A · Belvidere, NJBuilt 1960 · S/N 17248167N7668THoff Stephen R · Wilson, WYBuilt 1960 · S/N 47268N7668XEkerberg Mark J · Newton, KSBuilt 1960 · S/N 17248168N7669GWingsleasing LLC · Wichita, KSBuilt 1970 · S/N 17259369N766CPCity Of Cleveland · Cleveland, OHBuilt 1975 · S/N 172-66326N766PDTexas State Technical College · Waco, TXBuilt 2000 · S/N 172S8419N766SPMaxxum Financial Group Inc · Destrehan, LABuilt 2001 · S/N 172S8699N766TWBarr Air Patrol LLC · Mesquite, TXBuilt 1980 · S/N 17274134N7670GPremier Aviation LLC · Philadelphia, MSBuilt 1970 · S/N 17259370N7670XLohrke James W · Converse, TXBuilt 1960 · S/N 17248170N7671XBernsen Timothy Stephen · Devine, TXS/N 17248171N7672XFlying Couch LLC · Orleans, MABuilt 1961 · S/N 17248172N7673GSchaack Lawrence A · Woods Cross, UTBuilt 1970 · S/N 17259373N7673TDunning Steve G · Assaria, KSBuilt 1960 · S/N 47273N7673XDunham Randy C DBA · Lawton, OKBuilt 1960 · S/N 17248173N7674TDugger Robert F · Ashville, ALBuilt 1960 · S/N 47274N7675TClegg Peter M · Grace, IDS/N 47275N7675XEstes Jerry L · Lewisville, ARBuilt 1960 · S/N 17248175N7676GPalmer Michael C · Emmett, IDBuilt 1970 · S/N 17259376N7676TNickerson David W · East New Market, MDBuilt 1960 · S/N 47276
Back to AD 90-06-03 R1