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.

N676CHTake Off Aviation Services LLC · Rockledge, FLBuilt 1976 · S/N 17266905N676CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11537N676DWSunrise Aviation Inc · Ormond Beach, FLBuilt 1999 · S/N 17280774N676EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12745N6770AHele David A · Birchwood, WIBuilt 1956 · S/N 28870N6775AField Eaton Fredrick F · Tigard, ORBuilt 1956 · S/N 28875N6777AScheithauer Christopher P · Cement City, MIBuilt 1956 · S/N 28877N6778AQuadrani Anthony · Kingsford, MIBuilt 1956 · S/N 28878N6778EBelmas Bradley S · Ironwood, MIBuilt 1978 · S/N 17272064N6779ASpanbauer Paul J · Oshkosh, WIS/N 28879N677AARidgeline Assets LLC · Wilmington, DEBuilt 2018 · S/N 172S12151N677DMAa-Aero Inc · Fairfield, NJBuilt 2004 · S/N 172S9661N677JARaji LLC · Mclean, VABuilt 2008 · S/N 172S10677N6780HMerrell Shane F · Shelby, ALBuilt 1975 · S/N 17265579N6782HJb Aviation Management Inc · Wonder Lake, ILBuilt 1975 · S/N 17265580N6784AAtlantic Rotors LLC · Saint Inigoes, MDBuilt 1956 · S/N 28884N6786ARutledge Brett B · Yuma, COS/N 28886N6787HGordon Caleb J · Waukesha, WIBuilt 1975 · S/N 17265582N6789AChris Fuher Flight Instruction LLC DBA · Townsend, MTS/N 28889N678AAWings Over Texas Holdings LLC · Denton, TXS/N 172S10663N678KPalm Steven · Madera, CABuilt 1956 · S/N 29454N678NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2015 · S/N 172S11619N678RBBoldflight LLC · Bargersville, INBuilt 2012 · S/N 172S11179N678RMLaw Roger Jay · Franklin, INBuilt 1961 · S/N 17248390N678SPFreed Bryan S · Norfolk, VABuilt 1999 · S/N 172S8089N678WWFly Cessna LLC · Peoria, AZBuilt 2000 · S/N 172S8678N6790ALaurel 406 Aero · Billings, MTS/N 28890N6793AJones Jeffrey D Trustee · Elida, OHBuilt 1956 · S/N 28893N6794EWalls Jerry L · Hawley, TXS/N 17272067N6794HPs N6794h LLC · Green Bay, WIBuilt 1975 · S/N 17265583N6795AKelley Aviation Services Inc · Halifax, PAFirst renewal noticeBuilt 1956 · S/N 28895N6796AAjer Richard L · Herriman, UTBuilt 1956 · S/N 28896N6796EBlain Kyra · Conroe, TXFirst renewal noticeBuilt 1978 · S/N 17272068N6796HAmelia Reid Aviation LLC · San Jose, CABuilt 1975 · S/N 17265584N6797EJoe Bob Nelson · Chickasha, OKBuilt 1978 · S/N 17272069N6798HWnk Leasing LLC · Lewes, DEBuilt 1975 · S/N 17265586N679DCM & G Aircraft Management LLC · Englewood, COBuilt 2016 · S/N 172S11679N679DLBlink Squirrel Aviation LLC · Cherokee, IABuilt 1970 · S/N 17259138N679DWSunrise Aviation Inc · Ormond Beach, FLBuilt 2000 · S/N 17280940N679EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12754N67CNPrichard Brian E · Caledonia, MIBuilt 1968 · S/N 17257566N67MSAmerican Aviation Inc · Brooksville, FLBuilt 2001 · S/N 172S8993N67RVHopman Richard G · Oxford, MIBuilt 1966 · S/N 17255157N6800APilots You Can Trust LLC · Fayetteville, NCBuilt 1956 · S/N 28900N6800HBlack Industries LLC · Helena, MTS/N 17265587N6800XNew Vision Aviation Inc · Fresno, CABuilt 1960 · S/N 47700N6802AAeromasters Inc · Surgoinsville, TNBuilt 1956 · S/N 28902N6802HAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 1975 · S/N 17265588N6803XDavis Joseph S · Andalusia, ALBuilt 1960 · S/N 47703N6804AObrien Christopher A · Juneau, AKBuilt 1956 · S/N 28904
Back to AD 90-06-03 R1