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 SWAA2018092825604Cover · unsecureMID CABIN EXIT SIGN FELL OFF. SECURED COVER IAW SIP.SDR CALA2018092802003Power Supply · inoperativeALL EMER EXIT LIGHTS ON M1670 PWR SUPPLY DO NOT WORK. REPLACED BATTERY PACK AND CHARGER REF AMM 33-51-06-201. OPS CHECKED OK UNSPECTED EMERGENCY LIGHTS OPS CHECK GOODSDR SWAA2018100125654Light · inoperativeAFT GALLEY DOOR UPPER EMERGENCY LIGHT BULB INOP. R&R BULB PER AMM.SDR AALA201810019047Battery Pack · no testEMERGENCY LIGHTS EPSU SYSTEM TEST FAILED, 15WL. REPLACED THE BATTERY PACK IAW AMM 33-51-38 . CHECKED GOOD.SDR AALA201810019046Battery Pack · no testEMERGENCY LIGHTS EPSU SYSTEM TEST FAILED 14WL. REPLACED THE BATTERY PACK IAW AMM 33-51-38. CHECKED GOOD.SDR AALA201810019041Battery Pack · no testEMERGENCY LIGHTS EPSU SYSTEM TEST FAILED 12WL, REPLACED THE BATTERY PACK IAW AMM 33-51-38 . EPSU SYSTEM TEST CHECKED GOOD.SDR SWAA2018092825617Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED AT M1673. R&R BATTERY PACK PER AMM.SDR SWAA2018092825614Light · inoperativeR2 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA2018092825605Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01674. R&R BATTERY PER AMM.SDR SWAA2018092825603Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED AT EXTERIOR M1673. R&R BATTERY PACK PER AMM.SDR AALA201809289021Light · tornPHL - THE AIRCRAFT WAS NOT GROUNDED. FLOOR ESCAPE LIGHTING STRIP AT 1D TORN. MAINTENANCE REPLD. FLORESCENT LIGHTING STRIP, CHKS OK.SDR ASAA2018092876297Connector · looseL2 DOOR OVER DOOR EMERGENCY EXIT SIGN AND EMERGENCY EXIT LOCATOR SIGN WILL NOT ILLUMINATE. GROUNDED - YES. FOUND CONNECTOR D40044P LOOSE RECONNECTED CONNECTOR. OPS CHECKD PER B737-800 AMM 33-51-00. OPS CHECKED GOOD.SDR ASAA2018092876296Lens · missingWHILE COMPLETING TASK CARD # 78233008 (EMERGENCY LIGHTS-OPERATIONAL CHECK) FOUND LH FWD OVERWING EMERGENCY EXIT LIGHT LENS COVER MISSING. GROUNDED - YES. REPLACED LH FWD OVERWING EMERGENCY EXIT LIGHT LENS COVER REF B737-800 AMM 33-51-01-960-801.SDR IPXA2018092874455Battery · inoperativeFOUND THE UPPER DECK EMERGENCY LIGHT WAS INOPERATIVE. REPLACED THE EMERGENCY LIGHT BATTERY AND PERFORMED AN EMERGENCY LIGHT TEST, RESULT WAS SATISFACTORY IAW AMM 33-51-04-902-001-001 REV 93.01.SDR IPXA2018092874454Battery · inoperativeFOUND THE UPPER DECK EMERGENCY LIGHT INOPERATIVE. REPLACED THE EMERGENCY LIGHT BATTERY AND PERFORMED EMERGENCY LIGHT TEST, RESULT WAS SATISFACTORY, IAW AMM 33-51-04-902-001-001, REV 93.01.SDR AALA201809289014Battery Pack · dischargedEMERGENCY POWER SUPPLY BATTERY 12WL SHOWING LOW VOLTAGE. REPLACED THE BATTERY IAW AMM 33-51-38. OPS CHECKED NORMAL.SDR AALA201809289012Light · burned outBLUE EMERGENCY LIGHT OUT AT SEAT 9D. THE AIRCRAFT WAS GROUNDED. REPLACE THE BLUE LIGHT IAW M&E 26-0525-8-0653.SDR AALA201809289018Lens · missingL4 DOOR EXIT LENS WAS MISSING. REPLACED THE LENS IAW AMM 33-51-17.SDR SIMA20180927002Charger · inoperativeDURING PS-2 INSPECTION FOUND MULTIPLE INTERIOR EMERGENCY LIGHTS INDICATIONS OUT. (DS519, DS191)-C/A-TROUBLESHOOT IAW FIM 33-5100-810-804 AND FOUND EPSU#2 BATTERY CHARGER AND ASSY TO BE BAD. RAR EPSU #2 BATTERY CHARGER AND ASSY IAW CRJ 700 AMM 33-51-157. OPSSDR SIMA201809287001Lens · crackedEMERGENCY EXIT LIGHT COVER ABOVE FWD SERVICE DOOR IS CRACKED.-C/A-FOUND FWD SERVICE DOOR EMERGENCY EXIT LIGHT COVER CRACKED. RAR NEW EMERGENCY EXIT LIGHT COVER. IAW AMM 33-50-19.SDR DALA2018092700271Light · malfunctionedAFTER GEAR RETRACTION, SOME EXIT LIGHTS IN CABIN REMAINED ON THROUGHOUT THE FLIGHT. RESET LGCIU 1 AND 2. LP 4685367SDR DALA2018092700270Light · damagedEMERGENCY SEAT MOUNTED LIGHT DAMAGED. RE-INSTALLED EMERGENCY LIGHT. LP 0759460SDR MASA2018092711414Bulb · inoperativeROW 14DF EXIT SIGN HAS ONE BULB INOP. PLACED ON MELSDR MASA2018092711413Connector · inoperativeROW 4D EXIT SIGN INOP. REINSTALLED CONNECTORSDR SWAA2018100125638Light · inoperativeLT EMERGENCY BIN LIGHT INOP AT ROW 17. R&R LIGHT ASSEMBLY IAW AMM.SDR YENA2018100160394Battery Pack · dischargedFLT 1558, BOG-FLL. FOUND MULTIPLE EMERGENCY LIGHTS FWD GALLEY INOP; REPLACED BATTERY PACK ON CHARGER IN FWD LT OVERHEAD PER AMM 33-51-00.SDR YENA2018100160393Charger · failedFLT 1558, BOG-FLL. FOUND FWD GALLEY EMERG EXIT LIGHT AS WELL AS ROW 1 AND 3 LIGHTS OUT; FOUND GALLEY BATTERY CHARGER, FWD LT SIDE, BAD. REPLACED BATTERY CHARGER PER AMM 33-51-00. GROUND CHECK GOOD.SDR SIMA2018100126002Inverter · inoperativeFIRST EMERGENCY LIGHT FLOOR STRIP AND EMERGENCY LIGHT NEXT TO LOWER SERVICE DOOR INOP.-C/A-T/S EMERGENCY LIGHTING FLOOR STRIP AND LOWER SERVICE DOOR EMERGENCY LIGHTS INOP AND FOUND NR 2 AC INVERTER BAD. REMOVED AND REPLACED NR 2 EMERGENCY LIGHT INVERTER OPS CHSDR UIEA2018100102161Battery Pack · dischargedFOUND EMERGENCY LIGHT INOP AT L1 DOOR AND MD CEILING. IAW AMM 33-51-04-902-001-001 REV 93 R&R BATTERY PACK. IAW AMM 33-51-04-902-001-001 REV 93 PERFORMED EMERGENCY LIGHT TEST, OPS CK NORMAL.SDR SWAA2018092825615Light · inoperativeLOWER LEFT CORNER DOOR EMERGENCY EXIT LIGHT INOP. R&R LIGHT ASSEMBLY IAW MM.SDR AALA201809287001Battery Pack · no testWHILE PERFORMING AN OPERATIONAL TEST OF THE EMERGENCY POWER SUPPLY UNIT SYSTEMS, RECEIVED CODE 335100 BATTERY/EPSU 12, EMER R. REPLACED THE POWER SUPPLY BATTERY PACK 12WL IAW AMM 33-51-38. OPS CHECKED GOOD.SDR ASAA2018092626282Light · inoperativeR1 SLIDE LIGHT INOP. GROUNDED - YES. RELAMPED R1 SLIDE LIGHT REF AMM 33-51-04, OPS TEST GOOD.SDR HALA2018092700272Light · detachedAFT GALLEY EMERGENCY LIGHT STRIP NEEDS TO BE ATTACHED. RE-ATTACHED STRIP.SDR AALA201809279014Light · inoperativeAIRCRAFT WAS NOT GROUNDED. PHOTOLUMINESCENT INDICATOR STRIP LIGHTS WERE INOPERABLE IN THE FIRST CLASS AREA. MAINTENANCE REPLACED LIGHTS PER AMM 33-50-21 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2018092725602Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1675. R&R BATTERY PER AMM.SDR SWAA2018092725601Battery · dischargedR1 INTERIOR EXIT LIGHTS INOP. R&R BATTERY IAW MM.SDR SWAA2018092725600Lens · missingR2 DOOR EMERGENCY EXIT LENS COVER MISSING DIRECTIONAL ARROW. R&R LENS IAW MM.SDR SWAA2018092725598Light · inoperativeRT EXTERIOR OVERWING EXIT LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018092725595Battery · dischargedR1 EXTERIOR EXIT LIGHTS INOP. R&R BATTERY IAW MM.SDR SWAA2018092725594Cover · brokenCENTER AISLE OVERHEAD EXIT SIGN COVER BROKEN OFF. REINSTALLED LENS COVER PER SIP.SDR SWAA2018092725592Lens · unsecureCEILING EXIT SIGN OVER EMERGENCY EXIT ROWS CAME OFF. REINSTALLED LENS IAW MM.SDR SWAA2018092725583Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1673. R&R BATTERY PER AMM.SDR SWAA2018092725569Lens · missingL2 DOOR EMERGENCY EXIT LENS COVER MISSING DIRECTIONAL ARROW. R&R LENS IAW MM.SDR SWAA2018092725559Sign · unsecureR1 DOOR EMERGENCY EXIT SIGN NEAR WALL FELL OFF. R&R SIGN ASSEMBLY PER SIP.SDR DALA2018092700268Lens · detachedPATH LIGHT HANGING AT SEAT 14H AND 16H. INSTALLED NEW LENS. LP 5217924SDR AALA201809279013Battery Pack · no testAFT LEFT SERVICE DOOR EMERGENCY LIGHT WAS INOPERATIVE. THE AIRCRAFT WAS GROUNDED. MAINTENANCE REPLACED THE BATTERY PACK AND CHARGER. PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201809279001Sign · inoperativeLEFT OVERWING DOOR LOWER EXIT SIGN DID NOT ILLUMINATE. REPLACED EXIT SIGN ASSEMBLY IAW AMM 33-50-15. OPS CHECKED OK FOR SERVICE.SDR DALA2018092765773Battery Pack · no test(LOG 4777493) DURING INSPECTION FOUND BATTERY PACK AT POS M1694 FAILED CAPACITY CHECK. MAINTENANCE REMOVED AND REPLACED BATTERY PACK PER B737 AMM 33-51. OPS CK GOOD.SDR SIMA201809276003Light · inoperativeEMERGENCY LIGHT ON SEAT 12C INOP-C/A-RAR EMERG LIGHT EXIT SIGN ON SEAT 12C IAW AMM 33-50-14 OPC WAS GOOD AT THIS TIMESDR MASA2018092611411Battery · dischargedROW 13 EMERGENCY LIGHTS INOP. CHARGED BATTERIES
Back to JASC 3350