JASC 3350
Service difficulty reports · 225,886
Reports filed under 3350 · Emergency Lighting, newest first.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE jasc_code = '3350' ORDER BY difficulty_date DESC"
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.
SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE jasc_code = '3350' ORDER BY difficulty_date DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR AALA201712299006Bulb · unsecureEXTERIOR SLIDE LIGHT AT L4 DOOR IS INOPERATIVE. SECURED THE BULB IAW AMM 33-51-06.SDR YENA201712271030Battery · failedFWD LEFT EPSU BATTERY (10WL) FAILED AN EMERGENCY LIGHT TEST. R & R THE BATTERY IAW AMM 33-51-38, EMERGENCY LIGHT SYSTEM TESTED OK.SDR AALA201712299008Lens · missingEMERGENCY LIGHT LENS MISSSING AT SEAT 15D. REPLACED THE LIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-11-960.SDR AALA201712289010Lamp · burned outL2 DOOR EXIT SLIDE LIGHT IS INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-06.SDR AALA201712289009Lamp · burned outR4 DOOR EXIT SLIDE LIGHT IS INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-06.SDR AALA201712289006Annunciator · no testEMERGENCY DOOR LIGHT WILL NOT TEST ON OVERHEAD PANEL. REPLACED OVERHEAD ANNUNCIATOR PANEL IAW AMM 33-16-02.SDR AALA20171228001Lens · missingPASSENGER SEAT 15D, SEAT MOUNTED EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS IAW AMM 33-151-11-960.SDR AALA201712289024Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE. INOPERATIVE EMERGENCY POWER SUPPLY UNITS , 12WL, 16WL AND 18WL IN PASSENGER CABIN. REPLACED EMERGENCY POWER SUPPLY UNITS 12WL, 16WL AND 18WL IN PASSENGER CABIN PER A330 AMM 33-51-38-000-801-A AND AMM 33-51-38-400-801-A. (SEE AALASDR AALA201712289023Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE. INOPERATIVE EMERGENCY POWER SUPPLY UNIT 16WL IN PASSENGER CABIN. REPLACED EMERGENCY POWER SUPPLY UNIT 16WL IN PASSENGER CABIN PER AMM 33-51-38-000-801-A AND A330 AMM 33-51-38-400-801-A. (SEE AALA201712289013 AND AALA201712289024 FSDR AALA201712289013Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE. INOPERATIVE EMERGENCY POWER SUPPLY UNIT 12WL IN PASSENGER CABIN. REPLACED EMERGENCY POWER SUPPLY UNIT 12WL IN PASSENGER CABIN PER AMM 33-51-38-000-801-A AND AMM 33-51-38-400-801-A. (SEE AALA201712289023 AND AALA201712289024 FOR ADSDR DALA2017122808998Light · detachedSEAT 41DEF MISSING THE EMERGENCY LIGHT ASSY. REMOVED AND REPLACED THE LIGHT ASSY.SDR SWAA2017122818684Lens · brokenRIGHT OVERWING EMERGENCY LIGHT LENS BROKEN. R & R THE LENS IAW MM.SDR DALA2017122808941Battery Pack · inoperativeEMERGENCY OVERHEAD LIGHTS INOPERATIVE FROM ROWS 27 - 36. REPLACED THE BATTERY PACK AT ROW 29 IAW AMM 33-50. ALL EMERGENCY LIGHTS OPS CHECKED GOOD.SDR MASA2017122712863Light · inoperativeROW 18 CEILING EMERGENCY LIGHT INOPERATIVE.SDR IPXA2017122724833Charger · inoperativeFOUND EMERGENCY LIGHT NOT WORKING. BATTERY CHARGER REPLACED IAW AMM 33-51-07-022-020, AND AMM 33-51-07-862-054, REV 120.01. BATTERY REPLACED AS WELL IAW AMM 33-51-07-902-001, REV 120.01.SDR CALA2017122704620Light · inoperativeRED EMERGENCY EXIT LIGHT AT SEAT 12C INOPERATIVE. REMOVED AND REPLACED RED EMERGENCY EXIT LIGHT ASSY AT SEAT 12C.SDR CALA2017122704621Lens · brokenEMERGENCY LIGHT LENS BROKEN AT SEAT 21C. REPLACED THE LENS.SDR SWAA2018010418799Cover · looseRT EMERGENCY EXIT SIGN COVER LOOSE. SECURED COVER PER SIP.SDR HALA2017122700275Sign · detachedR3 DOOR EXIT SIGN DETACHED. REPLACED THE SIGN.SDR AALA201712279040Sign · detachedEXIT SIGN AT THE L3 DOOR FELL OFF. SECURED THE EXIT SIGN AT THE L3 DOOR IAW AMM 25-21-02SDR DALA2017122708999Lens · damagedEMERGENCY EXIT LENS DAMAGED. REMOVED AND SECURED LENS AT ROW 37. OK FOR SERVICE.SDR REXA2017122601293Lamp · inoperativeRIGHT AFT EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED THE LAMP OPS CHECKED SATISFACTORY IAW AMM 33-51-15.SDR SIMA20171226005Lamp · inoperativeSERVICE DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED LAMPS IAW AMM 33-50-10-000-801-A, AND 33-50-10-400-801-A. NO FAULT FOUND.SDR DALA2017122808975Light · inoperativeEMERGENCY LIGHTS ARE INOPERATIVE. REPLACED THE LIGHTS.SDR AALA201712279030Light · malfunctionedEMERGENCY EXIT LIGHTS FLASH INTERMITTANTLY ONLY DURING FLIGH. RESET THE CIDS SYSTEM AND PERFORM LIGHT ILLUMINATION TEST IAW AMM 23-73-00-740-005. TESTED OKAY.SDR QXEA2017122700712Bulb · inoperativeCREW REPORTED FWD EMERGENCY LIGHT SWITCH BULB FLICKERING. REPLACED THE BULB. CHECKED GOOD. NO FURTHER DEFECTS NOTED. RETURNED TO SERVICE.SDR IPXA2017122624797Battery Pack · dischargedEMERGENCY LIGHT BATTERY 1 LOW. R & R THE EMERGENCY LIGHT BATTERY POWER SUPPLY IAW MM 33-51-01-400-802, OPS CHECKED GOOD IAW 33-51-01-700-802.SDR N6WA2017122601Light · inoperativeRIGHT OVERWING EMERGENCY LIGHT INOPERATIVE. R & R THE EMERGENCY LIGHT IAW AMM 33-51-15. OPS CHECKED GOOD.SDR HNAA2017122700403Light · inoperativeCOCKPIT EMERGENCY LIGHT OVERHEAD NOT ILLUMINATING. R & R OVERHEAD COCKPIT EMERGENCY LIGHT IAW AMM 33-50-08-000-400-802-A. OPS CHECKED GOOD. OK FOR SERVICE.SDR HALA2017122700324Sign · detachedEXIT SIGN AT THE R3 DOOR CEILING DETACHED. REPLACED THE SIGN. OK FOR SERVICE.SDR DALA2017122708908Battery · dischargedEMERGENCY LIGHT CEILING TAIL SECTION INOP. REPLACED D CELL BATTERIES IN AFT RT LAV BATTERY PACK. OPERATIONAL CHECKS GOOD P/N AD4002P.SDR DALA2017122608890Battery Pack · inoperativeDURING INSPECTION FOUND EMERGENCY LIGHT RO 16 TO 22 SEAT MOUNTED INOPERATIVE. MAINTENANCE REMOVED AND REPLACED BATTERY PACK IAW AMM 33-51. OPS CHECKED GOOD.SDR MASA2017122612860Battery Pack · inoperativeROW 12 FLOOR LIGHTED EXIT SIGN INOPERATIVE. CHARGED THE BATTERIES.SDR MASA2017122612859Battery Pack · dischargedMID CABIN EMERGENCY EXIT SIGN INOPERATIVE. CHARGED THE BATTERIES.SDR CALA2017122604617Bulb · incorrectR1 DOOR EXTERIOR EMERGENCY EXIT SLIDE LIGHT INOPERATIVE. FOUND AN INCORRECT BULB INSTALLED AND THE BULB HOLDER SOCKET MISSING AN INSERT. REPLACED AND SECURED THE SOCKET AND INSTALLED THE CORRECT TYPE BULB. OPS CHECKED OK IAW AMM 33-51-04.SDR CALA2017122604609Lens · missingEMERGENCY LIGHT AT SEAT 21C INOPERATIVE. LIGHT FUNCTION NORMAL, INSTALLED THE LENS, OPS CHECKED GOOD,SDR HALA2017122600276Lens · brokenEMERGENCY LIGHT LENS OVER THE R3 DOOR IS BROKEN. REPLACED THE LENS.SDR AALA201712279064Lens · missingSEAT ROW 7D EMERGENCY LIGHT LENS MISSING. INSTALLED A NEW LENS. PERFORMED AN EMERGENCY LIGHT OPS CHECK. CHECKED NORMAL IAW MM 33-51-00.SDR AALA201712279063Light · detachedEMERGENCY LIGHT AT THE AFT RIGHT DOOR DETACHED. REPLACED THE LIGHT ASSEMBLY. OPS CHECKED GOOD. OK FOR SERVICE IAW AMM 33-51-01.SDR AALA201712279051Lens · missingEMERGENCY EXIT LIGHT LENS AT THE R2 DOOR IS MISSING. INSTALLED A NEW LENS IAW AMM 33-51-16.SDR IPXA2017122724875Battery Pack · dischargedFOUND THE RT DOOR BATTERY LOW. R & R THE RT DOOR EMERGENCY POWER SUPPLY IAW AMM 33-51-05-902-001-001, AND THE LIGHT TEST NORMAL.SDR SIMA20171225003Battery Pack · inoperativeLEFT & RIGHT OVERWING EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE NR 4 BATTERY PACK AND POWER SUPPLY IAW AMM 33-50-04. OPS CHECKED GOOD.SDR AALA201712279023Lens · missingEMERGENCY LIGHT LENS MISSING AT SEAT ROW 17D. INSTALLED A LENS AND PERFORMED EMERGENCY LIGHT OPS CHECK. CHECKED NORMAL IAW MM 33-51-00.SDR AALA201712279025Lens · missingDURING CRUISE, DISCOVERED THAT THE L4 DOOR EMERGENCY LIGHT LENS WAS MISSING. REPLACED THE LENS IAW AMM 33-51-01-201. OPS CHECKED GOOD.SDR AALA201712279036Connector · unsecureEMERGENCY LIGHTS INOPERATIVE FROM SEATS 20B - 28B. FOUND THE CONNECTOR NOT SECURE, SECURED THE CONNECTOR AND OPS CHECKED GOOD IAW MM 33-51-00.SDR UIEA2017122602437Light · missingSEAT 34C EMERGENCY LIGHT MISSING.SDR AALA201712279021Lens · missingAIRCRAFT WAS NOT GROUNDED. DURING CRUISE IT WAS DISCOVERED THE 4L DOOR EMERGENCY LIGHT COVER WAS MISSING. REPLACED MISSING LENS PER AMM 33-51-01-201.SDR AALA201712279019Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT LENS MISSING AT SEAT ROW 17D. INSTALLED LENS PER AMM 33-51-00.SDR DALA2017122708918Battery Pack · inoperativeEMERGENCY LIGHTS AT 19A AND C ABOVE THE OVERWING EXITS ARE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY (P1-12) AT POWER SUPPLY IAW AMM 33-51.SDR ASAA2017122523002Lens · damagedEMERGENCY LIGHT EXIT LOCATOR SIGN ADJACENT TO R-2 DOOR HAS DAMAGED LENS. ACFT GROUNDED. REPLACED THE LENS AND TESTED THE LIGHT ASSY IAW AMM 33-51-01-960-801. OPS NORMAL.
Back to JASC 3350