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.

N3997EStrahan Ronald R · Girard, KSBuilt 1947 · S/N 11BC-85N3998EOchsenbauer David J DBA · Ashland, WIBuilt 1947 · S/N 11BC-86N3999YSlyman David F · Inver Grove, MNBuilt 1969 · S/N 7KCAB-225N399BCParadox Aviation LLC · Whiting, IABuilt 1999 · S/N 423-99N399BZBerjon Adventures LLC · Evergreen, COBuilt 2020 · S/N 607-2020N39DBKwasinski Mark W · Kalamazoo, MIBuilt 1969 · S/N 153N39JLLundberg Jonathan S · Fayetteville, TNBuilt 2012 · S/N 1115-2012N39LTGeorgia Forestry Commission · Macon, GABuilt 2003 · S/N 924-2003N3BNHansen Warren K · Bozeman, MTBuilt 1972 · S/N 430-73N3EVDuncan John C · Gastonia, NCBuilt 1947 · S/N 11BC-144N3FHScarborough Alex C · Lubbock, TXBuilt 2001 · S/N 451-2001N3JKPagenkopf Joseph C · Juneau, AKBuilt 1976 · S/N 941-76N3JZFreel Michael R · Cedarville, MIS/N 7FC-212N3PBBendigo Paul L · Reading, PABuilt 1946 · S/N 7AC-4103N3RJB&B Transport Inc · Omaha, NEBuilt 2008 · S/N 1027-2008N3VXCoriell Lynn V · Columbus, OHBuilt 1968 · S/N 631N3YBMonroe Andrew P · Reno, NVBuilt 1976 · S/N 76-564N4000ESweeney Brett D · Anchorage, AKS/N 11BC-88N4003EKnight Aaron P · Marion, INBuilt 1947 · S/N 11BC91N4008AJuniata Valley Rv · Mifflintown, PABuilt 1947 · S/N 47-1095N4009BOoi Lucy M · Catlett, VAS/N 7BCM-380N400ABFlydallasbay LLC · Soddy Daisy, TNFirst renewal noticeBuilt 1999 · S/N 838-99N400HWHotel Whiskey LLC · Sylvania, OHBuilt 1994 · S/N 739-95N400KBArrowhead Circle Leasing LLC · Cedar City, UTBuilt 1997 · S/N 1234-97N400VWSpuza Dan D · Sanger, TXBuilt 1992 · S/N 681-92N400WHHorrigan William Jr · Roxbury, CTBuilt 2001 · S/N 875-2001N4012EFogle Timothy G · Lindsay, TXBuilt 1947 · S/N 11BC-100N4015BFletcher John G · Diamondhead, MSS/N 7BCM-401N4015ESeefeldt Richard K · Denver, COS/N 11BC-103N40178Schuh Randy G · Williams, MNS/N 11AC-95N4018BAven Michael R · Yorba Linda, CAS/N 7BCM-337N4019BKapellair LLC · Wickenburg, AZS/N 7CCM-62N4019EParker Thomas L Jr · Mount Vernon, ARBuilt 1947 · S/N 11BC-108N401ADAlexander Brad K · Melissa, TXS/N 154-74N4022EGhl Air LLC · Ames, IABuilt 1947 · S/N 11BC-110N4027EGrimshaw Nicholas A · Galt, CABuilt 1947 · S/N 11BC-115N4031EMathis Gary A · Gonvick, MNS/N 11BC-118N4033ECongdon Carl J · Manley, AKBuilt 1947 · S/N 11BC-121N4034EAdams Thomas D · Marathon, NYBuilt 1947 · S/N 11BC-122N4035EMurray Richard H · Celina, OHS/N 11BC-123N4038ELerol Dustin C · Floodwood, MNBuilt 1947 · S/N 11BC-162N4040AShifrin Salvatore J · Windham, CTBuilt 1947 · S/N 47-1080N4045EEwbank Martha C · Fairport, NYBuilt 1947 · S/N 11BC-133N4046EKnutson Wayne R · Thompson, NDFirst renewal noticeBuilt 1947 · S/N 11BC135N4049EWilcox Darrol A · Nenana, AKBuilt 1947 · S/N 11BC-137N404JEMedia Stew LLC · Carson City, NVBuilt 1993 · S/N 724-93N4053EMacveigh Craig A · New Carlisle, OHS/N 11BC-141N4057ESingleton Bruce W · Grafton, OHBuilt 1947 · S/N 11-BC-145N405RCWaterman David N · Amery, WIS/N 4-71N4060EValez Jay Daniel · North Branch, MNS/N 11BC-148
Back to AD 2000-25-02 R1