OpenAirDocs.org
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.

N9641HBarton Alva L · Hollister, CABuilt 1975 · S/N 17266288N9641QBhairavi Aviation LLC · Santa Clarita, CABuilt 1975 · S/N 17265725N9641VRink Douglas B · Woolwich, MEBuilt 1974 · S/N 17264421N9643HMor Aviation N9643h LLC · Gaithersburg, MDBuilt 1975 · S/N 17266290N9643QLeading Edge Flight Academy LLC · Bend, ORBuilt 1975 · S/N 17265727N9643VBrazos Valley Flight Services LLC · College Station, TXBuilt 1974 · S/N 17264423N9644QSkyhawks Inc · Chippewa Falls, WIBuilt 1975 · S/N 17265728N9645HSantiago Diana L · Juana Diaz, PRBuilt 1975 · S/N 17266292N9645VOak Ridge Flyers Inc · Oak Ridge, TNBuilt 1974 · S/N 17264425N9646BN9646b LLC · Wilmington, DEBuilt 1981 · S/N 172RG0942N9647BLakewood Investments LLC · Victorville, CAS/N 172RG0943N9647QKaeni Law Group Inc · Santa Ana, CABuilt 1975 · S/N 17265731N9648HSaunders Larry F · Sulphur Springs, ARBuilt 1975 · S/N 17266294N9648QGreen Bay Flying Club Inc · Krakow, WIBuilt 1975 · S/N 17265732N9648VGrove Kaylene · San Diego, CABuilt 1974 · S/N 17264428N96493Smtm Holdings Inc · Wilmington, DES/N 17276080N9649BGoebel Christian E · Luray, VABuilt 1981 · S/N 172RG0945N9649VLagorce Victor X · Owasso, OKBuilt 1974 · S/N 17264429N964AAFlorida Flight Training Center Inc · Venice, FLBuilt 1978 · S/N 17271084N964AUAuburn University · Auburn University, ALBuilt 2020 · S/N 172S12479N964EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S13010N964LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 172S12034N964SPDirty Side Down Aviation LLC · Georgetown, TXBuilt 1999 · S/N 172S8176N96503Miravete Paul Trustee · Saint George, UTBuilt 1983 · S/N 17276081N9650QVon Graff Kurt · Pennington, NJBuilt 1975 · S/N 17265734N9650VPittman Michael Sr · Chandler, AZBuilt 1974 · S/N 17264430N9651VHussain Mahmoud Taimour Said · Miami, FLBuilt 1974 · S/N 17264431N9652VBrown Keno · Athens, TXBuilt 1974 · S/N 17264432N9653BSd Office Supplies & Furniture Rentals LLC · Chula Vista, CABuilt 1981 · S/N 172RG0946N9653QMikeska Rudy L · Taylor, TXBuilt 1975 · S/N 17265737N9654BDonohue Andrew · Tulsa, OKBuilt 1981 · S/N 172RG0947N9654QFly Pioneer Valley LLC · Gill, MABuilt 1975 · S/N 17265738N9654VN9654v LLC · Lakeland, FLS/N 17264434N96567Gmt Aviation LLC · Newtown, CTBuilt 1984 · S/N 17276086N9656QMccort Daniel R · Pensacola, FLBuilt 1975 · S/N 17265740N96573Condor Aero Club Inc · Zelienople, PABuilt 1984 · S/N 17276088N96575Biryukov Ruslan B · Encino, CABuilt 1984 · S/N 17276089N96579Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 17276090N9657VChorman Spraying LLC · Milton, DEBuilt 1974 · S/N 17264437N9659HJd Griffin LLC · Wilmington, DEBuilt 1975 · S/N 17266296N9659QMacrafic Bruce A · Garden City, MNBuilt 1975 · S/N 17265743N965AUAuburn University · Auburn University, ALBuilt 2020 · S/N 172S12480N965BBBascom Kimber Keith · Mckinney, TXBuilt 2013 · S/N 172S11251N965EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S13013N965LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 172S12035N965MSMt San Antonio College · Walnut, CABuilt 1973 · S/N 17261395N9660BHenry Lawrence D · Lohman, MOBuilt 1981 · S/N 172RG0952N9660HCdb Group Holdings LLC · Sheridan, WYBuilt 1975 · S/N 17266297N96616Air Transport Inc DBA · Las Vegas, NVS/N 17276094N96621D Gordon Aviation Inc · La Jolla, CABuilt 1984 · S/N 17276096
Back to AD 90-06-03 R1