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.

N5259HTrifunovic Stefan · Grosse Pointe Park, MIBuilt 1975 · S/N 17265387N5259RCarnathan Robert J · Newark, CABuilt 1974 · S/N 17263473N525JGFlycarolina LLC · Concord, NCS/N 172RG0178N525NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10817N52602Hutch Aviation Inc · Zavalla, TXBuilt 1980 · S/N 17274562N52606Cirrus Aviation Inc · Sarasota, FLBuilt 2009 · S/N 172S10995N5260DMeyer Kevin · Hooper, NEBuilt 1979 · S/N 17272478N5260KPacific Fleet Aviation LLC · Rochester, NYBuilt 1980 · S/N 17274035N5260RSouthern Aero LLC · Homestead, FLBuilt 1974 · S/N 17263474N5261FTopken William F · Fallon, NVS/N 17253375N5261UBackus Gary Carl · Chesapeake, VABuilt 1980 · S/N 172RG0308N5262HBun Air Corp · Bedford, PABuilt 1975 · S/N 17265388N5262UL&W Aircraft Investment LLC · Homestead, FLBuilt 2002 · S/N 172S9175N5262YLead Turn Aviation LLC · Ogden, UTBuilt 2002 · S/N 172S9176N52635Allard Michael · Penrose, COS/N 17274573N5263QZahn Jason L · Towner, NDBuilt 1965 · S/N 17253380N5264DPironti Bennett D · Long Valley, NJS/N 17272481N5264KRmg Aviation LLC · Newark, DEBuilt 1980 · S/N 17274036N52654Jin Jin Aviation LLC · Anchorage, AKBuilt 1981 · S/N 17274576N5265DFly 172rg LLC · Peoria, AZBuilt 1979 · S/N 17272482N5265ETree Top Flying Service Inc · Clarksville, TNBuilt 1978 · S/N 17271804N5265RMoss Hill Airport Inc · Kinston, NCBuilt 1974 · S/N 17263479N5266DColemanation Investments LLC · Naperville, ILBuilt 1979 · S/N 17272483N5266ENatchez Flight Training LLC · Natchez, MSBuilt 1978 · S/N 17271805N5266KCorsicana Aviation Training Services LLC · Corsicana, TXBuilt 1980 · S/N 17274037N5266UN5266u LLC · Brookfield, ILBuilt 1980 · S/N 172RG0312N52671Carver Aero LLC · Muscatine, IABuilt 1981 · S/N 17274577N52678Land And Sea Aviation Alaska LLC · Anchorage, AKBuilt 2026 · S/N 172S13556N5267EBrudelie Alan C · Lewisville, MNBuilt 1978 · S/N 17271806N5267FColeman Timothy James · Cornwall On Hudson, NYBuilt 1965 · S/N 17253390N5267RCastlegate Corp · Monee, ILFirst renewal noticeBuilt 2002 · S/N 172S9180N5267YCkb Management LLC · Fayetteville, ARBuilt 2002 · S/N 172S9181N52683Cobb John Mark · Fayetteville, TNBuilt 1981 · S/N 17274579N52685Glidewell Aviation Inc · Parkland, FLBuilt 1981 · S/N 17274580N5268FVincennes University · Indianapolis, INBuilt 1965 · S/N 17253391N5268HGrander Aviation LLC · Panama City Beach, FLBuilt 1975 · S/N 17265389N5268JReach For Skies LLC · San Antonio, TXBuilt 1980 · S/N 17273751N5268KSorbi Aviation Inc · El Cajon, CABuilt 1980 · S/N 17274038N5268RJohnson Steven D · Oklahoma City, OKS/N 17263482N5269NHigh Maintenance Inc · San Luis Obispo, CABuilt 2002 · S/N 172S9184N526EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13524N526ERLong Island Aviators LLC · Seaford, NYBuilt 2002 · S/N 172S9110N526LKKenzy 2022 LLC · Castle Rock, COBuilt 2022 · S/N 172S12923N526NDSpartan Education LLC · Tulsa, OKBuilt 2010 · S/N 172S11063N526WRFlorida And Caribbean Flight Training LLC · Punta Gorda, FLS/N 17269371N52700Air Transport Inc DBA · Las Vegas, NVS/N 17274583N52701Cannon Michael A DBA · Blythe, CABuilt 1981 · S/N 17274584N52702Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17274585N5270GLewis University · Romeoville, ILBuilt 2009 · S/N 172S11003N5270HR & D Aircraft Inc · Jamestown, NCBuilt 1975 · S/N 17265390
Back to AD 90-06-03 R1