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 AALA2018061329026Battery · no testBATTERY 14WL, MID RT, FAILED CIDS1 TEST. REMOVED AND REPLACED THE BATTERY IAW AMM 33-51-38. OPS TESTED OK.SDR SWAA2018061222714Light · inoperativeR2 DOOR HEADER PANEL EMERGENCY EXIT LIGHT INOP. R&R LIGHT HOUSING ASSEMBLY IAW AMM AND WDM.SDR AALA201806120003Battery Pack · dischargedAFT CABIN HAS SEVERAL EMERGENCY LIGHTS INOPERATIVE. REPLACED THE EMERGENCY LIGHT BATTERY PACK M33409 IAW AMM 33-51-06-960-803. OPS CHECKED NORMAL.SDR UIEA2018061101128Light · inoperativeEXTERNAL EMERGENCY EXIT LIGHT INOP. RELAMPED L388 EXTERNAL EMERG EXIT LIGHT IAW AMM 33-51-17 OPS CHECKED GOOD.SDR UIEA2018061101107Bracket · brokenL1 DOOR LIGHT PANEL INTERNAL LIGHT BRACKET BROKEN. REMOVED AND REPLACED L1 DOOR EXIT LIGHT PANEL IAW SFMMS 33-51-01-022-802 AND 33-51-01-402-803. OPS CHECKED MC28893 18MAY18 EXIT SIGN IAW SFMMS 33-51-01-712-013 OPS CHECK GOOD.SDR UIEA201806121109Bulb · unsecureEXTERIOR EMERGENCY LIGHT BY THE L1 DOOR WAS FOUND INOPERATIVE. THE EMERGENCY LIGHT WAS FOUND TO HAVE BULB NOT INSTALLED PROPERLY. INSTALLED THE BULB CORRECTLY IAW AMM 33-51-06-902-082, OPS CHECKED GOOD IAW 33-51-06 862-083.SDR UIEA201806121117Bracket · brokenL1 DOOR LIGHT PANEL INTERNAL LIGHT BRACKET BROKEN. REMOVED AND REPLACED L1 DOOR EXIT LIGHT PANEL IAW 33-57-01-022-802, AND 33-51-01-402-808. OPS CHECKED THE EXIT SIGN IAW MM 33-51-01-712-013, CHECKED GOOD.SDR UIEA2018061101119Bulb · inoperativeEMERGENCY LIGHT BY THE L1 DOOR WAS FOUND INOPERATIVE. EMERGENCY LIGHT OUTSIDE L1 DOOR WAS FOUND TO HAVE A BULB NOT INSTALLED PROPERLY. INSTALLED THE BULB CORRECTLY IAW AMM 33-51-06-902-082, OPS CHECK GOOD IAW 33-51-06 B62-083.SDR SIMA2018061110001Lamp · inoperativeSERVICE DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-50-09-000-801-A, AND 33-50-09-400-801-A. OPS CHECKED GOOD.SDR DALA2018061003921Battery Pack · dischargedEMERGENCY CEILING LIGHTS AT ROW 17-20 INOP. REPLACED BATTERY PACK AT B5-102 REF AMM 33-53. OPS CHECK GOOD.SDR AALA201806139027Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY DOOR, 3R SIDEWALL, LIGHT INOPERABLE. MAINTENANCE RELAMPED PER AMM 33-21-11 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2018061319037Battery Pack · faultyCIDS ESPU SYSTEM TEST ESPU 13WL, BATTERY FAULT. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-38. OPS CHECKED GOOD.SDR AALA201806121001Power Supply · no testEMERGENCY POWER SUPPLY 14WL FAILED TO TEST. REPLACED EPSU IAW AMM 33-51-38.SDR SWAA2018061122653Lens · missingLT EMERGENCY BULLNOSE LIGHT LENS MISSING AT ROW 4. INSTALLED LENS PER MM.SDR SWAA2018061122650Cover · looseMID CABIN OVERHEAD EMERGENCY EXIT SIGN COVER LOOSE. SECURED COVER IAW MM.SDR ASAA2018061194998Bulb · burned outR2 DOOR EMERGENCY EXIT LIGHT ON THE OUTSIDE WAS BURNED OUT. ACFT GROUNDED. REPLACED THE LAMP IAW AMM 33-51-04-960-801.SDR HALA2018061100292Socket · unsecureDURING A SERVICE CHECK, FOUND THE R1 EMERGENCY LIGHT INOPERATIVE. FOUND THE LIGHT BULB SOCKET LOOSE. TIGHTENED. OPS CHECKED OK.SDR HALA2018061100293Lamp · inoperativeR4 EMERGENCY EXT LIGHT INOPERATIVE. REPLACED THE LAMPS. OPS CHECKED GOOD.SDR SIMA2018061109005Bulb · inoperativeDURING A PS-1 CHECK, FOUND THE LT EMERGENCY LIGHT ABOVE THE WING INOPERATIVE. REMOVED AND REPLACED THE BULB IAW AMM 33-50-07. OPS CHECKED GOOD. NO FURTHER DEFECTS NOTED.SDR 29GA2018061100002Bulb · inoperativeWITH EMERGENY LIGHTS ARMED, THE ARMED LIGHT ON THE FA PANEL WAS INOPERATIVE. R & R THE EMERGENCY ARMED BULB IAW AMM 33-50-00-05-1. OPS CHECKED GOOD.SDR U2RA201806090002Light · inoperativeEMERGENCY AISLE LIGHT AT SEAT ROW 9ABC INOP - RELAMPED EMERGENCY LIGHT PER AMM 33-51-05, OPS NORMAL.SDR U2RA201806090001Light · inoperativeEXTERIOR EMERGENCY LIGHT AT R1 DOOR INOP. RELAMPED EMERGENCY LIGHT PER AMM 33-51-06, OPS NORMAL.SDR DALA2018061003923Battery · intermittentSEVERAL OVHD EMER LIGHTS INOP SEAT ROWS 11-16. REMOVED SEVERAL CEILING PANELS TO ACCESS WIRING. FOUND BATTERY PACKS INTERMITTENT. NEEDS BATTERIES(907305). RPLD BATTERIES PER AMM 33-53. ALL EMER LIGHTS NOW CK GOOD. OK FOR SERVICE. REINSTALLED CEILING PANELS.SDR MASA2018060913310Battery Pack · dischargedEMERGENCY LIGHTS RUN DOWN SHORTLY AFTER BEING TURNED ON. CHARGED EMERGENCY LIGHT BATTERIES WITH ACFT PWR.SDR AALA20180608004Battery Pack · dischargedTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHTS BY DOORS 4LH AND 4RH ARE INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY BATTERY PACKS AT DOORS 4L AND 4R (SEE SDR AALA201806119058) PER AMM 33-51-06. OK FOR SERVICE.SDR HNAA2018061200121Inverter · inoperativeEMERGENCY LIGHT WAS INOPERATIVE ABOVE THE GALLEY EXIT. R & R THE EMERGENCY LIGHT INVERTER.SDR HNAA2018061200120Bulb · inoperativeSERVICE DOOR EMERGENCY LIGHT INOPERATIVE. R & R THE BULB.SDR HNAA2018061280120Bulb · inoperativeSERVICE DOOR EMERGENCY LIGHT WAS INOPERATIVE. R & R THE BULB.SDR AALA2018061219043Lens · missingEMERGENCY LIGHT LENS MISSING. REPLACED EMERGENCY LIGHT LENS IAW AMM 33-51-15.SDR AALA201806119054Lens · missingAIRCRAFT WAS NOT GROUNDED: WHITE EMERGENCY LIGHT LENS MISSING AT 20C AND 25C. MAINTENANCE REPLACED EMERGENCY LIGHTS 20C (SEE AALA201806119050) AND 25C PER AMM 33-51-18 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201806119050Lens · missingAIRCRAFT WAS NOT GROUNDED: WHITE EMERGENCY LIGHT LENS MISSING AT 20C AND 25C. MAINTENANCE REPLACED EMERGENCY LIGHTS 20C AND 25C (SEE AALA201806119054) PER AMM 33-51-18 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201806119038Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS IN OVERHEAD BINS AT 10DEF (SEE AALA20180608007) AND 14DEF INOPERABLE. MAINTENANCE REPLACED BATTERY PACK AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA20180608007Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS IN OVERHEAD BINS AT 10DEF AND 14DEF (SEE AALA201806119038) INOPERABLE. MAINTENANCE REPLACED BATTERY PACK AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201806119058Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. THE EMERGENCY LIGHT EXIT SIGNS AT DOOR 2L DONT COME ON. REPLACED THE POWER SUPPLY BATTERY PACK AT DOOR 2L PER AMM 33-51-06. OK FOR SERVICE.SDR AALA2018061190001Battery · no testEMERGENCY LIGHT POWER SUPPLY 13WL FAILED TO TEST. REPLACED THE POWER SUPPLY AND BATTERY IAW AMM 33-51-38, OPS CHECKED GOOD.SDR SWAA2018061122695Power Supply · inoperativeRT OVERWING EMERGENCY EXIT SECTION OF LIGHTS INOP. R&R BATTERY SUPPLY IAW AMM.SDR SWAA2018061122694Charger · inoperativeRT EMERGENCY EXIT LIGHTS INOP BETWEEN ROW 18 TO ROW 24. R&R CHARGER PER AMM.SDR SWAA2018061122684Battery · failedEMERGENCY BATTERY FAILED CAPACITY CHECK AT LOCATION M1672. R&R BATTERY PER AMM & DWG.SDR SWAA2018061122683Battery Pack · failedFORWARD LT EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK. R&R BATTERY PACK PER MM.SDR SWAA2018061122682Battery Pack · failedAFT LT EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK. R&R BATTERY PACK PER MM.SDR SWAA2018061122657Battery Pack · dischargedRT OVERWING EMERGENCY EXIT SECTION OF LIGHTS INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2018061122656Charger · inoperativeLT EMERGENCY EXIT LIGHTS INOP AFT SIDE OF AIRCRAFT. R&R CHARGER PER AMM.SDR SWAA2018061122652Lens · unsecureLT OVERWING EMERGENCY EXIT SIGN LIGHT COVER FELL OFF. R&R LENS PER MM.SDR SWAA2018061122643Battery Pack · dischargedRT OVERHEAD BIN EMERGENCY EXIT LIGHT INOP BETWEEN ROW 3 TO ROW 6. R&R BATTERY PACK PER AMM.SDR AALA201806119024Power Supply · no testEMERGENCY POWER SUPPLY 14WL FAILED ON A CIDS TEST. REPLACED EPSU IAW 33-51-00.SDR IPXA2018061183425Bulb · inoperativeEMERGENCY LIGHT HAD THREE BULBS INOPERATIVE. REPLACED THE BULBS IAW AMM 33-51-01-2.SDR DALA2018061103927Power Supply · inoperativeDURING SERVICE CHECK, THE L1 AND R1 EXIT SIGNS FAILED TO ILLUMINATE DURING EMERGENCY LIGHT TEST. MAINTENANCE FOUND THAT THE BATTERY POWER SUPPLY WAS BAD AT POSITION B5-123. THE BATTERY POWER SUPPLY WAS REPLACED AND OPS CHECKED GOOD IAW AMM 33-51-03, WDM 33-5SDR F3LA2018061100351Battery · failedEPSU SYSTEM FAILED 10WL. REMOVED AND REPLACED BATTERY 10WL IAW AMM 33-51-38-PB 401.SDR DALA2018061003924Power Supply · inoperativeUPON SVC CK FOUND ROWS 1 CD THRU 12 ED EMERGENCY PATH LIGHTING INOP. R&R BATTERY POWER SUPPLY FWD CABIN PER WDM 33-51-12. ALSO R&R BATTERY ASSY (FWD CABIN) PER 33-53 OPS CKS NML A/C OK FOR SERVICE.SDR 29GA2018060800001Button · unsecureFLIGHT 0055 PNS/ MCO REPORT: FLIGHT ATTENDANT EMERGENCY BUTTON LIGHT-FALLS OUT. RESECURED FLIGHT ATTENDANT EMERGENCY BUTTON TO ASSY IAW 20-10-00.
Back to JASC 3350