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.

N83173Fenwick Scott Andrew · Kill Devil Hills, NCBuilt 1946 · S/N 7AC-1835N83174Lepanto Crop Service Inc · Lepanto, ARBuilt 1946 · S/N 7AC-1836N83175Honaker Shawn · Sellersburg, INBuilt 1946 · S/N 7AC-1834N8317VLynch Gerald C · Collinsville, OKBuilt 1966 · S/N 84N83185Ruhl Timothy E · Magnolia, TXBuilt 1946 · S/N 7AC-1846N83189Campbell Charles Melvin · Dallas, NCBuilt 1946 · S/N 7AC-1850N8318VVetter Brent E · Helena, MTBuilt 1966 · S/N 46N83191Dorschner Douglas H · White Bear Lake, MNBuilt 1946 · S/N 7AC-1852N83192Miller William Alan · Williamson, GABuilt 1946 · S/N 7AC-1853N83195Howe Adam J · Shaftsbury, VTBuilt 1946 · S/N 7AC-1856N83199Andrews Willard R · Windham, MES/N 7AC-1860N831AC831ac Aero LLC · Ogden Dunes, INBuilt 2000 · S/N 868-2000N831LBWedekemper Steven E · Brighton, MIBuilt 2007 · S/N 515-2007N831RHHanson Paul D · Evansville, INBuilt 1997 · S/N 789-97N83200Rbj Ranchwest LLC · Elroy, WIS/N 7AC-1861N83201Mcbroom Ray E · Conroe, TXBuilt 1946 · S/N 7AC-1862N83204Grimes Kenneth · Charlotte, NCS/N 7AC-1865N8320VThurman Randall N · Mcminnville, ORBuilt 1966 · S/N 399N83215Smiley Neil G · Clover, VABuilt 1946 · S/N 7AC-1876N83216Lewis Peter D · Starksboro, VTBuilt 1946 · S/N 7AC-1877N83217Wtflying Club LLC · Hanover, PABuilt 1946 · S/N 7AC-1878N83219Dawes Thomas R · Bemus Point, NYBuilt 1946 · S/N 7AC-1880N83226High Plains Aviation LLC · Caro, MIBuilt 1946 · S/N 7AC-1887N83227Klosterman Aviation LLC · Celina, OHS/N 7AC-1889N83228Weiss Elliott · Fresno, TXBuilt 1946 · S/N 7AC-1888N8322V11 Point Aviation LLC · Alton, MOBuilt 1966 · S/N 65N83233Hutchings Mathew J · Mukilteo, WABuilt 1946 · S/N 7AC-1897N83234Mattson Douglas R · Ironwood, MIBuilt 1946 · S/N 7AC-1898N83239Vaughan Glenn M · Beavercreek, OHBuilt 1946 · S/N 7AC-1904N8323VToczek Keith E · Yankton, SDS/N 55N83241Kay Michael A · Peru, INBuilt 1946 · S/N 7AC-1903N83244Howe Mark E · Lake Stevens, WABuilt 1946 · S/N 7AC-1906N83247Owens Russell D · Lake Forest, CAS/N 7AC-1911N83248Search And Rescue Inc · Swatara, MNBuilt 1946 · S/N 7AC-1914N83249Trieber Steven M · Casa Grande, AZBuilt 1946 · S/N 7AC-1912N83250Bradley James M DBA · Fort White, FLBuilt 1946 · S/N 7AC-1913N83251Wilkerson Mark A · Madison, INS/N 7AC1915N83254Boyle Fred W Sr · Cape May, NJBuilt 1946 · S/N 7AC-1918N83258Smith Jeffery D · Martinsville, INBuilt 1946 · S/N 7AC-1922N83261Maki Fred E · Baltimore, OHBuilt 1946 · S/N 7AC-1925N83264Johnston Daniel T · Cambridge, OHBuilt 1946 · S/N 7AC-1928N83267Wright Robert A · Raeford, NCBuilt 1946 · S/N 7AC1931N83276Cook Timothy L · Oklahoma City, OKBuilt 1946 · S/N 7AC-1940N83277Bessett Daniel · Lowell, ORBuilt 1946 · S/N 7AC-1941N83279Brinkerhoff Arthur J · Granbury, TXS/N 7AC1943N83280Lienke Kevin E · Beaver Dam, WIBuilt 1946 · S/N 7AC-1947N83282Orton Edson · Memphis, MORegistration revokedBuilt 1946 · S/N 7AC1949N83289Mcnicoll Steven P · Depere, WIBuilt 1946 · S/N 7AC-1956N83291Rh Resources LLC · Baker, FLBuilt 1946 · S/N 7AC-1959N83293Weatherford Dennis W · West Plains, MOBuilt 1946 · S/N 7AC-1960
Back to AD 2000-25-02 R1