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 AALA201708159005Sign · brokenDOOR EXIT SIGN BASE FOUND BROKEN AT DOOR 3R AFT. REPLACED DOOR EXIT SIGN BASE IAW AMM 33-51-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170814019Sign · brokenDOOR EXIT SIGN BASE FOUND BROKEN AT THE R4 DOOR. REPLACED DOOR EXIT SIGN BASE IAW AMM 33-51-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2017081515630Cover · missingRT DOOR EMERGENCY EXIT SIGN COVER MISSING. R&R COVER PER AMM.SDR SWAA2017081415599Switch · intermittentCOCKPIT EMERGENCY EXIT LIGHT SWITCH INTERMITTENT. R & R SWITCH IAW SWP.SDR SWAA2017081415594Cover · wrong partL1 DOOR EMERGENCY LIGHT COVER MISSING RED ARROW. R&R COVER PER AMM.SDR AALA201708099032Light · defectiveTHE AIRCRAFT WAS NOT GROUNDED. EXIT LIGHT COVER FROM AFT RIGHT DOOR FELL OFF. NEED TO BE RE-SECURED. REMOVED AND REPLACED RIGHT AFT EMERGENCY EXIT LIGHT, OPS CHECKED GOOD IAW AMM 33-51-01.SDR AALA201708099031Lens · missingTHE AIRCRAFT WAS NOT GROUNDED. LENS COVER ABOVE SEATS 20DEF CEILING IS MISSING. INSTALLED NEW LENS AND BULB CHECKS OK TO CONTINUE SERVICE IAW MM 33-51-03.SDR AALA20170808005Battery · dischargedTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHTS SEATS FIRST HALF WERE INOP. EMERGENCY LIGHT BATTERIES WERE FOUND DISCHARGED. REMOVED AND REPLACED EMERGENCY LIGHT BATTERIES FORWARD AND MID, OPS OK.SDR 2DYA20170811003Battery · inoperativeEMERGENCY LIGHTS AT R2 DOOR INOPERATIVE. REMOVED AND REPLACED THE BATTERY ASSEMBLY IAW 33-31-00.SDR 2DYA20170811002Fuse · inoperativeL1 AND R1 EMERGENCY EXIT SIGN LIGHT OUT. REMOVED AND REPLACED THE FUSE IN THE POWER SUPPLY IAW AMM 25-24-10 TEST OK. REFERENCE LP 20625SDR AALA20170809003Lens · missingAIRCRAFT WAS NOT GROUNDED. MISSING OVERHEAD EMERGENCY LIGHTING LENS COVER AT SEAT 25H. INSTALLED NEW EMERGENCY LIGHT LENS (BEZEL) PER AMM 33-51-04.SDR DALA2017080906147Lens · missingDURING PDC, FOUND EXIT LIGHT LENS AT THE R1 DOOR MISSING. THE LENS WAS REPLACED. OPS CHECKED OK.SDR DALA2017081006138Battery Pack · not seatedREAR TEAILCONE EMERGENCY EXIT LIGHT CONTINUES TO FLASH OFF & ON. RESEATED THE BATTERY PACK. SYSTEM OPS NORMAL.SDR SWAA2017081115574Battery Pack · dischargedLT EMERGENCY BULLNOSE EGRESS LIGHT INOP BETWEEN ROW 9 TO ROW 12. R&R BATTERY PACK PER MM.SDR AALA201708109023Light · inoperativeOVERHEAD EMERGENCY LIGHT IN CABIN HAVE BULBS OUT. REPLACED BULBS IN EMERGENCY EXIT SIGN.SDR SIMA20170808002Light · inoperativeROW 12 CEILING EMERGENCY LT INOP. REMOVED AND REPLACED ROW 12 CEILING EMERGENCY LIGHT BULB IAW AMM 33-50-08-000-801-A AND 33-50-08-400-801-A OPC GOOD END.SDR REXA2017080800866Light · inoperativeFOUND EMERGENCY LIGHT 1 INOP. RELAMPED EMERGENCY LIGHT IAW AMM 33-51-21. OPS CHECK GOOD, AC OK FOR SERVICE.SDR AALA201708099006Sign · brokenAIRCRAFT WAS NOT GROUNDED. R2 DOOR LOWER EMERGENCY EXIT SIGN, BROKEN OFF LOWER FASTENER. REPLACED R2 DOOR, CABIN WALL MOUNTED EMERGENCY EXIT MARKER PER M/M 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201708099005Cover · missingAIRCRAFT WAS NOT GROUNDED. R1 DOOR EMERGENCY EXIT SIGN LENS COVER MISSING. REPLACED R1 DOOR CABIN WALL, MOUNTED EMERGENCY EXIT MARKER PER M/M 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170808002Battery · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHTS SEATS 20 TO 24 AB, INOPERABLE. REPLACED EMERGENCY LIGHTS BATTERY AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR DALA2017081006119Power Supply · inoperativeDURING INSPECTION, FOUND EXTERIOR LIGHTS OUT ON LEFT SIDE OF ACFT, ONE AFT OVERWING, AND AFT LEFT, INOPERATIVE. MAINTENANCE REMOVED AND REPLACED POWER SUPPLY M1670 IAW AMM 33-51.SDR JJBA20170808010Bulb · not seatedOVERHEAD CENTER SECOND CEILING EMERGENCY LIGHT INOPERATIVE. SEATED THE BULB IN OVERHEAD EMERGENCY LIGHT.SDR JJBA20170808009Battery Pack · inoperativeEMERGENCY LIGHT BY MAIN DOOR AND VARIOUS CEILING EMERGENCY LIGHTS INOPERATIVE. R & R THE NR 1 AND 2 EMERGENCY LIGHTS BATTERIES.SDR AALA201708099012Battery · failedAIRCRAFT WAS NOT GROUNDED. DURING EPSU BATTERY CAPACITY TEST DOOR 3R (16WL) FAILED TEST. REPLACED EPSU BATTERY 16WL.SDR AALA201708099011Battery · failedAIRCRAFT WAS NOT GROUNDED. DURING EPSU BATTERY CAPACITY TEST DOOR 2R (14WL) FAILED TEST. REPLACED EPSU BATTERY 14WL.SDR AALA201708099010Battery · failedAIRCRAFT WAS NOT GROUNDED. EPSU BATTERY AT 1L (11WL) FAILED TEST. REPLACED BATTERY AT 11WL POWER SUPPLY.SDR AALA201708099009Battery · failedAIRCRAFT WAS NOT GROUNDED. EPSU BATTERY AT 3L (15WL) FAILED TEST. REPLACED BATTERY AT 15WL POWER SUPPLY.SDR AALA201708099021Power Supply · faultyEMERGENCY. POWER SUPPLY ABOVE R3 DOOR FAULTING. REMOVED AND REPLACED EMERGENCY POWER SUPPLY UNIT ABOVE R3 DOOR IAW AMM.SDR DALA2017080906065Connector · malfunctionedWHILE PERFORMING EMERGENCY LIGHT TEST DURING SERVICE CHECK, HAD MULTIPLE MESSAGES INTERNAL LIGHT FAULT. DISCONNECTED & RECONNECTED R MIN CABIN EPSU CONNECTOR. TEST OK. OK ON EPSU AND FAP.SDR DALA2017080906063Attach Fitting · missingEMERGENCY EXIT SIGN COVER LOOSE, LOCATIONS:601. EXIT SIGN POPS OFF AT EACH LANDING. MAINTENANCE FOUND THE ATTACHING STRIP FOR THE LENS WAS MISSING. REPLACED ATTACHING STRIP AND REINSTALLED THE LENS REF AMM 33-51.SDR CALA2017080802580Battery Pack · dischargedEMERGENCY LIGHTS AT BAG BIN AREA ROW 21,23,25,28 INOP. REMOVED AND REPLACED BATTERY PACK AT LOCATION M1671. OPS CHECK GOOD REF AMM 335106 VERIFIED BATTERY PACK REPLACED AND EMERGENCY PATH LIGHTING OPERATIONAL CHECK REF AMM 33-51-06.SDR CALA2017080802579Light · inoperativeINTERIOR EMERGENCY LT AT OVERHEAD STORAGE BIN 31C INOP. REMOVED AND REPLACED THE LAMP IN THE EMERGENCY EXIT AISLE LIGHT ABOVE SEAT 31C. OPS CHECK OK. REF MM 33-51-05-002-001.SDR CALA2017080802576Power Supply · faultyDURING EMERGENCY LIGHT TEST HAVE FAULT EPSU BATTERY EMER L. REMOVED AND REPLACED EPSU AND BATTERY AT DOOR 1L,OP CHECK NORMAL REF AMM 33-51-38.SDR CALA2017080802575Battery Pack · faultyLEFT AFT EMERGENCY LIGHT POWER SUPPLY FAULTING REF 2 SVC ITEM 16. REPLACED BATTERY PACK, REF AMM 33-51-00, EMERG LIGHTS OPS CHECK OK.SDR CALA2017080802573Light · missingRED COVER FOR EXIT ROW LIGHTS 15ABC MISSING. REPLACED EMERGENCY LIGHT IAW AMM 33-51-11.SDR CALA2017080802572Light · inoperativeL3 DOOR EMERGENCY AREA LIGHT INOP. REMOVED AND REPLACED LAMP IAW AMM 33-51-03.SDR CALA2017080802570Battery · failedEMER EXIT BATTERY AT LT OVERWING EXIT FAILED CAPACITY CHECK. REPLACED BATTERY REF AMM 33-51-38 OPS CHECKED OK.SDR CALA2017080802569Light · inoperativeDOOR 2 EXTERIOR EMERGENCY LIGHT INOP. RELAMPED. OPS CK GOOD.SDR CALA2017080802567Sign · brokenDOOR 2L AFT GALLEY EMERGENCY EXIT SIGN ADJACENT WASTE CONT BROKEN/DETACHED. R&R DOOR 2L EMERGENCY DOOR EXIT LIGHT ASSEMBLY LENS COVER. OPS CHECK GOOD. A/C OK FOR CONTINUED SERVICE.SDR CALA2017080802566Lens · missingFWD EMERGENCY EXIT LIGHT COVER MISSING ON FWD LEFT BULKHEAD. INSTALLED NEW EXIT LENS ON FWD LEFT BULKHEAD. ACFT OK TO CONTINUE.SDR CALA2017080802565Sign · unsecureEMERG EXIT SIGN MID CABIN FELL OFF. REINSTALLED EMERG EXIT SIGN MID CABIN REF AMM25-60.SDR CALA2017080802564Charger · faultyEMERG LT C/B PASS CABIN RT AFT B9 POPPED. T/S AND LOCATED BAD CHARGER AT M1672 ABOVE AFT GALLEY CIEL REPLACED POWER SUPPLY CHARGER REF AMM 33-51-06-960-806 OPS CHECK GOOD.SDR CALA2017080802563Light · inoperativeEMERGENCY LIGHTS AT ROWS 20 AND 22 ON THE RT SIDE OF THE CABIN INOP DURING LIGHT CHECK. RELAMPED, OPS CHECKED GOOD. REF AMM 33-51-00.SDR CALA2017080802558Light · brokenON SEAT 20C. THE RED LIGHT THAT SHOWS THE EMERGENCY EXIT HAS BEEN BROKEN OFF. REPLACED RED LIGHT FOR EMERGENCY EXIT IN SEAT 20C.SDR CALA2017080802554Control Unit · faultyDURING EMERGENCY LIGHT TEST, FOUND FLOOR LIGHTING AT ROWS 1 & 2 INOPERATIVE. R & R WCU AT SEAT 1F, OPS CHECKED GOOD. WORK IAW AMM 33-51-00-00C-320A.SDR CALA2017080802552Power Supply · inoperativeEMERGENCY LIGHTS OUT AT ROW 4ABC. REPLACED THE POWER SUPPLY M1676 IAW AMM 33-51-11. TESTED GOOD.SDR CALA2017080802551Lens · brokenSEATS 23, 21, 20, AND 12 HAVE BROKEN EMERGENCY LIGHT LENS. REMOVED AND REPLACED LIGHT LENSESSDR CALA2017080802547Light · inoperativeEMERGENCY LIGHT AT SEAT 56H INOPERATIVE. REPLACED THE LIGHT AND OPS CHECKED GOOD IAW AMM 33-51-332- 001-002.SDR CALA2017080802545Battery · no testEPSU EXT LOAD EMERGENCY AND EPSU BATTERY FAULTS WHEN PERFORMING THE EMERGENCY LIGHTS TEST. REPLACED CENTER RT EPSU BATTERY IAW AMM 33-51-38.SDR CALA2017080802541Lamp · inoperativeEMERGENCY EXIT LIGHT INOPERATIVE AFT OF LT EXIT HATCH EXTERIOR. REPLACED THE LAMP, OPS CHECKED GOOD.
Back to JASC 3350