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.

N3134EMuehlstein Charles W · Stamford, TXBuilt 1946 · S/N 7AC-6731N3136EWest William T · Clarksville, VAS/N 7AC-6733N3139ERainbow Flying Service LLC · Moses Lake, WAS/N 7AC-6736N313CEAvidash LLC · Cape Coral, FLBuilt 1972 · S/N 886-72N313MTNguyen Nhu-An T · Parkville, MDBuilt 1977 · S/N 356-77N313WFSalisbury Peter R · White Bear Lake, MNBuilt 2001 · S/N 879-2001N3140EChapman Jerry L · Oakdale, MNBuilt 1946 · S/N 7AC-6737N3144EAirpower Museum Inc · Ottumwa, IABuilt 1947 · S/N 7AC-6740N3147ERichardson Barry Ted · Butler, TNBuilt 1946 · S/N 11AC-1525N3147NAgaliotis Paul E · San Martin, CAS/N 350N3149EBaier Warren R · Horicon, WIBuilt 1946 · S/N 11AC-1447N314MAircraft Partner Holdings Inc Trustee · BerlinBuilt 2010 · S/N 524-2010N314REvans Randall B Trustee · Fallon, NVBuilt 1998 · S/N 399-98N3153EFischer Francis P · New Oxford, PABuilt 1946 · S/N 11AC-1498N3154ERothwell Forest · Ironton, MNS/N 11AC-1499N3156EStap Scott · Bancroft, MIBuilt 1946 · S/N 11AC-1449N315ACDuewall Danny · Midland, TXBuilt 2000 · S/N 421-2000N3162EMulvania Rodney A · Linn, MOBuilt 1946 · S/N 11AC-1503N3168EKroll Richard L · Kalamazoo, MIBuilt 1946 · S/N 11AC-1508N316ACBillings Brian · Bondurant, WYBuilt 2001 · S/N 1318-2001N3174CDufresne Roger T · Forest Lake, MNBuilt 1947 · S/N 7BCM292N3175EHarter Ryan A · Greenfield, INBuilt 1946 · S/N 11AC-1515N3179EClark Allen J · Minnetonka, MNBuilt 1946 · S/N 11AC-1519N317JRUnd Aerospace Foundation · Grand Forks, NDBuilt 2010 · S/N 1105-2011N317SDSipila Hart A · Soquel, CAS/N 778-96N3181EWainwright Carter T · Lees Summit, MOS/N 11AC-1522N3183EHuss Micah A · Nome, AKBuilt 1946 · S/N 11AC-1527N3186ENorlin Lary G · Indianola, IABuilt 1946 · S/N 11AC-1528N3187Bentley Chris H · Tallahassee, FLS/N 7AC5761N3187EGriggs Thomas E Jr · Sherman, TXBuilt 1946 · S/N 11AC-1536N3189EWeishar Walter E · Shafter, CABuilt 1946 · S/N 11AC-1533N318ACAughenbaugh Alan M · Iroquois, SDBuilt 2000 · S/N 1298-2000N318JRFlywell Aviation LLC · Bowling Green, KYBuilt 2006 · S/N 1013-2006N3195CDarling Jonathan S · Pender, NES/N 7BCM-171N3199EJohnston Robert D · Palmyra, MES/N 11AC-1544N319SANelson Edwin L · Kingsland, TXBuilt 2006 · S/N 1421-2006N31MSWagon Leasing LLC · Jonesboro, ARBuilt 2018 · S/N 593-2018N31SCObryant Jeffrey A · Fairbanks, AKBuilt 1967 · S/N 79N31SETangent LLC · Phoenix, AZBuilt 2005 · S/N 978-2005N31TWHall Wendell W · Cheraw, SCS/N 7FC-170N31VSJenny Timothy J · Remsen, NYBuilt 1999 · S/N 1273-99N31XEverson Dustin J · Providence, RIBuilt 1992 · S/N 671-92N31YFCharliefoxtrot LLC · Farmington, MOBuilt 2015 · S/N 1158-2015N3201EMcgavock Randall J · Camp Verde, AZBuilt 1946 · S/N 11AC-1546N3202EBlazey James R · Palmyra, NYBuilt 1946 · S/N 11AC1547N3202HRegistered aircraftS/N 524-73N3203EBaker Marty R · Noonan, NDS/N 11AC-1548N3204EDanford Michael S · Chickamauga, GAS/N 11-AC-1549N320MMExplorer Aviation LLC · Birmingham, MIBuilt 1997 · S/N 1231-97N3213ERedmon Ronald D · Crestwood, KYS/N 7AC-6747
Back to AD 2000-25-02 R1