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.

N4202YAll Sports Aviation LLC · Cocolalla, IDBuilt 1977 · S/N 603-77N4204EKutsenko Tatyana Executrix Personal Representative · Sammamish, WAS/N 11CC-100N4204YCharles Tim W · Caldwell, IDBuilt 1977 · S/N 293-77N4205EJeppesen Brad · Caldwell, IDBuilt 1947 · S/N 7AC-7146N4205YDrobshoff Alex · Livermore, CABuilt 1977 · S/N 1195-77N4207YAnderson John A · Palmer, AKBuilt 1977 · S/N 972-77N4208EToman Michael · Painesville, OHBuilt 1947 · S/N 7AC-7145N4208YScout Towing Company · Omaha, NEBuilt 1977 · S/N 243-77N4209YShilt Jerry C · El Dorado Springs, MOBuilt 1977 · S/N 1197-77N4213YFandrich Edward I · Payson, AZS/N 341-77N4214EAndrew Louis J Jr · Milwaukee, WIS/N 11CC-106N4214YAngran Nate J · Albia, IABuilt 1977 · S/N 1199-77N4215YCg Air LLC · Mason City, IABuilt 1977 · S/N 968-77N4216YTusquittee Flyers Aero Club LLC · Hayesville, NCS/N 345-77N4217ENelson Melvern · Mena, ARBuilt 1947 · S/N 7AC-7149N421LJAaces Flight Operation LLC · Ellisville, MOBuilt 2010 · S/N 1095-2010N4221EJaggers Aviation LLC · Tupelo, MSBuilt 1947 · S/N 7AC-7151N4222EDerendinger Kevin B · Cole Camp, MOBuilt 1947 · S/N 11CC-112N4223EBlue Sky Sport & Tail Wheel Inc · Mary Esther, FLBuilt 1947 · S/N 7AC-7152N4226EButler Jeffrey C · Abilene, TXBuilt 1947 · S/N 11CC-116N42272Langford Taylor C · York, SCS/N 7AC-2004N4231EVick Karl A · Elko, MNS/N 11CC-120N4232EFicklin Robert J · Fairbury, ILBuilt 1947 · S/N 11CC-121N42344Beck Doug · Bloomington, MNBuilt 1945 · S/N 7AC-409N4236ERegistration Pending · Bristol, CTRegistration pendingBuilt 1947 · S/N 7AC-7154N4237EMoffet Donald D · Barney, NDBuilt 1947 · S/N 7BCM-244N4238ELeake Larry W · Crookston, MNBuilt 1947 · S/N 11CC-125N4242EMorrell Samuel C · Lake City, MIBuilt 1947 · S/N 11CC-127N4242GMaritz Paul A · Mercer Island, WABuilt 2000 · S/N 867-2000N4244ANunn Marvin T · Lovell, WYBuilt 1947 · S/N 7BCM-48N4244ETucker Alan K · Taberg, NYBuilt 1947 · S/N 11CC-130N4246EHansen Karl G · Waxahachie, TXBuilt 1947 · S/N 11CC-129N4249EPerron Ted J · White Bear Lake, MNBuilt 1947 · S/N 11CC-133N424ACGilliam Robert L · Clinton, TNBuilt 1999 · S/N 418-99N424SAKcsi Aerial Patrol Inc · Bakersfield, CAS/N 456-2001N4253EPrice James A · Melba, IDBuilt 1947 · S/N 11CC-136N4254EWeigel John C · Natick, MAS/N 7AC7158N4256EPaquette Denis J · Sioux Falls, SDBuilt 1947 · S/N 7BCM-264N4258EManning Richard F Jr · Midway, GABuilt 1947 · S/N 11CC-138N4264ECollum Aviation LLC · Milton, FLBuilt 1947 · S/N 7AC-7161N4270EGrahl Adam D · Eden, WIBuilt 1947 · S/N 11CC-149N4271ESchmidt Anthony D Jr · Jordan, MNBuilt 1947 · S/N 11CC-151N427ACNoyes Shawn R · Hudson Oaks, TXBuilt 2000 · S/N 1299-2000N4280VEichold Bernard H II · Mobile, ALBuilt 1951 · S/N 7AC-460N4281E4281e LLC · Haleiwa, HIBuilt 1947 · S/N 7AC-7169N4282EKuhn Darrell G · Irma, WIBuilt 1947 · S/N 11CC-153N4288EKelley Gavin E · Heath, TXBuilt 1947 · S/N 11CC-158N428ACMckinley Nathan C · New Braunfels, TXBuilt 2000 · S/N 1288-2000N428CAJones Steven L · Winnebago, MNS/N 428N4291ENodorft Aviation LLC · Orlando, FLBuilt 1947 · S/N 11CC-163
Back to AD 2000-25-02 R1