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.

N11GFCompton Robert · Groveland, CABuilt 1974 · S/N 668-74N11JWWhite Blaine S · Castlewood, VABuilt 1998 · S/N 1242-98N11MFCroom Aviation LLC · Port Saint Joe, FLBuilt 1972 · S/N 9-72N11XXOconnell John · Custer, SDS/N 245-72N1200ELockner Peter Phelps · Batavia, NYBuilt 1946 · S/N 7AC-4757N1202EPinsky Heather G · Hurlburt Field, FLS/N 7AC4759N1205ERodorigo Mark W · Virginia, MNBuilt 1946 · S/N 7AC-4762N1206EStrassburg Wayne W · Galena, AKS/N 990-77N1208EMorgan Carl D · Wheeling, MOBuilt 1946 · S/N 7AC-4765N1209EKaraty Joseph · Bates City, MOBuilt 1946 · S/N 7AC-4766N120CADodson Patrick W · Creswell, ORBuilt 2007 · S/N 1012-2007N120SGMccall Melinda · Decatur, ALS/N 1006-2006N1213EWilcox Ralph G · Owensboro, KYBuilt 1946 · S/N 4771N1214EMurray Craig P · Hagaman, NYBuilt 1946 · S/N 7AC-4772N1215EConrad Kristen A · Plain City, OHBuilt 1946 · S/N 7AC-4773N1216EFrancisco Doug R · Pensacola, FLBuilt 1946 · S/N 7AC-4776N1217EJohnston Jason · Chugiak, AKS/N 255-77N1218EShibakov Alexander Y · Gainesboro, TNBuilt 1977 · S/N 324-77N1219EPlyler Aviation Lp · Sherman, TXBuilt 1946 · S/N 7AC-4777N121SGTaliaferro Leigh · Abilene, TXBuilt 2006 · S/N 1036-2007N12202Hudson Kent O · Anchorage, AKBuilt 1972 · S/N 339-72N12205Wilson Seth J · Glennallen, AKBuilt 1972 · S/N 48-72N12206Hth LLC · Merigold, MSBuilt 1972 · S/N 299-72N12207Faris Isaac · Swartz Creek, MIBuilt 1972 · S/N 34272N12208Shepard John A · Thornville, OHBuilt 1972 · S/N 300-72N1221EKirsipuu Paul W · Voluntown, CTBuilt 1946 · S/N 7AC-4779N1222EMorssink Peter J · Bel Air, MDBuilt 1946 · S/N 7AC-4780N1223EBatzer Chad M · Pewaukee, WIBuilt 1977 · S/N 325-77N1225WWaak Pamela J · Cleveland, WIBuilt 1998 · S/N 812-98N1226EPotock John M · South Riding, VABuilt 1946 · S/N 7AC-4784N1227EMccleary Timothy A · Navarre, OHBuilt 1946 · S/N 7AC-4785N1229EOriginal Design Ministries · Eatonville, WABuilt 1946 · S/N 7AC-4787N122HSafeline Aviation LLC · Apache Junction, AZBuilt 1999 · S/N 1274-99N122JDGrasshopper Aviation LLC · Hockley, TXBuilt 2000 · S/N 1301-2000N1230MGoos Farms Inc · Silver City, IABuilt 2002 · S/N 1327-2002N1230SSpecialized Aero Works LLC · Bend, ORBuilt 2005 · S/N 1011-2005N1233EWieman Dianne L · Marion, TXBuilt 1946 · S/N 7AC-4791N1234ELyddon Steven R · Liberal, KSBuilt 1946 · S/N 7AC-4792N1237EKing Bruce · El Paso, TXS/N 7AC-4795N123BKBuscombe Stanley G · Sacramento, CABuilt 1959 · S/N 7FC-331N123BYRegistered aircraftBuilt 2003 · S/N 915-2003N123DAVanderpool Tyler · Edinburg, TXS/N 798-71N123SFKraemer Daniel H F · Albany, ORBuilt 1998 · S/N 415-98N123WAAshem Aviation LLC · Wilmington, DEBuilt 1993 · S/N 726-94N1240EGevay James C · Circle Pines, MNBuilt 1946 · S/N 7AC-4798N1241EThomas Paul J · Oakland, MDS/N 7AC-4799N1244ERuppert Russell E · Dover, PABuilt 1946 · S/N 7AC-4802N1249EChez Clay LLC · Georgiana, ALS/N 7AC-4807N124MCMonteleone Gene R · Mont Vernon, TXBuilt 1979 · S/N 502-79N124RDD'Agostini Robert J · Basking Ridge, NJBuilt 2007 · S/N 1440-2007
Back to AD 2000-25-02 R1