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.

N5734AEisenbrey Glen T · Greenbank, WABuilt 1956 · S/N 28334N5734RZ&H Aviation · Portage, MIBuilt 1965 · S/N 17253403N5735RDavis Richard B · Reno, NVFirst renewal noticeBuilt 1965 · S/N 17253404N5736TSparks Fly LLC · Mount Gilead, OHS/N 17251636N5737RRegistration Pending · Chatham, NYRegistration pendingBuilt 1965 · S/N 17253406N5738RKury Ernest A · Centerville, IABuilt 1965 · S/N 17253407N5739ADaystar Ltd · Ellsworth, KSS/N 28339N573NDAir Shares LLC · Casper, WYBuilt 2009 · S/N 172S10941N5741RJungman Jensen David A · Adel, IAS/N 17253410N5742ADirt Devil Aviation LLC · Bowdon Junction, GAS/N 28342N5742TSkyhawkfive LLC · Claremont, NHS/N 17251642N5743TRay Aviation LLC · Burkett, TXBuilt 1964 · S/N 17251643N5744RBrown Dallin N · Scipio, UTS/N 17253413N5744TMorris Charles E · Ft Worth, TXBuilt 1964 · S/N 17251644N5746AManier Byron K · Houston, MOBuilt 1956 · S/N 28346N5746RKrawietz William L · Bulverde, TXBuilt 1965 · S/N 17253415N5746TWolfe John E · Bay Point, CABuilt 1964 · S/N 17251646N5747RLehmer Jereme D · Oxford, NYBuilt 1965 · S/N 17253416N5747TMontgomery Robert L · Kingman, AZBuilt 1964 · S/N 17251647N5748AGaines Matthew M · Plattsburg, MOBuilt 1956 · S/N 28348N5748EInternational Air Services Inc Trustee · Carson City, NVS/N 17271930N5748RStanley David W · Burleson, TXBuilt 1965 · S/N 17253417N5748TKelly Walter T · Winona, MNBuilt 1964 · S/N 17251648N5749AScobey Robert P · Weiser, IDBuilt 1956 · S/N 28349N5749RMerrill Robert · Plymouth, MABuilt 1965 · S/N 17253418N5749TEast Fork Aviation LLC · Brandon, MSBuilt 1964 · S/N 17251649N574BWBridge State University · Bridgewater, MABuilt 2000 · S/N 17280948N574DEMuggsys Aviation Services LLC · Crittenden, KYBuilt 1974 · S/N 172-62959N574NDSunrise Aviation Inc · Ormond Beach, FLBuilt 2009 · S/N 172S10943N5750RPeters Tricia S · Columbia City, INBuilt 1965 · S/N 17253419N5751EFlight Tech Inc · Arlington, WAS/N 17271931N5751RKummer Brian · Port Orange, FLBuilt 1965 · S/N 17253420N5751TGordon Robert A · North Pole, AKS/N 17251651N5752TStrahan Gary · Beaumont, TXBuilt 1964 · S/N 17251652N5754ECox Charles C · Hood River, ORBuilt 1978 · S/N 17271934N5755ABlue Sky Flyers Inc · Joplin, MOBuilt 1956 · S/N 28355N5755REshbaugh Melvin L · Topeka, KSBuilt 1965 · S/N 17253424N5755TD2 Government Solutions LLC · New Bern, NCBuilt 1964 · S/N 17251655N5756AKunz Isaac A · Texarkana, TXBuilt 1956 · S/N 28356N5756RCm3 LLC · North Las Vegas, NVS/N 17253425N5757EFlex Air Inc · San Diego, CABuilt 1978 · S/N 17271935N5757TFive Seven Tango Inc · Fitchburg, WIBuilt 1964 · S/N 17251657N5758JBatchelder Wesley · Palacios, TXBuilt 1980 · S/N 17273833N5759AFlying K & Associates Inc · Hawthorne, FLBuilt 1956 · S/N 28359N5759RP & R Aviation LLC · Edenton, NCS/N 17253428N575NDAir Shares LLC · Casper, WYBuilt 2009 · S/N 172S10954N575SPCharlie Leasing LLC · Green Bay, WIBuilt 2000 · S/N 172S8504N575TDDahl Russell · Nashua, MTBuilt 1976 · S/N 17268034N575YSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2004 · S/N 172S9656N5763EVilla Rafael O · Miami, FLBuilt 1978 · S/N 17271936
Back to AD 90-06-03 R1