OpenAirDocs.org
AD 2000-25-02 R1

Registered aircraft · 7,563

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:2000-25-02-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:2000-25-02-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.

N53746Apollo 18 LLC · Tipp City, OHBuilt 1975 · S/N 537-75N53747Tenkey Investments LLC · Tulsa, OKBuilt 1975 · S/N 210-75N53752Vectors West LLC · Coeur D Alene, IDBuilt 1975 · S/N 872-75N53753Erickson David R · West Point, UTS/N 873-75N53754B U International Inc · Pierce, TXBuilt 1975 · S/N 539-75N53758Trailing Edge Aviation LLC · Lancaster, PABuilt 1975 · S/N 540-75N53763Anderas Per R · Green Bay, WIBuilt 1975 · S/N 875-75N53764Push To Talk Aviation LLC · Burr Ridge, ILBuilt 1975 · S/N 1112-75N53769Holcomb Garry · Greenville, TXS/N 1113-75N53772Quale Scott M · New Town, NDBuilt 1975 · S/N 542-75N53773Brock Edwin G · Hawthorne, FLBuilt 1975 · S/N 1114-75N53777Bernabucci Christian J · Mapleton, NDBuilt 1975 · S/N 877-75N53781Hayden Aviation LLC · Rhome, TXBuilt 1975 · S/N 1116-75N53785Fox Business Advisors LLC · Mesa, AZBuilt 1975 · S/N 543-75N53787Jones Carl L Jr · Edmond, OKBuilt 1975 · S/N 183-75N53791Maseman Paul A · Tucson, AZBuilt 1975 · S/N 887-76N537ACMacmillan John Jr · Chevy Chase, MDBuilt 2005 · S/N 999-2005N537JHBuffington Matthew Hill · Highlands Ranch, COBuilt 1975 · S/N 533-75N53800Blue Earth Flying Service LLC · Blue Earth, MNBuilt 1975 · S/N 321-75N53801Stegman Edward L · Oceanside, CABuilt 1975 · S/N 1119-75N53802Mcwhorter S Aaron · Whitesburg, GABuilt 1975 · S/N 880-75N53804Bell Cody R · North Pole, AKBuilt 1975 · S/N 1120-75N53806Quaal Christian M · Sundance, WYFirst renewal noticeBuilt 1975 · S/N 184-75N53815Ag Solutions LLC · Garden City, KSS/N 546-75N53817Rittberger Beef Inc · Hermosa, SDBuilt 1975 · S/N 882-75N53818Prestige Worldwide Aviation LLC · Downers Grove, ILBuilt 1975 · S/N 216-75N53819Seekins Ralph DBA · Fairbanks, AKS/N 201-76N53820Skylane Capital Group LLC · Seattle, WABuilt 1975 · S/N 547-75N53823Ferguson Carrie L · Palo Alto, CABuilt 1975 · S/N 1126-76N53824Law C Scott · Oklahoma City, OKBuilt 1975 · S/N 884-75N53830Rives Taylor J · Buffalo, WYBuilt 1975 · S/N 548-75N53832Kalis Dakota E · Blue Earth, MNBuilt 1975 · S/N 1127-76N53834Morrison Dale C · Eloy, AZS/N 220-75N53836Tailwheel Solutions LLC · Chagrin Falls, OHBuilt 1975 · S/N 1124-75N53837Anderson Gene S · Whitewater, MTBuilt 1975 · S/N 886-75N53838Euroaviation Inc Trustee · KematenBuilt 1975 · S/N 222-76N53840Lee Michael C · Concord, GABuilt 1975 · S/N 323-75N53842Anderson Cody J · Orono, MES/N 1125-75N53844Hughes Chandler · Sanger, CABuilt 1975 · S/N 551-76N53845Sale Reported · Newfolden, MNSale reportedS/N 188-76N53847Driftless Aviation LLC · Burlington, WIBuilt 1975 · S/N 1128-76N53849Dm Aviation LLC · Colorado Springs, COBuilt 1975 · S/N 324-76N53851Wilson Michael D · Wasilla, AKBuilt 1975 · S/N 889-76N53852Cohran Enterprise LLC · Pineville, LABuilt 1975 · S/N 1129-76N53853Schultz Thomas O · Tulare, SDBuilt 1976 · S/N 908-76N53855Messmore Michael H · Toledo, WAS/N 1149-76N53856Craig Guy R · New Castle, INBuilt 1975 · S/N 552-76N53858Sparks James D · Glennallen, AKBuilt 1975 · S/N 891-76N53863Ghilarducci Frank W · Sedalia, COBuilt 1975 · S/N 325-76N53864Jordon Air Inc · Hugoton, KSBuilt 1975 · S/N 553-76
Back to AD 2000-25-02 R1