AD 2011-25-01

Registered aircraft · 2,822

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:2011-25-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-25-01')
  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.

N1404WPendley Rory G · Torrance, CABuilt 1968 · S/N 298N140HLGm Leasing Company LLC · Broussard, LABuilt 2003 · S/N 53575N1416Gm Leasing Company LLC · Broussard, LAS/N 53110N141APGm Leasing Co LLC · Broussard, LABuilt 2000 · S/N 53441N141FAOrange County Fire Authority · Irvine, CABuilt 2008 · S/N 36484N142DPMarks Lloyd · Lafayette, LABuilt 1980 · S/N 45585N142MAMinuteman Aviation Inc · Missoula, MTBuilt 1996 · S/N 53123N1431WC-Pan Aero LLC · Stratford, CTBuilt 1969 · S/N 374N1435WFarwest Aviation LLC · Billings, MTS/N 916N143HBank Of Utah Trustee · Salt Lake City, UTS/N 54171N143MHMetro Aviation Inc · Shreveport, LABuilt 2007 · S/N 0613N143PHWestern USA Solutions Inc · Kodiak, AKS/N 33134N144ATBell Textron Inc · Fort Worth, TXS/N 39144N144BHAbc Helicopters Inc · Jefferson, WIBuilt 1975 · S/N 1600N144MAMinuteman Aviation Inc · Missoula, MTBuilt 1998 · S/N 53255N144TVAir Flite Inc · Shawnee, OKBuilt 1982 · S/N 45602N145BHBell Textron Inc · Fort Worth, TXS/N 39145N145LTLt Aviation LLC · Louisa, KYS/N 1880N146SHScott'S Helicopter Services · Le Sueur, MNBuilt 1973 · S/N 957N146SPSamaritan'S Purse · Boone, NCBuilt 2000 · S/N 52243N147AGTop Gun Precision Ag LLC · Skidmore, TXBuilt 1980 · S/N 3145N147CBJab II LLC · Mobile, ALBuilt 2023 · S/N 56367N14837Oscar Aerial Spraying LLC · Grady, OKBuilt 1972 · S/N 850N148AWAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2008 · S/N 53879N148BHBell Textron Inc · Fort Worth, TXS/N 37014N148KYCommonwealth Of Kentucky · Frankfort, KYBuilt 1975 · S/N 1795N149PDAdministracion De Los Servicios Generales · San Juan, PRS/N 54143N14HXHelicopter Express LLC · Chamblee, GABuilt 1997 · S/N 53184N14LACounty Of Los Angeles · Pacoima, CABuilt 2005 · S/N 36393N14SJAlternative Energies Corp · Beaver Island, MIS/N 45564N14ZBlack Labs LLC · Anaconda, MTS/N 54704N150AMAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 54046N150F11 11 Enterprises LLC · San German, PRBuilt 1975 · S/N 1866N150HHCascade Airways LLC · Jefferson, ORBuilt 1971 · S/N 701N1510LCity Of Dallas · Dallas, TXBuilt 2006 · S/N 4613N1511LCity Of Dallas · Dallas, TXBuilt 2006 · S/N 4618N152AMAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 54049N152CAChem Air LLC · Shreveport, LABuilt 1978 · S/N 2342N153PAGm Leasing Company LLC · Broussard, LABuilt 2013 · S/N 54455N155DBSalmon River Helicopters Inc · Riggins, IDBuilt 1997 · S/N 36156N155TVU S Helicopters Inc · Marshville, NCBuilt 1990 · S/N 51339N156BHBell Textron Inc · Fort Worth, TXS/N 39156N156CAChem-Air LLC · Shreveport, LABuilt 1976 · S/N 1999N156HMSky West Aviation Inc Trustee · Albuquerque, NMS/N S-608N156MHMansfield Heliflight Inc · Milton, VTS/N 33184N157BHBell Textron Inc · Fort Worth, TXS/N 39157N157PAPatriot Aviation Inc · Greenville, DEBuilt 2003 · S/N 52241N157SJNorth Wind Aviation LLC · Cottage Grove, ORBuilt 1985 · S/N 51157N158AMAir Methods LLC · Greenwood Village, COBuilt 2019 · S/N 54811N158BCMetro Aviation Inc · Shreveport, LABuilt 1999 · S/N 0134
Back to AD 2011-25-01