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.

N57442Whiting Lawrence M · Silverton, ORBuilt 1973 · S/N 506-73N57446Williams Martin · Wasilla, AKBuilt 1973 · S/N 507-73N57447Hicks Richard Ted · Statesville, NCS/N 263-73N57454Ck Leasing Services LLC · Wilmington, DEBuilt 1973 · S/N 90-73N57456Marshall James I · Roosevelt, UTBuilt 1973 · S/N 508-73N57458Flytrek3 LLC · Palmer, AKBuilt 1973 · S/N 509-73N57461Hall Willard · Beaumont, TXBuilt 1973 · S/N 949-73N57467Loper Jonathan D · Dallas, TXBuilt 1973 · S/N 377-73N57468Lease Gregory C · Grand Rapids, MNBuilt 1973 · S/N 514-73N57469Miller Christopher A · Chico, CABuilt 1973 · S/N 951-73N57470Hicks James W · Valparaiso, INBuilt 1973 · S/N 375-73N57472Kutztown Aviation Service Inc · Germansville, PABuilt 1973 · S/N 512-73N57473Duncan Michael E · Auburn, CABuilt 1973 · S/N 378-73N57474Harding William R Jr · Quinlan, TXBuilt 1973 · S/N 950-73N57476Boucher Gregg D · Hinsdale, MTBuilt 1973 · S/N 516-73N57481Bartels Pamela K · Marion, NCBuilt 1973 · S/N 952-73N57487Willis Nelson W · Lebanon, TNS/N 520-73N57488Rocky 80 Inc · Ethridge, MTBuilt 1973 · S/N 521-73N57498Ck Leasing Services LLC · Wilmington, DES/N 525-73N57503Martin William A · Nashville, TNBuilt 1973 · S/N 95-73N57505Archipelago Group Llcc · Alexandria, VAS/N 267-73N57515Peterson Dean · Gothenburg, NEBuilt 1973 · S/N 380-73N57517Du Aircraft Leasing · Green Bay, WIS/N 526-73N57519L & L Flying Inc · Glen Allan, MSS/N 532-73N57522Baker Brad L · Salcha, AKBuilt 1973 · S/N 534-73N575DSGotfredson Allen S · Ten Sleep, WYBuilt 1975 · S/N 885-75N57627Foothill Sport Aviation LLC · Cameron Park, CABuilt 1973 · S/N 986-74N57628Ridder Thomas · Leoti, KSBuilt 1973 · S/N 619-74N57629Hauf Daniel R · Jack, ALBuilt 1973 · S/N 408-74N57634Dye David V Trustee · Wasilla, AKBuilt 1973 · S/N 613-74N57635Robertson Trevor W · Spokane, WABuilt 1973 · S/N 124-74N57640Kramer Alex H · Louisville, KYBuilt 1973 · S/N 283-74N57641Bruch Zweit F · Whitewood, SDBuilt 1973 · S/N 623-74N57645Williams Shelia H · Headland, ALBuilt 1973 · S/N 410-74N57646Turner Steven G · Clearwater, KSBuilt 1973 · S/N 991-74N57649Jagers Ed Dean · Lamar, COBuilt 1973 · S/N 620-74N57654Mclaughlin John R · Moravia, NYBuilt 1973 · S/N 413-74N57655Bekanich Jason · Camden, NCBuilt 1973 · S/N 993-74N57656Haan Arthur G II · Indianapolis, INBuilt 1974 · S/N 622-74N57657Beitel Theodore C · Higden, ARBuilt 1973 · S/N 127-74N57659Progressive Air Inc · Janesville, WIBuilt 1973 · S/N 624-74N57660Parks Dustin M · Murray, KYBuilt 1973 · S/N 414-74N57661Hornbeck Richard L · Bowdoinham, MEBuilt 1973 · S/N 996-74N57662August Aero LLC · Kalispell, MTBuilt 1973 · S/N 625-74N57664Jarosz Jeffrey J · Newton, WIBuilt 1974 · S/N 437-74N57666Hoon David M · Wolf Creek, MTS/N 626-74N57667Flatley Joshua Martin · Alexandria, VABuilt 1973 · S/N 286-74N57669Orwick Louren Chris · Michigan, NDFirst renewal noticeBuilt 1974 · S/N 2-74N57671Bell Nicolette · Wasilla, AKBuilt 1973 · S/N 416-74N57673Beal Alan D · Prosper, TXBuilt 1974 · S/N 129-74
Back to AD 2000-25-02 R1