Skip to content

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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N9784ERuniyon Greg A · Bainbridge, INBuilt 1946 · S/N 11AC-1432 N9785EGreener Richard M · Mohnton, PABuilt 1946 · S/N 11AC-1434 N9789EGolonka Joseph P · Beekwourth, CARegistration revokedBuilt 1946 · S/N 49805437 N978BCEvans Jennifer · Bozeman, MTBuilt 2025 · S/N 646-2025 N9790ELerch Mark R · San Angelo, TXBuilt 1946 · S/N 11AC-1433 N9791EHutson Norman · Olympia, WABuilt 1946 · S/N 11AC-1438 N9795EOklahoma Flight Academy LLC · Owasso, OKBuilt 1946 · S/N 11AC-1439 N9796ESipe William J · Manchester, TNBuilt 1946 · S/N 11AC-1390 N9797EMac Coy Clifford J · Line Lexington, PABuilt 1946 · S/N 11AC-1440 N979LWLapp Daniel · Lincoln, NHBuilt 2002 · S/N 468-2002 N97ACReber Tim · Terrace Park, OHBuilt 1993 · S/N 706-93 N97BCGuy George Hopkins III · Saratoga, CABuilt 2008 · S/N 510-2008 N97CVHigginson Robert W · Minooka, ILBuilt 2022 · S/N 1482-2022 N97FZRegistered aircraftBuilt 1997 · S/N 79697 N97KMSale Reported · Crystal, MNSale reportedBuilt 1960 · S/N 422 N97KRMcmillan James A · New Richmond, WIS/N 7AC6097 N97PBlack River Construction Services LLC · Black River Falls, WIBuilt 2001 · S/N 881-2001 N9800EWord Of Truth Inc · Madisonville, TXS/N 11AC1450 N9803YHubbard Nathan · Butte, MTS/N 38 N9804ELorentzen John R · Port Alsworth, AKS/N 11AC-1455 N9804YUnderwood Robert D · Randolph, NYS/N 7JC-15 N9805YDavis Richard · Reno, NVBuilt 1960 · S/N 7FC-399 N9808EEngler Alan W · Bad Axe, MIS/N 11AC-1456 N9809EVetterkind Jack O · New Auburn, WIBuilt 1946 · S/N 11AC-1457 N980FFairchild Argus LLC · Evergreen, COBuilt 1946 · S/N 7AC-1142 N980JGAir-One Aviation Inc · Searcy, ARFirst renewal noticeBuilt 1978 · S/N 374-79 N9810YArmstrong Bruce · Port Orchard, WABuilt 1960 · S/N 7GCB-47 N9811EBarnes Glen R · Lone Oak, TXBuilt 1946 · S/N 11AC-1459 N9813YBlanshan Jay Victor · Alexandria, MNBuilt 1960 · S/N 7EC-735 N9814EMuir David W Jr · Lake Stevens, WABuilt 1946 · S/N 11AC-1464 N9816YJones Stephen C · Wadsworth, ILBuilt 1949 · S/N 7FC-400 N9817YMurray Luke C · Gregory, SDBuilt 1960 · S/N 7FC-401 N9818EWhite Andrew R · Dubois, WYS/N 11AC-1468 N9818YRiseaero LLC · Hartsville, SCBuilt 1960 · S/N 7HC-30 N981CMClaypool James W · Hunts Point, WABuilt 1998 · S/N 1247-98 N981DCMerten Aviation Services LLC · Holtville, CAS/N 1085-2009 N9820ERoth Sebastian A · Pacoima, CABuilt 1946 · S/N 11AC-1469 N9822YMontana Aviation Tryst LLC · Kalispell, MTBuilt 1961 · S/N 7GCB-57 N9823YCentral Air Parts Inc · Staunton, ILS/N 7JC-17 N9824YSanzaro Aero LLC · Bunnell, FLS/N 7JC18 N9825ECox Norman E · Arlington, ORBuilt 1946 · S/N 11AC-1478 N9827YRegistration Pending · Sweet Home, ORRegistration pending, pending cancellationBuilt 1960 · S/N 50 N982GCollester Rodney D · Danville, INBuilt 1967 · S/N 7ECA-321 N9830EGollobit Matt W · Pierce, NEBuilt 1946 · S/N 11AC-1485 N9831EMatthews Raymond H Jr · Rhoadesville, VABuilt 1946 · S/N 11AC-1480 N9832ERegistration Pending · Bozeman, MTRegistration pending, pending cancellationBuilt 1946 · S/N 11AC-1475 N9833EMcgarr John P · Ruskin, FLS/N 11AC-1484 N9835EHarrington Mark A · West Milford, NJBuilt 1946 · S/N 11AC-1490 N9836EWilson Sean K · Hernando, FLBuilt 1946 · S/N 11AC-1491 N9836YHaughee Jared · Warsaw, INBuilt 1960 · S/N 7EC-738

Back to AD 2000-25-02 R1