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.

N8549UFauver Russell · Hartsville, SCS/N 17252449N854ACKurchian Aram M · Sunland, CABuilt 1975 · S/N 17265443N854AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2026 · S/N 172S13536N854EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 172S13228N854GWCondair Flyers Inc · Latham, NYBuilt 2001 · S/N 172S8854N854SCAlpha Charlie Aviation LLC · Keizer, ORBuilt 2019 · S/N 172S12329N8551UFishman Randall · Napanoch, NYBuilt 1964 · S/N 17252451N8552BTenney Curtis J · Sevierville, TNBuilt 1957 · S/N 36252N8553BVaught Ralph S · Star Valley, AZBuilt 1957 · S/N 36253N8553UFinley Todd R · Carmel, INBuilt 1965 · S/N 17252453N8554BSummers Kim C · Winnemucca, NVBuilt 1957 · S/N 36254N8554UWorkman David A · Putnam, ILBuilt 1965 · S/N 17252454N8555BThompson Greg M · Rigby, IDBuilt 1957 · S/N 36255N8555ULeaf Sport LLC · Henning, MNBuilt 1965 · S/N 17252455N8556BKendig Dustin Zarah · Portland, ORBuilt 1957 · S/N 36256N8557UOconnor Jonathan D · East Aurora, NYS/N 17252457N8558BWilliams Ralph J · Essex Junction, VTBuilt 1957 · S/N 36258N8558UNelson David R · Stanwood, WABuilt 1965 · S/N 17252458N855CPVector Air LLC · Erie, COBuilt 1998 · S/N 17280461N855EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 172S13231N8561USmith Michael V · Fort Myers, FLBuilt 1964 · S/N 17252461N8562UMall Craig S · Dingmans Ferry, PABuilt 1965 · S/N 17252462N8563UCanupp Joseph J · Clinton, SCBuilt 1964 · S/N 17252463N8564BKarpe Kendall K · Plymouth, MNBuilt 1957 · S/N 36264N8565BQuill James M · Granby, MABuilt 1957 · S/N 36265N8567UPfeiffer Rebecca M · Independence, MNBuilt 1964 · S/N 17252467N8568QSkyhawk Aero LLC · Montevideo, MNBuilt 1967 · S/N 17255780N8569BSpraches Edward J · Franklin, NCS/N 36269N856AUAuburn University · Auburn, ALBuilt 2017 · S/N 172S12094N856EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12674N856FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13460N8570BPilot Coaches LLC · Little Falls, MNS/N 36270N8571UBell Charles M DBA · Warsaw, NYBuilt 1965 · S/N 17252471N8575UVermillion County Flying Club · Danville, ILBuilt 1965 · S/N 17252475N8576BRomeo Delta Inc · Elsie, MIBuilt 1957 · S/N 36276N8579UStueckradt Steve · Ankeny, IABuilt 1965 · S/N 17252479N857AUAuburn University · Auburn, ALBuilt 2018 · S/N 172S12126N857SPSoutheastern Oklahoma State University · Durant, OKS/N 172S8115N8580BB&R Aircraft LLC · Wadsworth, OHBuilt 1958 · S/N 36280N8580UBaker Shane A · Marshall, WIBuilt 1965 · S/N 17252480N8581ULarkin John · Cambridge, IDBuilt 1965 · S/N 17252481N8582BHousley William M · Jasper, ALS/N 36282N8582UMartin Livestock LLC · Ione, CABuilt 1965 · S/N 17252482N8583UVon Burg Jon B · Hull, ILS/N 17252483N8584VIdk Ventures LLC · Olympia, WABuilt 1965 · S/N 17252484N8585UTreats Aviation Inc · Enumclaw, WABuilt 1965 · S/N 17252485N8587BDorsey Tony A · Anchorage, AKBuilt 1958 · S/N 36287N8587U172 Blue Wings LLC · Berwyn, PABuilt 1965 · S/N 17252487N8588UNachio Aviation Services LLC · Tucson, AZS/N 17252488N8589BHansen Aviation LLC · Savannah, GABuilt 1957 · S/N 36289
Back to AD 90-06-03 R1