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.

N8190LOlsen Curtis O · Lindon, UTS/N 17256390N8191UAnderson Amy J · Manistique, MIBuilt 1964 · S/N 17252091N8192BAll Sports Aviation LLC · Sandpoint, IDBuilt 1957 · S/N 29992N8192LSteinmetz William · Lakeville, INBuilt 1967 · S/N 17256392N8192UMichael Isiah · Jersey City, NJBuilt 1964 · S/N 17252092N8192XBryant Emily G DBA · Limestone, TNBuilt 1961 · S/N 17248692N8193LDavis Timothy A · Oklahoma City, OKBuilt 1967 · S/N 17256393N8193XMarine Outlet Inc · Temple, TXBuilt 1961 · S/N 17248693N8194BRegistration Pending · Gold Hill, ORRegistration pendingS/N 29994N8194UHutson Clayton · Elgin, OKBuilt 1964 · S/N 17252094N8196LMoore Nick C · Adamsville, TNBuilt 1967 · S/N 17256396N8196XDavis Joel A · Tunkhannock, PABuilt 1961 · S/N 17248696N8197BDaughtrey Kevin E · Arcadia, FLBuilt 1957 · S/N 29997N8198UTower Christopher M · Piedmont, OKBuilt 1964 · S/N 17252098N8199BVitek August J · Granger, TXBuilt 1957 · S/N 29999N8199UReeder James T · Ottawa, KSS/N 17252099N819CFParlor City Flying Club Inc · Bloomsburg, PABuilt 1998 · S/N 17280451N819EPTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13600N819EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2022 · S/N 172S12823N819KSN819ks LLC · Palm City, FLBuilt 2000 · S/N 17280914N81FFPeregrine Howard Partners II Lp · New Orleans, LABuilt 2023 · S/N 172S12948N81JDBarbour Grays Inc DBA · Buckhannon, WVFirst renewal noticeBuilt 1985 · S/N 172RG1184N81KSChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10659N8200XKlad-Air LLC · Catlett, VABuilt 1961 · S/N 17248700N8201LLonghorn Fligh Training LLC · Midlothian, TXBuilt 1967 · S/N 17256401N8201ULerma Homero G · Mcallen, TXBuilt 1964 · S/N 17252101N8202LHorizon Flights Corp · Henderson, NVNon-citizen corporation, flight hours not reportedBuilt 1967 · S/N 17256402N8202UBudget Flyers · Shreveport, LABuilt 1964 · S/N 17252102N8202XFerris Tyler S · Pompano Beach, FLFirst renewal noticeS/N 17248702N8204LJohnson Kathy L · Wellsburg, WVBuilt 1967 · S/N 17256404N8204USchenck Paul · Glendale, CAS/N 17252104N8204XWallace Howard C · Lompoc, CABuilt 1961 · S/N 17248704N8205BHarrison Joseph T · Pensacola Beach, FLBuilt 1957 · S/N 36005N8205UDby Flights LLC · Pennock, MNBuilt 1964 · S/N 17252105N8206LPratt Errol C · Fayetteville, GABuilt 1967 · S/N 17256406N8206UShortridge Gary F · Dover, TNBuilt 1964 · S/N 17252106N8207LAero Biz Development Group LLC · Washington, DCBuilt 1967 · S/N 17256407N8208BWidincamp Steve F · Dahlonega, GABuilt 1957 · S/N 36008N8208EChamplain Island Hoppers · Burlington, VTBuilt 1979 · S/N 17272153N8208LMt Avi8or LLC · Sheridan, WYBuilt 1967 · S/N 17256408N8208XCompass Kitty Hawk LLC · Winneconne, WIBuilt 1961 · S/N 17248708N8209LAbel John R · Haslet, TXBuilt 1967 · S/N 17256409N820AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2026 · S/N 172S13530N820DAb Prop Plane II LLC · Metairie, LABuilt 2020 · S/N 172S12565N820EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2021 · S/N 172S12664N820JANutac Leasing LLC · Deland, FLBuilt 2008 · S/N 172S10802N820KSUniversity Of Central Missouri · Warrensburg, MOBuilt 1999 · S/N 17280486N820NR120 Volantes LLC · Cleveland, MSS/N 17250936N8210BGibson-Craig-Carmichael Anita Yvonne · Blacksburg, VABuilt 1957 · S/N 36010N8211BHayfield Technical Services LLC · Tahlequah, OKS/N 36011
Back to AD 90-06-03 R1