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.

N712KWing John David · Guymon, OKS/N 389-78N714TMVetter Brent E · Helena, MTBuilt 1972 · S/N 348-72N71528Little John · Hamilton, TXS/N 7ECA-326N7158PJinnette James · Raleigh, NCBuilt 1963 · S/N 175N715ACLowther Fred · Corvallis, ORBuilt 2004 · S/N 1360-2004N715AMVon Graff Kurt · Pennington, NJBuilt 1993 · S/N 703-93N715DMWestrum Durl Troy · Norwalk, IAS/N 7CCM-215N715SPWitt Edward E · Jacksonville, FLBuilt 1946 · S/N 7AC-5787N715SSS & N Aviation Inc · Wilmington, DEBuilt 1956 · S/N 7EC380N715USuper D Aviation LLC · Lafayette, ALBuilt 2013 · S/N 1134-2013N71681Lindstrom Bruce C · Sinclairville, NYS/N 7AC-4176N716ACAlexandrov Boyan · Reno, NVBuilt 1993 · S/N 725-93N717ACKcd Aviation LLC · Tonica, ILBuilt 1995 · S/N 757-95N717LVPage Wayne N · Corning, IABuilt 2004 · S/N 970-2004N718TETheis Timothy J · St Charles, ILS/N 334-76N719S & D Aviation LLC · Pamplico, SCFirst renewal noticeBuilt 1946 · S/N 7AC-5630N719ACZing Aviation And Marine LLC · Edgewater, FLBuilt 2001 · S/N 1314-2001N719MWMel Williams Aviation LLC · Fairburn, GABuilt 1978 · S/N 399-78N71BPPantaleo Robert · Vineland, NJBuilt 1993 · S/N 701-93N71DGDorrance Stephen H · Livingston, MTS/N 7AC2540N71GKMetsger J Grant · Granbury, TXBuilt 2008 · S/N 516-2007N71SDRalph B Beatty LLC · Murrysville, PABuilt 1980 · S/N 625-80N720ACKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1999 · S/N 1270-99N7217KGoritchan Boris J · Duluth, MNBuilt 1948 · S/N 11CC-206N722SSWind Wizards Inc · El Paso, TXBuilt 1974 · S/N 287-74N723AKFrohnapfel Mark T · Cordova, AKBuilt 1974 · S/N 76-74N723CLVan Why Johnathan Ryan · Corvallis, ORBuilt 1999 · S/N 829-99N72468Grieve David C · Mountain Grove, MOBuilt 1976 · S/N 7AC-5450N72493Cook Tyler · Seldovia, AKBuilt 1975 · S/N 18775N724MSNannenga Fredrick Jr · Hillsboro, ORBuilt 1967 · S/N 298N725ACFiorini Jay · Turlock, CABuilt 1999 · S/N 1254-98N725CMScholz Mark W · Atchison, KSBuilt 1997 · S/N 794-97N725HEOtt Edward C · Walnut Creek, CABuilt 2000 · S/N 441-2000N725JMRegistered aircraftBuilt 1997 · S/N 798-97N726ACGrass Roots Aviation LLC · Bend, ORBuilt 1999 · S/N 1276-99N726AWPhilbin Andrew Patrick · Cleveland, OHBuilt 2013 · S/N 1118-2012N727FWVoler Dans La Gloire LLC · Narberth, PABuilt 2012 · S/N 1121-2012N727MRUnavex Inc · Pensacola, FLBuilt 1979 · S/N 494-79N728JBBex Inc · Wilmington, DEBuilt 2014 · S/N 560-2014N729JPunton Robert P · Ayr, NDBuilt 2001 · S/N 1313-2001N72ARDollar Douglas A · Crawford, MSBuilt 1972 · S/N 22-72N72DCopenhaver Tracy K · Anthony, KSBuilt 1972 · S/N 14-72N72DLD Air LLC · The Colony, TXBuilt 1976 · S/N 263-76N72EBVector Airmotive LLC · Frisco, TXS/N 1211-95N72KCYeilding R Edward · Florence, ALBuilt 1972 · S/N 298-72N72LFLarrabee Joey S Trustee · Holyoke, COBuilt 2005 · S/N 1388-2005N72QTRegistered aircraftBuilt 1972 · S/N 365-72N72YOlson Ezra · Kingman, KSS/N 11AC-1847N730ACHeimbach Paul A · Steamboat Springs, COBuilt 1999 · S/N 1277-99N731JDReifschneider Harry III · Mesa, AZBuilt 1977 · S/N 340-77
Back to AD 2000-25-02 R1