OpenAirDocs.org
AD 2000-25-02 R1

Registered aircraft · 7,560

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.

N189BCross X Country LLC · Great Falls, VABuilt 1998 · S/N 1246-98N189BCEph LLC · Eagle, IDS/N 470-2005N189PCN189pc LLC · Heber City, UTBuilt 2005 · S/N 1006-2005N189RANiles Bruce C · Oneida, TNBuilt 2003 · S/N 1348-2003N18DTKit Air LLC · Waconia, MNS/N 431-99N18ENOdonnell Daniel V · Dover, DEBuilt 1974 · S/N 477-74N18HDDifilippo Dennis · Hico, WVBuilt 1999 · S/N 846-99N18NCJohnson Thomas G · New Port Richey, FLBuilt 2003 · S/N 938-2003N18XMUfer John M · Truman, MNBuilt 1973 · S/N 621-74N1901EHarbert Gary J II · Newville, ALBuilt 1946 · S/N 7AC-5464N1904ETelkamp Gary O · Rapid City, SDBuilt 1946 · S/N 7AC-5471N1907EAircraft Investment Co Inc · Casselton, NDBuilt 1946 · S/N 7AC-5474N1908EDockter Larry L · Medina, NDBuilt 1946 · S/N 7AC-5475N190JTravel Services LLC · Metropolis, ILBuilt 2014 · S/N 1142-2014N1910EDenning Michael Andrew · Brewer, MES/N 7AC-5477N1912EMadden Robert T · Kennesaw, GABuilt 1946 · S/N 7AC-5479N1919EPoklar Norman A · Mount Orab, OHBuilt 1957 · S/N 7AC-5486N191ACLoewen Jason Scott · Wenatchee, WABuilt 1993 · S/N 711-93N191DMOlson Tim O · Saint Onge, SDBuilt 1999 · S/N 426-99N191DPNotre Amour LLC · Cypress, TXS/N 7EC335N191PCBad Attitude LLC · Lisbon, OHBuilt 2002 · S/N 896-2002N191RAKellander Thomas N · Fairmont, MNBuilt 2007 · S/N 511-2007N1921EWestgate & Beyond #15 LLC · Okeechobee, FLBuilt 1946 · S/N 7AC-5489N1923RUnd Aerospace Foundation · Grand Forks, NDBuilt 2024 · S/N 1217-2024N1924EYockim Nick W · Northville, SDBuilt 1946 · S/N 7AC-5491N1925EKnutson Daniel T · Lodi, WIBuilt 1946 · S/N 7AC-5492N1926GJaju Aviation Inc · Abilene, TXBuilt 1974 · S/N 1026-74N1928EWadsworth Tom R · Roswell, NMBuilt 1946 · S/N 7AC-5496N192ACByrd Ronald D · Farwell, TXBuilt 1994 · S/N 1203-95N192BAHarkrader Aviation LLC · Louisa, VABuilt 1974 · S/N 459-74N192CAVines Allen E Jr · Hoover, ALBuilt 2007 · S/N 1048-2007N192JHHogue James B · Spencer, TNBuilt 1992 · S/N 669-92N192MAMorgan Nigel · Asheville, NCBuilt 2014 · S/N 1137-2014N1932EBorland Keith P · Lone Jack, MOBuilt 1946 · S/N 7AC-5499N1933ERegistration Pending · North Brunswick, NJRegistration pendingBuilt 1946 · S/N 7AC-5500N1936EWaldmiller Ellen J · Kerrville, TXBuilt 1946 · S/N 7AC-5503N1937EHigginson Robert C · Ben Lomond, CABuilt 1946 · S/N 7AC-5504N1938EMcfarlane Bradley J · Turlock, CABuilt 1946 · S/N 7AC-5505N1939EDurning Jason R · Edmond, OKBuilt 1946 · S/N 7AC-5506N193ACStearman Aviation Inc · Crawford, COBuilt 1993 · S/N 365-93N193GFFlattum Steven · Hampshire, ILBuilt 2006 · S/N 477-2006N1942EBoyd Charley W · Mena, ARBuilt 1946 · S/N 7AC-5508N1943EWeck Geoffrey E · Woodstock, ILBuilt 1946 · S/N 7AC-5510N1946EBusse Cody C · Pageland, SCBuilt 1946 · S/N 7AC-5513N1946ZMarchand Bruce D · Benedict, NDBuilt 1945 · S/N 7AC29N1948EHoffman Drew A · Churubusco, INBuilt 1946 · S/N 7AC-5515N194AMFields Douglas P Jr · Saranac Lake, NYBuilt 1994 · S/N 729-94N194BCAircraft Investments LLC · Ketchum, IDBuilt 2006 · S/N 489-2006N1950DHorney Paul · Russellville, ARBuilt 2020 · S/N 1476-2020N1950EHess Michael D · Wasilla, AKBuilt 1946 · S/N 7AC-5517
Back to AD 2000-25-02 R1