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.

N82711N82711 LLC · Mesa, AZS/N 7AC-1357N82721Godra Michael A · Oxford, PABuilt 1946 · S/N 7AC1368N82724Trail William H · Reidsville, NCBuilt 1948 · S/N 7AC-1371N82730Scott Tabb E · Clyde, TXBuilt 1946 · S/N 7AC-1377N82733Green Vernon G · Rolla, MOBuilt 1946 · S/N 7AC-1380N82734Shaw Timothy G · Columbus, INBuilt 1946 · S/N 7AC-1381N82739Odom Jack G · Cabot, ARS/N 7AC-1386N82742Sellick Kim L · Kingston, WABuilt 1946 · S/N 7AC-1389N82745Foley Michael W · Galt, CABuilt 1946 · S/N 7AC-1392N82747Hood Timothy G Jr · Morrison, ILBuilt 1946 · S/N 7AC-1394N82752Massey Edward R · Union, MSBuilt 1946 · S/N 7AC-1399N82755Wood J Gillespie · Richfield, NCBuilt 1946 · S/N 7AC-1402N82758Cheal Finley · Eugene, ORBuilt 1946 · S/N 7AC-1405N82759Rock River Flyers · Mount Morris, ILS/N 7AC-1406N8275EHay Charles Kevin · Peachtree City, GAS/N 7AC-1398N82762Buffkin Louis G · Creola, ALBuilt 1946 · S/N 7AC-1409N82764Jo E Rankin · Maryville, MOBuilt 1946 · S/N 7AC-1411N82766Midway Aviation Co · Plant City, FLBuilt 1946 · S/N 7AC-1413N82767Kent Keith M · Ellijay, GABuilt 1946 · S/N 7AC-1414N82768Beasley Charles A · Spencer, VABuilt 1946 · S/N 7AC-1415N82771Doherty Joseph G · Le Sueur, MNBuilt 1946 · S/N 7AC-1418N82773Horst Sheldon L · Columbia, PABuilt 1946 · S/N 7AC-1420N82777Cromwell Marlena A · Napa, CABuilt 1946 · S/N 7AC-1424N82780Zerovich Karl · Cortland, OHBuilt 1946 · S/N 7AC-1427N82781Schmid Ayden J · Lagrangeville, NYBuilt 1946 · S/N 7AC-1428N82787Kaufman Timothy B · Charlotte, NCBuilt 1946 · S/N 7AC-1434N82789Grieser James K · Wauseon, OHBuilt 1946 · S/N 7AC-1436N82796Holt Worthe S Jr · Fishers, INBuilt 1946 · S/N 7AC-1443N82799Sheriff Christopher J · Dubuque, IABuilt 1946 · S/N 7AC-1446N827WTCsu Aviation LLC · Plainfield, INBuilt 1996 · S/N 1222-96N82802Kimbrel Martin E · Oakville, WABuilt 1946 · S/N 7AC-1449N82805Cheatham Paul · La Verne, CABuilt 1946 · S/N 7AC-1452N82809Seven Acee LLC · Alexander City, ALBuilt 1946 · S/N 7AC-1456N82812Gibson Randy L · Clinton, TNBuilt 1946 · S/N 7AC-1459N82816Ficklin Robert L · Fairbury, ILBuilt 1946 · S/N 7AC-1463N82819Fitzgerald Cynthia J · Bedford, NHS/N 7AC-3362N82825Petro Jerry R · Williamsburg, VAS/N 7AC-1474N82826Foran Dennie H · Bainbridge, GABuilt 1946 · S/N 7AC-1478N82830Savage David E · American Falls, IDBuilt 1946 · S/N 7AC-1477N82833Merritt Daniel D · Graham, WABuilt 1946 · S/N 7AC-1483N82834Hopkins Daniel E · Austin, TXBuilt 1946 · S/N 7AC-1484N82840Mcfarland Charles W · Cookson, OKBuilt 1946 · S/N 7AC-1490N82842Murphy Edward W · Troy, NYBuilt 1946 · S/N 7AC-1492N82845Weigel John C · Natick, MAS/N 7AC-1495N82847Rice James L · Mckinney, TXBuilt 1946 · S/N 7AC-1497N82850Combs Joshua E · West Chester, OHBuilt 1946 · S/N 7AC-1500N82856Beebe Eric P · Kinderhook, NYBuilt 1946 · S/N 7AC-1506N82860Tailwheel LLC · Ypsilanti, MIS/N 7AC-1510N82867Bagwell Mark E · Kennesaw, GABuilt 1946 · S/N 7AC-1517N82868Olafsen George F · Greeneville, TNBuilt 1946 · S/N 7AC-1518
Back to AD 2000-25-02 R1