OpenAirDocs.org
AD 90-06-03 R1

Registered aircraft · 20,683

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.

N734BNAlameda Aero Club · Alameda, CABuilt 1977 · S/N 17268727N734BQTri State Aviation Inc · Wahpeton, NDS/N 17268729N734BTSorbi Aviation Inc · El Cajon, CABuilt 1977 · S/N 17268732N734BUAirplanes And Attitude LLC · Mckinney, TXBuilt 1977 · S/N 17268733N734BVTurner Richard D · Panama City, FLS/N 17268734N734BWSuperior Aviation Gateway LLC · Tampa, FLBuilt 1977 · S/N 17268735N734BXGreene Travis Charles · Acworth, GABuilt 1977 · S/N 17268736N734BZBurleson Cameron Reynolds · Oak Island, NCBuilt 1977 · S/N 17268738N734CCFranks Janice G · Eagleville, TNBuilt 1977 · S/N 17268741N734CFRivertown Flying Partnership · Marine On St Croix, MNBuilt 1977 · S/N 17268744N734CHC & R Aircraft Llp · Perry Hall, MDBuilt 1977 · S/N 17268746N734CJWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 17268747N734CLStates Construction Company · Indianola, IABuilt 1977 · S/N 17268749N734CP5280 Flying Club LLC · Castle Pines, COBuilt 1977 · S/N 17268752N734CQGuadagnola C Thomas Trustee · El Cajon, CABuilt 1977 · S/N 17268753N734CRBaker Thomas M · Knoxville, PAS/N 17268754N734CSBondurant Christopher T · Hendersonville, TNBuilt 1977 · S/N 17268755N734CTWalsh Thomas M · Rllng Hls Est, CABuilt 1977 · S/N 17268756N734CVHager David L · Barney, NDBuilt 1977 · S/N 17268758N734DACalifornia In Nice Inc · San Jose, CABuilt 1977 · S/N 17268763N734DCSchmitt Jeffrey · Nordman, IDBuilt 1977 · S/N 17268765N734DESchneider Paul W · Holmen, WIBuilt 1977 · S/N 17268767N734DGRiverside Flight Academy LLC · Riverside, CABuilt 1977 · S/N 17268769N734DKLankford James W · Corpus Christi, TXS/N 17268772N734DNSeven 4 Zulu LLC · San Diego, CABuilt 1977 · S/N 17268775N734DQHartz Farm Management Inc · Stuttgart, ARBuilt 1977 · S/N 17268777N734DRDrnek Scott D · Hayward, CABuilt 1977 · S/N 17268778N734DSFly Aviation Corp · Wilmington, DES/N 172-68779N734DTSilver Express Co DBA · Miami, FLBuilt 1977 · S/N 17268780N734DVWilliams Gary R · Albuquerque, NMBuilt 1977 · S/N 17268782N734DYFour Delta Yankee Inc · Pennington, NJBuilt 1977 · S/N 17268785N734DZBlotsky Jim Darin · Fargo, NDBuilt 1977 · S/N 17268786N734EATschacher Farms Inc · Manville, WYBuilt 1977 · S/N 17268787N734EDScapegoat Aviation LLC · Choteau, MTBuilt 1977 · S/N 17268789N734EQAero-Sphere Inc · Longmont, COS/N 17268800N734ERGrantham Jack Q Jr · Stockbridge, GAS/N 17268801N734ESDc Aero LLC · Ramona, CAS/N 17268802N734EWRed-Tailed Hawks Aviation Academy Inc · Mukilteo, WAS/N 17268806N734EYRegistration Pending · Saint Petersburg, FLRegistration pendingBuilt 1977 · S/N 17268808N734EZMiklos Bruce A · Meridian, IDBuilt 1977 · S/N 17268809N734FALima-001 LLC · Muscatine, IABuilt 1977 · S/N 17268810N734FDJays Aircraft Maintenance Inc · Costa Mesa, CABuilt 1977 · S/N 17268813N734FECenturion Aviation Services LLC · Racine, WIS/N 17268814N734FGTextron Aviation Inc · Wichita, KSS/N 172S13644N734FJRobert Peccia And Associates Inc · Helena, MTBuilt 1977 · S/N 17268818N734FMD2 Government Solutions LLC · New Bern, NCBuilt 1977 · S/N 17268820N734FNSafety In Motion Flight Center Inc · Puyallup, WABuilt 1977 · S/N 17268827N734FQBraithwait Leonard D · Washougal, WABuilt 1977 · S/N 17268823N734FRWhite Jack A Jr · Naples, FLBuilt 1977 · S/N 17268824N734FSDouble Bridges Aviation LLC · Enterprise, ALBuilt 1977 · S/N 17268825
Back to AD 90-06-03 R1