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.

N683SPNovember 243 Bravo Mike LLC · Castle Rock, COBuilt 1999 · S/N 172S8094N6840AMcnaught Scott S · Winlock, WABuilt 1956 · S/N 28940N6840XDesertshot Inc · El Paso, TXBuilt 1960 · S/N 47740N6841ASmooth Flying LLC · Barnwell, SCBuilt 1956 · S/N 28941N6841XNelson Ricky R W · Mandan, NDS/N 47741N6843HWhitefish Mountain Acft Rentals And Flt School LLC · Whitefish, MTBuilt 1975 · S/N 17265604N6843XBoone Alan · Bangor, MEBuilt 1960 · S/N 47743N68460Registration Pending · Sheridan, WYRegistration pendingBuilt 1977 · S/N 17268460N6847AEwald Christopher Robert · Blanding, UTBuilt 1956 · S/N 28947N6848XHinkleman Howard R · Brownsboro, ALBuilt 1960 · S/N 17247748N6849XReiss Alan T · Gig Harbor, WAS/N 17247749N684DWSun Aircraft Management LLC · Ormond Beach, FLBuilt 2000 · S/N 17280945N684SPCondor Aero Club Inc · Zelienople, PABuilt 1999 · S/N 172S8095N6851ECharlie Lima 1 LLC · Jacksonville, FLBuilt 1978 · S/N 17272074N6852AFabian Ryan S · Vancouver, WABuilt 1956 · S/N 28952N6852HSetter Jory · Midvale, UTBuilt 1975 · S/N 17265608N6853HJohnson Seth W · North Pole, AKBuilt 1975 · S/N 17265609N6854ADulin Thad L · Midland, TXBuilt 1956 · S/N 28954N6854HN6854h LLC · Opa Locka, FLBuilt 1975 · S/N 17265610N6855ACowley Dale Thomas Trustee · Sandusky, MIS/N 28955N6857HNew Mexico Flying Eagle Inc · Tucson, AZBuilt 1975 · S/N 17265611N6858ACorrigan Flying Club · Manitowoc, WIBuilt 1956 · S/N 28958N6858HPrairie Skies Aviation LLC · Hutchinson, KSBuilt 1975 · S/N 17265612N6858XHoang Andrew Q · Seal Beach, CABuilt 1960 · S/N 17247758N6859AClark Brenton J · Fairfield, IAFirst renewal noticeS/N 28959N6859HRoeper Gary Lee · Linden, MIS/N 17265613N6859XWilkerson Bradley W · Caldwell, IDBuilt 1960 · S/N 17247759N685BBHeavenly Flight LLC · Cumming, GABuilt 2023 · S/N 172S12980N685DWUpper Valley Flying Club Inc · White Riv Jct, VTBuilt 2000 · S/N 17280946N685SPDirty Side Down Aviation LLC · Georgetown, TXBuilt 1999 · S/N 172S8096N6860HUniversity Of Michigan Flyers · Ann Arbor, MIBuilt 1975 · S/N 17265614N6861HViking Systems Inc · Naples, FLS/N 17265615N6862HStrickland J A · Fairbanks, AKBuilt 1975 · S/N 17265616N6863AZinter Dean K · Tigard, ORBuilt 1956 · S/N 28963N6863TBering Capital LLC · Anchorage, AKBuilt 1973 · S/N 17262470N6864ABrusik John A Jr DBA · New Port Richey, FLS/N 28964N6864HMay Jeffrey N · Ocala, FLBuilt 1975 · S/N 17265618N6865XGessley Lester Jack Jr · Port Saint Lucie, FLBuilt 1960 · S/N 17247765N6866AJlk Inc · Malvern, ARBuilt 1956 · S/N 28966N6866HParrish Michael C Trustee · Lakeland, FLBuilt 1975 · S/N 17265619N6867AHeffron Jacob L · Little Falls, MNS/N 28967N6868XRegistered aircraftBuilt 1960 · S/N 17247768N6869AMccraney John K · Canon, GAS/N 28969N6869TCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 2005 · S/N 172S10001N6869XSquires Aaron Lane · Aynor, SCS/N 17247769N686DBAnderson Bruce Robert · Mena, ARS/N 172-68334N686DWSunrise Aviation Inc · Ormond Beach, FLBuilt 2000 · S/N 17280947N686PXTextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2023 · S/N 172S13020N686SPRainier Flight Service LLC · Renton, WABuilt 1999 · S/N 172S8097N6871AGibson James G · Harpers Ferry, WVBuilt 1956 · S/N 28971
Back to AD 90-06-03 R1