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.

N7296GWind Walker LLC · Tucson, AZS/N 17258996N7296QRich Aviation Services LLC · Fort Worth, TXBuilt 1972 · S/N 17260596N7296TTurner Clinton C · Springdale, ARBuilt 1959 · S/N 46896N7297AMyers Maxwell D · Salt Lake City, UTS/N 29397N7299QStout Oscar M · Brookshire, TXS/N 17260599N7299TOstrowski Sven E · Mullica Hill, NJBuilt 1959 · S/N 46899N729EBoard Of Trustees Of Southern Illinois Universtiy · Carbondale, ILBuilt 2023 · S/N 172S12965N729JHDickman Robert J · Richmond, INBuilt 1978 · S/N 17271839N729LUTextron Aviation Inc · Wichita, KSS/N 172S13596N729MTHochreiter Heinrich · Bellingham, WABuilt 1999 · S/N 172S8272N729SPMars Aerospace Inc · Bay Shore, NYBuilt 2000 · S/N 172S8666N729WDMonroe Greg · Linden, TNBuilt 1960 · S/N 47583N72BLSkrow Works Inc · West Monroe, LAS/N 17257795N72CCCaterfull Inc · Miami Beach, FLBuilt 1975 · S/N 17266347N72CXCorsair Engine Technologies · Colorado Springs, COBuilt 1969 · S/N 17258725N72EFN72ef LLC · Canton, GABuilt 2000 · S/N 172S8636N72ERMaierhoffer Henry F Jr · Sylvania, GABuilt 1977 · S/N 17269501N72FDEngesath David H · Duluth, MNBuilt 1974 · S/N 17263913N72FFFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 172S12936N72JNTroy I Mounts Md Inc · San Juis Obispo, CABuilt 1974 · S/N 17263882N72NXNexair Avionics LLC · Plymouth, MABuilt 1976 · S/N 17267923N72PFKuck Russell W · Aguila, AZBuilt 1965 · S/N 17253530N72SAInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 17272017N72STSierra Tango Air LLC · Senoia, GAS/N 17269433N73001Spooter Air LLC · Obion, TNBuilt 1976 · S/N 17267232N73010Rico Aviation Services Inc · Miami, FLBuilt 1976 · S/N 17267235N73015Alameda Flying Club Inc · Richmond, CABuilt 1976 · S/N 17267238N7301GFreeport Flyers Inc · Freeport, ILBuilt 1970 · S/N 17259001N7301THolte Martin W · Burnsville, MNBuilt 1959 · S/N 46901N73020Ajf Enterprises LLC · Des Moines, IABuilt 1976 · S/N 17267239N73028Halley Craig H · Lanai City, HIBuilt 1976 · S/N 17267241N7302ASkywagon Aero LLC · Wilmington, DEBuilt 1956 · S/N 29402N7302GSmith Neil W · Rincon, GABuilt 1970 · S/N 17259002N7302TSchaff James F · Prescott, AZBuilt 1959 · S/N 46902N7303ALogajan James M · Rapid City, SDBuilt 1956 · S/N 29403N73040Goulding Brian K · Roswell, GABuilt 1976 · S/N 17267247N73041Max Air Aviation LLC · Carrollton, GABuilt 1976 · S/N 17267248N73043Six Ten Ventures LLC · Cedar Hill, TXBuilt 1976 · S/N 17267250N7304GChapman David C · Summersville, WVBuilt 1970 · S/N 17259004N73054Blue Wings LLC · Spokane, WABuilt 1976 · S/N 17267253N7305AK&M Aviation LLC · West Liberty, KYS/N 29405N73063Oregon State Flying Club · Corvallis, ORBuilt 1976 · S/N 17267256N73064Whitelam Bruce R · Sacramento, CABuilt 1976 · S/N 17267257N73068Christensen Gary D · Alliance, NEFirst renewal noticeBuilt 1976 · S/N 17267259N73069Eagle Sky Patrol Inc · Deadwood, SDBuilt 1976 · S/N 17267260N7306AFloyd Ckyler Don · Bowman, NDS/N 29406N7306EG & M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 17272081N7306TFaull Ron W · Sandpoint, IDS/N 46906N7307ACook Raymond L · Clarksville, TNBuilt 1956 · S/N 29407N7308GOrlandi Properties LLC · Blairstown, NJBuilt 1970 · S/N 17259008
Back to AD 90-06-03 R1