Skip to content

AD 2000-25-02 R1

Registered aircraft · 7,561

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.

N2510GCollum Aviation LLC · Milton, FLBuilt 1967 · S/N 403 N2510ZCherry Hill Aviation Inc · Freetown, INBuilt 1977 · S/N 256-77 N2511FBradley Cole Mckee · Temple, TXBuilt 1965 · S/N 126 N2512BStikeleather Caro Anne · Arlington, VAS/N 7CCM-98 N2512ZPlane Old Fun LLC · Mckinney, TXBuilt 1977 · S/N 334-77 N2513BKimble Allen J · Plano, TXS/N 7CCM-82 N2513FKeller Jeffrey B · Mount Ulla, NCBuilt 1965 · S/N 129 N2514ZDarnoc LLC - Series 6 · Spicewood, TXBuilt 1977 · S/N 992-77 N2515ZMarker Richard A · Healdsburg, CABuilt 1977 · S/N 347-77 N2516FBourne Cynthia A · Melbourne, FLBuilt 1965 · S/N 7ECA-133 N2518ESankey Ira D · Sheridan, WYFirst renewal noticeBuilt 1946 · S/N 7AC-6101 N2518FWill Larry P · Fort Collins, COBuilt 1966 · S/N 136 N2518GVintage Aviation Inc · Garden City, NYBuilt 1967 · S/N 166 N2518ZAircraft & Aviation Professionals LLC · Coldwater, MIBuilt 1977 · S/N 616-77 N2519ZWatson Bobby M · Hoxie, ARBuilt 1977 · S/N 993-77 N251CLLott Alan B · Columbia, SCBuilt 1946 · S/N 7AC-4693 N251DMBandt Johnathan Paul · South Milwaukee, WIBuilt 2000 · S/N 1284-99 N251JBVan Horne Robert E · Centralia, ILBuilt 1965 · S/N 21 N251MANorris Suzanne W · Howe, IDBuilt 2003 · S/N 1346-2003 N251WCThyssen Patrick L · Conroe, TXBuilt 2000 · S/N 424-2000 N2520EBerke Jarett · Hanover, NHBuilt 1946 · S/N 7AC-6102 N2523EWeimer Adam Jr · Fort Morgan, COBuilt 1946 · S/N 7AC-6105 N2523FCavin Dale L · Marianna, FLBuilt 1965 · S/N 143 N2523ZBchr Aviation LLC · Boerne, TXBuilt 1977 · S/N 337-77 N2524FWilkins Shelley A · Claremore, OKBuilt 1966 · S/N 72 N2524ZEgan Brian M · Saint Charles, ILBuilt 1977 · S/N 338-77 N2525ERegistration Pending · Duluth, MNRegistration pendingBuilt 1946 · S/N 7AC-1566 N2525FGarbani Jacob R · Caldwell, IDBuilt 1966 · S/N 419 N2525SJbird Aviation LLC · Elizabeth City, NCBuilt 2025 · S/N 1225-2025 N2526EGrotewohl Chris · Roeland Park, KSBuilt 1946 · S/N 7AC-6108 N2527BRegistration Pending · Wasilla, AKRegistration pendingS/N 48-507 N2527FHightower Marc S · Sevierville, TNBuilt 1965 · S/N 147 N2529ESpofford Roger L · Luck, WIBuilt 1946 · S/N 7AC-6111 N2529FEvanson Scot A · Monroe, TNBuilt 1965 · S/N 149 N2531FFishwick Steve K · Hamilton, OHBuilt 1966 · S/N 22 N2532FQuinn Michael A · Ruby, AKBuilt 1965 · S/N 154 N2533FMacdonald Craig R · Sonoma, CABuilt 1965 · S/N 155 N2534FCentral Virginia Aviation Inc · North Dinwiddie, VAS/N 7ECA-156 N2535FBryan Michael R · Brownfield, TXBuilt 1965 · S/N 7GCAA-33 N2536ZLemanski Thomas A · Port Townsend, WAS/N 1250-78 N2538FHill Ag-Air LLC · Bancroft, IDBuilt 1965 · S/N 160 N2538GFerrell Herman H · Oak Grove, LABuilt 1967 · S/N 411 N2538ZSnell Marion Lea · Ackerly, TXBuilt 1977 · S/N 342-77 N253CAJtv Enterprises LLC · Painesville, OHBuilt 1977 · S/N 339-77 N2540EBaker Steven D · Wonewoc, WIS/N 7AC-6122 N2540FMcguires Flying Service LLC · Obion, TNBuilt 1965 · S/N 96 N2541EOkeefe William G · Grand Forks, NDBuilt 1946 · S/N 7AC-6123 N2542ZGreenway Jonathan J · Frederick, MDBuilt 1977 · S/N 344-77 N2543FRowley Harold · Greensboro, ALBuilt 1965 · S/N 165 N2543ZSchindler Jason D · Oneill, NES/N 345-77

Back to AD 2000-25-02 R1