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.

N266LARaintree Aviation LLC · Mesa, AZBuilt 2012 · S/N 172S11178N266SPTfs Air LLC · Loveland, COBuilt 2003 · S/N 172S9471N2670LOns Bart · Kirkland, WABuilt 1967 · S/N 17255870N2671LNbl Aviation LLC · Woodway, TXBuilt 1967 · S/N 17255871N2671UMetz Thomas H · Mifflintown, PABuilt 1963 · S/N 17250271N2672UBender John Lowell Trustee · N Richland Hills, TXBuilt 1963 · S/N 17250272N2673LBalcom Terry J · Shepherd, MIBuilt 1967 · S/N 17255873N2673UBonin Patrick G · Blossvale, NYBuilt 1963 · S/N 17250273N2674LValley Excavation And Grading Inc · Chatsworth, CABuilt 1967 · S/N 17255874N2675LFoster Jeffrey W · Lexington, NCBuilt 1967 · S/N 17255875N2675UAv Hawk Aviation LLC · Montclair, NJS/N 17250275N2676LCupp Stanley J · Quilcene, WABuilt 1967 · S/N 17255876N2676URobinson Dalton M · Londonberry, OHS/N 17250276N2679LBartley James K · Kent, WABuilt 1967 · S/N 17255879N267FGRidgeline Assets LLC · Wilmington, DES/N 172S12725N267HPFlorida Highway Patrol · Tampa, FLBuilt 2002 · S/N 172S9267N267RAReynolds Darryl G · Wills Point, TXS/N 17261919N2681UOsterhaus Jonathan · Petersburg, TNBuilt 1963 · S/N 17250281N2682LCommonwealth Technical Services Inc · Powhatan, VABuilt 1967 · S/N 17255882N2682UCseh Sandor · New Brunswick, NJBuilt 1963 · S/N 17250282N2684UAnderson Robert David · Brighton, MIBuilt 1963 · S/N 17250284N2686USzalay Jamey R · Princeton, NJBuilt 1963 · S/N 17250286N2688LParsons Joshua A · Hollis Center, MES/N 17255888N2688UGould Martin W · Alba, TXBuilt 1963 · S/N 17250288N268CSInternational Air Services Inc Trustee · Carson City, NVBuilt 2013 · S/N 172S11266N268CTCoast Flight Training And Management Inc · San Diego, CABuilt 2005 · S/N 17281258N268EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13506N268FMRunamuck LLC · New Orleans, LABuilt 2024 · S/N 172S13268N268ZMewmew Investment II LLC · Palo Alto, CABuilt 2023 · S/N 172S12947N2690QSilva Alberto · Titusville, FLBuilt 1970 · S/N 17259104N2690USmith Daryn D · Billings, MTBuilt 1963 · S/N 17250290N2691UHess Garrett J · Fullerton, CABuilt 1963 · S/N 17250291N2693UBolden Myles · Plumas Lake, CABuilt 1963 · S/N 17250293N2695LHindberg Jacob W · Fisher, MNBuilt 1967 · S/N 17255895N2696LPark Rapids Avionics Inc · Park Rapids, MNBuilt 1967 · S/N 17255896N2697UOharra Robert J · Buckley, WAS/N 17250297N2699L98x LLC · Caddo Mills, TXBuilt 1967 · S/N 17255899N2699UHogue Richard L · Dos Palos, CAS/N 17250299N269BJN2893e LLC · Reno, NVS/N 17270380N269CJLarson Martin B · Rapid City, SDBuilt 1970 · S/N 17259512N269DDAircraft Solutions Group LLC · Englewood, COBuilt 2005 · S/N 172S9981N269EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13509N269FGMustang Sally Aviation LLC · Camden, SCBuilt 2008 · S/N 172S10885N269MEGeorge'S Aviation Services · Honolulu, HIBuilt 2000 · S/N 172S8531N269NEOro LLC · Tilden, NES/N 17272505N269RDHumphries Aviation LLC · Maysville, KYS/N 17252737N26AAMustang Sally Aviation LLC · Camden, SCBuilt 2016 · S/N 172S11693N26BFBasco James Millard M · Richlands, NCS/N 28295N26BQAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13219N26CWBarzelatto Brett · Thornton, COS/N 17272496
Back to AD 90-06-03 R1