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.

N2787UNethery Autumn M · Shelbyville, KYBuilt 1963 · S/N 17250387N2789LChurch Sammy H · Statesville, NCBuilt 1967 · S/N 17255989N2789UKruse Russell E Jr · Siren, WIBuilt 1963 · S/N 17250389N278BDStubbs J Phillip · Richmond, VABuilt 1967 · S/N 17255945N278CA278ca LLC · Union Gap, WABuilt 2008 · S/N 172S10801N278FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13453N278SPSvetful Aviation LLC · Camden, SCBuilt 2003 · S/N 172S9474N2790LWells Mark L · Eads, TNBuilt 1967 · S/N 17255990N2795JEndeavour Flight Training Inc · Miami, FLBuilt 1979 · S/N 17273650N2795LHarkness Paul E · Richmond Hill, GABuilt 1967 · S/N 17255995N2795URichardson Robert S · Austin, TXBuilt 1963 · S/N 17250395N2796LSmyth Michael L · Saint Charles, MOBuilt 1967 · S/N 17255996N2797EPalm Beach Flyers LLC · Boca Raton, FLS/N 17271324N2798EPumpkin Eater LLC · Tavares, FLBuilt 1978 · S/N 17271325N2799UWinslow Linda S Trustee · Creswell, ORS/N 17250399N279MEBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 172S8535N27AHM W T Aviation LLC · Jamestown, NYBuilt 1975 · S/N 17265306N27BLFairmont State University · Fairmont, WVBuilt 2020 · S/N 172S12467N27CSFeauto Aviation Inc · Saint Cloud, FLBuilt 1964 · S/N 17251680N27GFAmerican Patrols Inc · Midland, TXBuilt 1981 · S/N 17274608N27LASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1975 · S/N 17265689N27MVNorthwestern Michigan College · Traverse City, MIBuilt 2020 · S/N 172S12599N27TJTj Aero LLC · Winchester, MABuilt 2021 · S/N 172S12656N27TPTandem Skydive Saipan Inc · Saipan, MPBuilt 2016 · S/N 172S11690N2800LGarcia Fernando · Laredo, TXBuilt 1967 · S/N 17256000N2800UFAA LLC · Big Lake, AKBuilt 1963 · S/N 17250400N2801EJ4 Aero LLC · Gulf Breeze, FLBuilt 1978 · S/N 17271327N2801UDallas Flying Associates Inc · Dallas, TXBuilt 1963 · S/N 17250401N2802UPatterson Bud N · Perry, OKBuilt 1963 · S/N 17250402N2803USwan Aviation Ministries Inc · Laurel Hill, FLS/N 17250403N2805QA L Hollandsworth LLC · Columbia, MOBuilt 1971 · S/N 17259805N2805UContinental Skylarks Inc · Deer Park, NYBuilt 1963 · S/N 17250405N2806EBexar Aviation LLC · San Antonio, TXBuilt 1978 · S/N 17271328N2806QLawson Lance J · Sikeston, MOBuilt 1971 · S/N 17259806N2806UWeeber Charles · Pelham, MABuilt 1963 · S/N 17250406N2807EMission One LLC · Excelsior, MNBuilt 1978 · S/N 17271329N2807LBerisha James · Porter, TXS/N 17256007N2807QReynolds David F · Port Orange, FLBuilt 1971 · S/N 17259807N2807UMeese Brian D · Conroe, TXBuilt 1963 · S/N 17250407N2809LWarner Walter M Jr · Willow, AKBuilt 1967 · S/N 17256009N2809UBleskan Erick J · New Berlin, WIBuilt 1963 · S/N 17250409N280JAFlying Tigers Flight School Ltd · Houston, TXBuilt 2000 · S/N 172S8620N280MEAmerican Aviation Inc · Brooksville, FLBuilt 2000 · S/N 172S8536N280MSM & S Air Service Inc · Honeoye Falls, NYBuilt 1973 · S/N 17261450N280PEBravo Leasing LLC · Daytona Beach, FLBuilt 2008 · S/N 172S10834N280SCJuliet Charlie Aviation LLC · Oregon City, ORS/N 172S12443N280SLRamer Scott A · Dornsife, PAS/N 172-73121N280SUOhio State University · Columbus, OHBuilt 2020 · S/N 172S12432N280UOhio University · Athens, OHBuilt 2003 · S/N 172S9464N2810QMcdowell Kevin J · Williamsburg, VABuilt 1971 · S/N 17259810
Back to AD 90-06-03 R1