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.

N5948AVerdouw Andrew J · Georgetown, INBuilt 1956 · S/N 28548N5948ETlt Legacy LLC · Fort Worth, TXBuilt 1978 · S/N 17271972N5950AVincent Anthony Jordan · Graham, KYBuilt 1956 · S/N 28550N5951ELlano Alfonso · Tucson, AZS/N 17271974N5951RSouth Seattle Community College · Seattle, WABuilt 1965 · S/N 17253620N5952ARoberts Richard R · Seaman, OHBuilt 1956 · S/N 28552N5954ROtr Enterprises LLC · Broussard, LAS/N 17253623N5955EClover Park Technical College · Tacoma, WABuilt 1978 · S/N 17271975N5956ATimes Of Refreshing World Outreach Ministry Inc · Baton Rouge, LABuilt 1956 · S/N 28556N5956EWalsh James · Hayden, IDS/N 17271976N5957ASwenson Kent A · Kindred, NDBuilt 1956 · S/N 28557N5958AAndreoli Robert J · Alamogordo, NMBuilt 1956 · S/N 28558N595DBStar Magic (Www) Inc · New York, NYBuilt 2005 · S/N 172S9876N595KHarvey Air LLC · Doylestown, PABuilt 1972 · S/N 17260401N595MSClover Park Technical College · Lakewood, WABuilt 2026 · S/N 172S13558N595PZSomid Resources LLC · Choudrant, LABuilt 2022 · S/N 172S12840N595SPSchool Of Missionary Aviation Technology · Ionia, MIBuilt 2000 · S/N 172S8522N595TSArner Michael D · Tolland, CTBuilt 1967 · S/N 17256027N5960ASouthern Aviation Solutions LLC · Sumter, SCS/N 28560N5960RFrame Russell C · Harrison, IDBuilt 1965 · S/N 17253629N5961AMobley Mark A · Wasilla, AKS/N 28561N5961JAtp Aircraft 2 LLC · Wilmington, DEBuilt 2015 · S/N 172S11610N5961RPieper James E · Corpus Christi, TXBuilt 1965 · S/N 17253630N5962AKadlec Paul · Vail, AZBuilt 1956 · S/N 28562N5962RN5962r LLC · Auxvasse, MOBuilt 1965 · S/N 17253631N5964ABeachy Matthew · Russellville, KYBuilt 1956 · S/N 28564N5966AHutchins Charles Norman · Wildomar, CAS/N 28566N5969ANichols Patricia · Varnado, LABuilt 1956 · S/N 28569N5969RFrederick Clint A · Mattoon, ILBuilt 1965 · S/N 17253638N596CSVan Anda Aviation LLC · Apopka, FLBuilt 1997 · S/N 17280050N596FAOcala Aviation Services Inc · Ocala, FLBuilt 2004 · S/N 172S9596N5971ABolton Warren S Jr · Niles, MIBuilt 1956 · S/N 28571N5971RBowers Joshua Shane · Ballston Lake, NYBuilt 1965 · S/N 17253640N5972AWillams Christopher R · Lingleville, TXBuilt 1956 · S/N 28572N5973RGrit Services LLC · Manila, ARS/N 17253642N5975ADuke Robert D · Darrouzett, TXBuilt 1956 · S/N 28575N5975RBates Kristopher M · Zanesville, OHBuilt 1965 · S/N 17253644N5976AN5976a LLC · Marathon, FLS/N 28576N5976EFunkhouser Dennis E · Fredericksburg, VABuilt 1978 · S/N 17271978N5976RMeadows Robert K · Macon, GABuilt 1965 · S/N 17253645N5977RWhitney Nathan B · Falkville, ALS/N 17253646N597DAb Prop Plane II LLC · Metairie, LABuilt 2017 · S/N 172S12068N597DMBrandon Air LLC · Valley Stream, NYBuilt 1976 · S/N 17268041N597SPViolet Sparkle Pearl LLC · Hanover, NHBuilt 2000 · S/N 172S8525N597TXCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13229N5980AFinstad Brandon C · South Weber, UTBuilt 1956 · S/N 28580N5980RPetes LLC · Pompton Plains, NJBuilt 1965 · S/N 17253649N5981RKenney Anthony G · Oviedo, FLBuilt 1965 · S/N 17253650N5983JIlarraza Gilberto C · Sabana Hoyos, PRS/N 17273848N5983MPhilipp Michael W · Thief River Falls, MNS/N 17260945
Back to AD 90-06-03 R1