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 JJBA20190523013Sign · unsecureEMERGENCY EXIT SIGN AT 18D FALLING OFF. R&R AFT CENTER AISLE EXIT SIGN. OPS CHECK SAT.SDR SWAA2019052933150Lens · missingLT OVERHEAD EMERGENCY EXIT LIGHT LENSES MISSING BETWEEN BIN #8 TO BIN #9. R&R LENS IAW AMM.SDR DALA2019052303279Battery Pack · defectiveSHIP 661 FOUND BAD BATT ON EMERGENCY LIGHT TEST @ 12CDE-15CDE- NO LIGHTS. CORRECTIVE ACTION: R/R BAD BATTERY PACK IN OVERHEAD @12AB IAW AMM 33-51. (5827858)SDR SWAA2019052833086Battery Pack · dischargedALL FORWARD R/H EMERGENCY EXIT LIGHTS INOP AT LOCATION M1675. R&R BATTERY PACK IAW AMM.SDR SWAA2019052833085Battery Pack · dischargedFORWARD LT EMERGENCY EXIT LIGHTS INOP AT LOCATION M1674. R&R BATTERY PACK IAW AMM.SDR AALA201905239008Battery · weakAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS WHILE ACCOMPLISHING CARD 43C20033002, FOUND ALL EMERGENCY LIGHT POWER SUPPLIES COMPLETELY DISCHARGED BEFORE THE 15 MINUTE LIMIT. CARD REQUIRES ACCOMPLISHMENT WITH NEW BATTERIES. REMOVED AND REPLACED ALL EMERGENCY LIGHSDR AALA201905249012Battery · weakAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS WHILE ACCOMPLISHING CARD 43C20033002, FOUND ALL EMERGENCY LIGHT POWER SUPPLIES COMPLETELY DISCHARGED BEFORE THE 15 MINUTE LIMIT. CARD REQUIRES ACCOMPLISHMENT WITH NEW BATTERIES. REMOVED AND REPLACED ALL EMERGENCY LIGHSDR AALA201905249013Battery · weakAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS WHILE ACCOMPLISHING CARD 43C20033002, FOUND ALL EMERGENCY LIGHT POWER SUPPLIES COMPLETELY DISCHARGED BEFORE THE 15 MINUTE LIMIT. CARD REQUIRES ACCOMPLISHMENT WITH NEW BATTERIES. REMOVED AND REPLACED ALL EMERGENCY LIGHSDR AALA201905249014Battery · dischargedAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS WHILE ACCOMPLISHING CARD 43C20033002, FOUND ALL EMERGENCY LIGHT POWER SUPPLIES COMPLETELY DISCHARGED BEFORE THE 15 MINUTE LIMIT. CARD REQUIRES ACCOMPLISHMENT WITH NEW BATTERIES. REMOVED AND REPLACED ALL EMERGENCY LIGHSDR SWAA2019052432994Lens · missingL1 DOOR EMERGENCY EXIT LIGHT LOWER LENS MISSING DIRECTIONAL ARROW. R&R LENS PER AMM.SDR SWAA0224050132993Lens · unsecureRT OVERWING EMERGENCY EXIT SIGN FELL OFF MOUNT. SECURED LENS SIGN PER MM.SDR DALA2019052203164Light · inoperativeRIGHT AFT OVERWING EXIT HANDLE LIGHT HAS ONE BULB INOP, RELAMPED.SDR AALA201905239010Light · inoperativeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK EMERGENCY LIGHT INOPERATIVE. MAINTENANCE REPLACED FLIGHT DECK EMERGENCY LIGHT AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-00.SDR AALA201905239007Light · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT FIXTURE BROKEN AT LAVATORY L NEAR FLOOR. MAINTENANCE REPLACED EMERGENCY EXIT LIGHT PER AMM 33-51-13.SDR AALA201905239006Light · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT FIXTURE BROKEN AT LAVATORY D NEAR FLOOR. MAINTENANCE REPLACED EMERGENCY EXIT LIGHT PER AMM 33-51-13.SDR AALA201905239005Light · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT FIXTURE BROKEN AT DOOR R4. MAINTENANCE REPLACED EMERGENCY EXIT LIGHT PER AMM 33-51-13.SDR AALA201905239004Light · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT FIXTURE BROKEN AT DOOR L4. MAINTENANCE REPLACED EMERGENCY EXIT LIGHT PER AMM 33-51-13.SDR AALA20190522002Sign · brokenAIRCRAFT WAS NOT GROUNDED: R1 DOOR EMERGENCY LIGHT ASSEMBLY ON DOOR FRAME COVER, BROKEN. MAINTENANCE REPLACED EXIT SIGN PER AMM 33-51-13.SDR SWAA2019052332972Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R&R BATTERY PER AMM.SDR SWAA2019052332971Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER AMM.SDR SWAA2019052332964Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1668. R&R BATTERY PER AMM.SDR SWAA2019052332956Lens · missingEMERGENCY EXIT SIGN LOCATED ON CEILING CENTER OF AIRCRAFT MISSING LENS. INSTALLED LENS PER AMM.SDR JJBA20190522012Sign · detachedROW 18 EMERGENCY EXIT SIGN DETACHED. SECURED AS REQUIRED.SDR SIMA20190522001Light · inoperativeRT AFT OVERWING EMERGENCY EXIT LIGHT INOP. C/A-RAR RT AFT OVERWING EMERGENCY EXTERNAL LIGHT IAW AMM 33-50-10. OPC GOOD.SDR SIMA20190522003Light · not reportedEXTERNAL EMERGENCY LIGHTS OF THE RT SIDE FORWARD LOWER FAIRING - REMOVAL/ INSTALLATION. C/A-RAR EXTERNAL EMERGENY LIGHT IAW AMM TASK 33-50-10-04.SDR SIMA20190522004Light · inoperativeMAIN DOOR EMERGENCY LIGHT INOP. C/A-RAR MAIN DOOR EMERGENCY LT LAMP IAW AMM 33-50-06-000-801-A AND AMM 33-50-06-400-801-A. OPC GOOD. NO MORE DEFECTS NOTED AT THIS TIME. END.SDR QXEA2019052200215Battery Pack · dischargedFOUND CEILING EMERGENCY LIGHTS NEXT TO ROW 2, 6 AND FWD RIGHT EGRESS EMERGENCY LIGHT AND EXIT SIGNS NEXT TO ROW 2 ED TO BE INOP. REMOVED AND REPLACED #2 EMERGENCY LIGHT POWER SUPPLY UNIT BATTERY PACKS (LT AND RT) REF HONEYWELL CMM 33-50-72. DISASSEMBLY AND ASSSDR MASA2019052211870Light · inoperativeSVC DOOR EMERG EXIT LIGHTS INOP.SDR MASA2019052211869Light · inoperativeROW 18 EMER EXIT SIGN 1 BULB INOP.SDR AALA201905239012Light · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EMERGENCY PATH LIGHHT INOP AT SEAT 2D. NEW LIGHT ASSY INSTALLED, NO HELP. MAINTENANCE CURRENTLY TROUBLESHOOTING THIS EVENT. ITEM ON MEL. ***SUPPLEMENTAL TO UPDATE SECTION 4 AND SECTION 5. MAINTENANCE PERFORMED SATISFASDR SIMA20190521004Light · malfunctionedEMERGENCY LIGHT STRIPS 4 & 5 AND BOTH EMERGENCY EXIT SURROUND PANEL LIGHTS COME ON AND GO OUT. C/A-C/W EMERGENCY LIGHTING ADUJSTMENT/TEST IAW AMM 33-50-00. NO DEFECTS NOTED AT THIS TIME.SDR YENA201905210284Power Unit · failedFLT 535, SWF-FLL. LT AFT BOTTOM EXTERNAL EMERGENCY LIGHT INOP; R & R EMERGENCY LIGHT POWER UNIT 6, AS PER MM 33-50-01. ALL OPS/IND. NORMAL FOR LT AFT EXT. EMERGENCY LT PER MM 33-50-01-710-801-A/500.SDR ASAA2019052129446Lens · missingFLIGHT ATTENDANT REPORTS- MID CABIN EXIT SIGN ONE SIDE OF EXIT SIGN MISSING. GROUNDED - YES. REPLACED MID CABIN EXIT SIGN HOUSING & LENS PER AMM 33-51-01-960-801.SDR ASAA2019052129445Battery Pack · dischargedEXTERIOR EMERGENCY EXIT LIGHTS INOP AT: RT FWD OVERWING EXIT L2 DOOR & LEFT FWD OVERWING EXIT. GROUNDED - YES. REMOVED AND REPLACED POWER SUPPLY AND BATTERY PACK IAW AMM 33-51-06-960-806 AND 33-51-06-960-805. OPS CHECK GOOD IAW AMM 33-51-06-960-806 AND 33-51-0SDR ASAA2019052129444Battery Pack · dischargedINTERIOR EMERGENCY EXIT LIGHTS UNDER OVERHEAD BINS ARE INOP FROM ROW 3 TO ROW 12. GROUNDED - YES. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-51-06-960-805. OPS CHECK GOOD IAW AMM 33-51-06-960-805.SDR AALA201905229008Power Supply · inoperativeAIRCRAFT IN BASE VISIT: MAINTENANCE FOUND INOP EMERGENCY LIGHT EPSU-EMERGENCY POWER SUPPLY UNIT BATTERY PASSENGER CREW DOOR 843 IN PASSENGER CABIN (1 EA). MAINTENANCE REPLACED THE EMERGENCY POWER SUPPLY UNIT FIN 14WL IAW AMM 33-51-38-000-001-A.SDR SWAA2019052332979Battery · failedFLIGHT DECK TO OVERWING EXIT EMERGENCY EXIT LIGHT FAILED TO ILLUMINATED AT M1668. R&R BATTERY IAW AMM.SDR SWAA2019052332978Power Supply · failedFLIGHT DECK TO OVERWING EXIT EMERGENCY EXIT LIGHT FAILED TO ILLUMINATED AT M1669. R&R POWER SUPPLY IAW AMM.SDR SWAA2019052332977Power Supply · failedFLIGHT DECK TO OVERWING EXIT EMERGENCY EXIT LIGHT FAILED TO ILLUMINATED AT M1675. R&R POWER SUPPLY IAW AMM.SDR SWAA2019052332976Battery · failedFLIGHT DECK TO OVERWING EXIT EMERGENCY EXIT LIGHT FAILED TO ILLUMINATED AT M1669. R&R BATTERY IAW AMM.SDR SWAA2019052332975Battery · failedFLIGHT DECK TO OVERWING EXIT EMERGENCY EXIT LIGHT FAILED TO ILLUMINATED AT M1675. R&R BATTERY IAW AMM.SDR SWAA2019052332974Power Supply · failedFLIGHT DECK TO OVERWING EXIT EMERGENCY EXIT LIGHT FAILED TO ILLUMINATED AT M1674. R&R POWER SUPPLY IAW AMM.SDR SWAA2019052332973Power Supply · failedFLIGHT DECK TO OVERWING EXIT EMERGENCY EXIT LIGHT FAILED TO ILLUMINATED AT M1668. R&R POWER SUPPLY IAW AMM.SDR SWAA2019052332969Battery · dischargedFLIGHT DECK TO OVERWING EXIT EMERGENCY EXIT LIGHT FAILED TO ILLUMINATED AT M1674. R&R BATTERY IAW AMM.SDR SWAA2019052332957Battery Pack · lowLT BATTERY PACK M01669 HAD LOW OUTPUT. R&R BATTERY PACK PER AMM.SDR SWAA2019052332949Charger · inoperativeAFT LT EMERGENCY EXIT SIGN ABOVE ENTRY DOOR INOP. R&R CHARGER PACK ASSEMBLY PER AMM.SDR UIEA2019052104240Light · missingR2 DOOR RT GALLEY FLOOR EMER. LIGHT AND LENS MISSING. (<P>EMERGENCY LIGHT AND LENS REPLACED. OPS CHECK NORMAL IAW AMM 33-51-00.</P>)SDR UIEA2019052104242Power Supply · inoperativeDOOR 5R EMERGENCY LT POWER PACK M7924 INOP. (<P>REMOVED AND REPLACED 5R DOOR POWER SUPPLY M7924. OPERATIONAL CHECK NORMAL IAW AMM 33-51-00.</P>)SDR UIEA2019052104243Light · inoperativeSEAT 16H FLOOR EMERGENCY LIGHT INOP. (<P>REMOVED AND REPLACED EMERGENCY LIGHT LAMP. OPS CHECK NORMAL IAW AMM 33-51-00.</P><P><BR /></P>)SDR UIEA2019052104244Light · inoperativeSEAT 26AC HAS EMERGENCY LIGHT INOP. (<P>REMOVED AND REPLACED EMERGENCY LIGHT BULB. OPS CHK, TESTS NORMAL IAW AMM 33-51-00.</P>)
Back to JASC 3350