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.

N5083XFlytails LLC · Pace, MSFirst renewal noticeBuilt 1968 · S/N 155N5085XAzzalin Giorgio · Jacksonville, FLS/N 158N5086XJacono Bruce L · Ramona, CABuilt 1969 · S/N 159N5087XRichardson Ethan Mack · Mount Pleasant, SCBuilt 1969 · S/N 160N5088XAmerican Aviation II LLC · Peyton, COS/N 659N5089XYarger Pete A · Hamilton, INBuilt 1969 · S/N 654N508TBlackburn D S · Yukon, OKBuilt 1968 · S/N 611N5090XOwen Suzanne L · Eagle Point, ORBuilt 1969 · S/N 655N5091XMorois Jake D · Green Bay, WIBuilt 1969 · S/N 656N5092XCurcio Joseph A Jr · Granite Bay, CAS/N 657N5096XKanooth Michael L · Washougal, WABuilt 1969 · S/N 142N5098XFontenot Reginald J · Church Point, LABuilt 1969 · S/N 162N5099XBailey Carlton D · Huntington, WVS/N 163N50ACRegistered aircraftBuilt 1994 · S/N 1200-94N50CLLopez Johnny · Henderson, NVBuilt 1976 · S/N 261-76N50DTHarrell Ag Aviation LLC · Oak Grove, LABuilt 1975 · S/N 167-75N50LRHester Truck Sales Inc · Bladenboro, NCBuilt 1995 · S/N 749-95N50PGDrawe Richard · Progreso, TXBuilt 1994 · S/N 109575N50XDBest-Devereux Igor · Salt Lake City, UTBuilt 2015 · S/N 1161-2015N50XTN50xt LLC · San Lorenzo, CABuilt 2014 · S/N 1150-2014N50YYJambon Pierre · Port Orange, FLBuilt 2008 · S/N 1083-2009N5101XWilliams Charles Edward · Scottsdale, AZBuilt 1969 · S/N 164N5102TPettis Aviation LLC · Atlantic, IABuilt 1966 · S/N 72N5103TReace Enterprises LLC · Woodbury, MNBuilt 1966 · S/N 441N5103XPlane And Simple LLC · Lakewood, COBuilt 1969 · S/N 166N5104TConsolidated Aviation Services LLC · Seymour, TNBuilt 1966 · S/N 496N5105TRider Charles A · Kokomo, INBuilt 1966 · S/N 502N5105XManairco Inc · Wooster, OHBuilt 1969 · S/N 150N5109XHarkema James P · Troy, OHBuilt 1969 · S/N 663N510LSRegistration Pending · Nashville, TNRegistration pendingBuilt 2002 · S/N 899-2002N510RJSpring Mountain Aviation LLC · San Francisco, CAS/N 1310-2001N5110CWhitcraft Elliot D · New Haven, MOBuilt 1947 · S/N 11CC-62N5110XT & M Aerial Spraying · Garland, NCBuilt 1969 · S/N 192N5111XJeter Michael C · Jacksboro, TXBuilt 1969 · S/N 664N5112TStevens Richard N · Venice Center, NYBuilt 1966 · S/N 534N5113TSchaffner David A · Wray, COBuilt 1966 · S/N 516N5113XHemstock Ronn · Seward, AKBuilt 1969 · S/N 666N5114THarlan Robert J · Kaycee, WYS/N 71N5115TTurkey Creek Aviation And Helicopter Service LLC · Uvalde, TXBuilt 1966 · S/N 137N5115XArbaczauskas Stanislaus · Daphne, ALBuilt 1969 · S/N 167N5119TAmelia Reid Aviation LLC · San Jose, CABuilt 1966 · S/N 200N511JHRiester Bernard J Jr · Auburn, NYBuilt 1974 · S/N 652-74N5120TPrince Ronald D · Beach City, OHBuilt 1966 · S/N 479N5121TBourn Rachael · Magee, MSBuilt 1966 · S/N 307N5123TSlaughter Patricia C · Saranac, MIBuilt 1966 · S/N 122N5124TAnderson Bryan C · Arlington, TNBuilt 1967 · S/N 23N5126TBelle Fourche Flight Center LLC · Belle Fourche, SDS/N 547N5129XSmall Aviation No 2 LLC · Villa Rica, GABuilt 1969 · S/N 171N512ACBuck James Kyle III · Oak Ridge, NCBuilt 1999 · S/N 1281-99N512PGGrassroots Flying LLC · Bellevue, NEBuilt 1946 · S/N 7AC-2446
Back to AD 2000-25-02 R1