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.

N3427EBrezina Chad M · Whitewright, TXBuilt 1947 · S/N 11AC-1740N342HTrautman Michael · Hamilton, MTBuilt 1998 · S/N 1245-98N3430EGehle Roger · Ferndale, MIBuilt 1947 · S/N 11AC-1743N3432EGeurin Terry A · Nine Mile Falls, WABuilt 1947 · S/N 11AC1744N3433PBolgar Mark S · Ewing, NJBuilt 1999 · S/N 420-99N3434EJonas Joseph A · Oshkosh, WIS/N 11AC-1746N3439ELasater Myron G · Watertown, TNBuilt 1947 · S/N 7AC-6838N343ACRegistration Pending · Campbellsburg, KYRegistration pendingBuilt 1999 · S/N 404-99N343RSChamp Aviation LLC · Lake Saint Louis, MOBuilt 1969 · S/N 207-70N3446EHyink Gretchen G · Grand Rapids, MNBuilt 1947 · S/N 7AC-6839N3447ERegistration Pending · Hartford, MIRegistration pending, pending cancellationBuilt 1947 · S/N 7AC-6842N3449EFox Richard L · Gettysburg, PABuilt 1947 · S/N 11AC-1755N344JMMulvania Rodney A · Linn, MOS/N 7AC2182N3450ECochran Linda C · Florence, ALS/N 11AC-1756N3452EYoung James F · Clyde, NYBuilt 1947 · S/N 11AC-1758N3456EHartley Leslie C · Uniontown, WABuilt 1947 · S/N 7AC-6848N345ASDwyer Aaron B · San Jose, CAS/N 592-80N345FDGolden Age Air Museum · Bethel, PABuilt 1975 · S/N 820-75N345RADavis Scott · Morse, TXBuilt 2002 · S/N 900-2002N3461EYoung Barry N · Berrien Springs, MIBuilt 1947 · S/N 11AC-1762N3464DHenricks Aero LLC · Eatonville, WABuilt 1969 · S/N 168N3465EOleary John M · Fresno, CABuilt 1947 · S/N 7AC-6852N3469EJohnson Ray L · Marion, INBuilt 1947 · S/N 11AC-1764N346ACCutler Jay L · Canton, OHBuilt 1999 · S/N 421-99N3471EGilmer Rickey W · Cropwell, ALS/N 11AC-1765N3474EAgaliotis Paul · San Martin, CABuilt 1947 · S/N 7AC6856N3478EElston Vivian E · Tempe, AZS/N 11AC-1767N3479EWhite Bill E · Estacada, ORS/N 7AC-6861N347ACHarkal Enterprises · Des Moines, IABuilt 1998 · S/N 1371-98N347MABent David Thomas · Port Saint Lucie, FLS/N 897-2002N3481ESokolowski Diane M · Clear Lake, IABuilt 1947 · S/N 7AC-6862N3482EBruner Kevin G · Vandalia, OHBuilt 1947 · S/N 7AC-6863N3485EHuber Greg A · Medina, OHBuilt 1947 · S/N 7AC-6867N3487EClassic Aviation LLC · South Saint Paul, MNBuilt 1947 · S/N 7AC-6868N348LADirks Brandon D · Ludell, KSS/N 69-146N348MAWilson Ralph W Trustee · Mentor, OHBuilt 2002 · S/N 1337-2002N3490ELemieux Robert W · Union, MIBuilt 1947 · S/N 11AC-1772N3496EDowdy John H · Union, WVBuilt 1947 · S/N 11AC-1774N3499ERegistration Pending · Cadott, WIRegistration pendingS/N 7AC-6875N349ACFrets Glynn · Gainesville, GABuilt 2006 · S/N 1001-2006N349BCJasper Dirt LLC · Bluffton, SCS/N 1184-2020N349SALong Richard J · San Ramon, CABuilt 2006 · S/N 508-2006N34DNThomas Daniel Craig · Shady Shores, TXBuilt 2005 · S/N 498-2005N34ZZRiggs Donald L · Asbury, NJBuilt 2007 · S/N 1428-2007N3504ETomson Layton L · Ripon, CAS/N 7AC-6877N3505ESkala Donald · Adah, PABuilt 1947 · S/N 11AC-1779N3506EGeldermann Timothy J · Sussex, WIBuilt 1947 · S/N 7AC-6878N3507EScheler Thomas · Independence, ORBuilt 1947 · S/N 11AC-1780N3509ERay Albert B · Prosser, WABuilt 1947 · S/N 11AC-1781N3510EAg Care Inc · Apopka, FLS/N 7AC-6880
Back to AD 2000-25-02 R1