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 SWAA2018020819571Lens · brokenAFT GALLEY EMERGENCY LIGHT LENS BROKEN. R & R THE LENS SIP.SDR AALA20180203004Light · damagedEMERGENCY EXIT LIGHT ASSEMBLY AT THE R4 DOOR IS DAMAGED. REMOVED AND REPLACED THE EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA20180203003Light · brokenEMERGENCY LIGHT AT AFT GALLEY DOOR IS BROKEN AND DAMAGED. REMOVED AND REPLACED THE EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-01. OPS CHECKED GOOD.SDR IPXA2018020526232Power Supply · inoperativeEMERGENCY LIGHTS FAILED TO TEST. R & R THE POWER SUPPLY IAW MM 33-51-01. PERFORMED AN OPS CHECK PER MM 33-51-01-700-802. SYSTEM WORKS NORMALLY.SDR YENA201802020060Power Unit · inoperativeDURING HEAVY MAINTENANCE, INOP ELPU RT SIDE AT AFT GALLEY AREA; REPLACED EMERGENCY LIGHT POWER UNIT AS PER AMM 33-50-01-400-801-A AND PERFORMED OPERATIONAL TEST IS OK AS PER AMM 33-50-01-710-801-A AND OPERATIONAL TEST OF THE EMERGENCY LIGHT IS OK AS PER AMM 33SDR AALA201802069011Light · intermittentTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHTS AT L2 DOOR INTERMITTENT. RESET CIDS AND PERFORMED EMERGENCY POWER SUPPLY UNIT TEST. NO FAULTS PER AMM 33-50-00.SDR SIMA20180202003Power Supply · failedLEFT AND RIGHT OVERWING EXTERNAL EMERGENCY LIGHTS FAILED TO ILLUMINATE. TROUBLESHOT IAW WM 33-50-50, AND R 7 R THE NR 4 EPSU IAW AMM 30-50-04. OPS CHECKED GOOD. BATTERY CHARGER ASSY.SDR SIMA20180202004Sign · inoperativeEXIT SIGN ABOVE THE FLIGHT ATTENDANT SEAT IS INOPERATIVE. REMOVED AND REPLACED THE SIGN, OPS TESTED GOOD IAW AMM 33-50-00.SDR DALA2018020300667Power Supply · inoperativeL1 DOOR EMERGENCY LIGHT EPSU INOPERATIVE. REPLACED THE EPSU.SDR CALA2018020200459Light · unknownFA ALERTED COCKPIT THAT THE EMERGENCY EXIT LIGHTS ILLUMINATED FOR A MINUTE. CYCLED AIRCRAFT POWER, OP TEST EMERGENCY LIGHT SWITCH IN THE FLIGHT DECK, OP CHECKED GOOD.SDR CALA2018020200457Lens · missingEMERGENCY LIGHTING LENS COVER IS MISSING AT AFT SIDE OF COAT CLOSET JUST FORWARD OF SEAT 1,B. REPLACED LENS COVER ON EMERGENCY LIGHT AT AFT SIDE OF COAT CLOSET.SDR CALA2018020200456Battery · dischargedROW 9-14 EMERG LIGHT INOP. REPLACED BATTERY, OPS CKED NORMAL.SDR CALA2018020200455Lens · missingEMERGENCY LIGHT LENS AT FWD COAT CLOSET DAMAGED. SMALL LENS MISSING, LIGHT WORKS. INSTALLED LENS.SDR CALA2018020200454Lens · brokenEMERGENCY EXIT LIGHT AFT OF FIRST CLASS CLOSET COVER BROKEN OFF LIGHT WORKS OK. REPLACED LENS, OK TO CONTINUE.SDR CALA2018020200452Lens · damagedSEAT 30ABC AISLE EMER EXIT LIGHT IS PUSHED BACK INTO SEAT ASSY. REPLACED EMER EXIT LIGHT LENS ASSY AT SEAT 30 ABC REF AMM 33-51-11-960-802. OPS CHECK GOOD. INSPECTED LENS INSTALLATION REF AMM 33-51-11.SDR CALA2018020200450Lens · brokenSEAT MOUNTED EMERGENCY LIGHT LENSES BROKEN AT SEATS 15C & 23C. REPLACED TRACK LIGHT LENSES AT SEATS 15C & 23C. OPS CK NORMAL.SDR CALA2018020200449Light · inoperativeEMERGENCY LIGHT INOP AT AFT RT OVERWING EXIT. RELAMPED RT AFT OVERWING EXIT LIGHT OPS CHECKS GOOD.SDR CALA2018020200448Light · inoperativeRT OVERWING FWD EXTERIOR EMERG EGRESS LIGHT IS INOP RELAMPED, OPS CK NORMAL REF AMM33-00-00.SDR CALA2018020200446Power Supply · inoperativeRT EXTERIOR AFT OVERWING EXIT EMERGENCY LIGHT AND SLIDE ESCAPE LIGHT WILL NOT COME ON DURING TEST. REPLACED POWER SUPPLY REF AMM 33-51-06. OPS CHECKED OK. INSPECTED O/W EXIT LIGHT REF AMM 33-51-06.SDR CALA2018020200437Light · inoperativeRIGHT FWD EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED IAW WDM 33-51-12, OPS CHECKED OKSDR CALA2018020200435Battery Pack · inoperativeEMERGENCY POWER SUPPLY M33406 BATTERY PACK FOUND INOPERATIVE. THE BATTERY PACK WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR CALA2018020200434Battery Pack · dischargedEMERGENCY LIGHT BATTERY PACK CAPCITY LOW. THE BATTERY PACK WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR CALA2018020200432Lamp · inoperativeDURING AN A CHECK, FOUND SEAT 8A EMERGENCY CELLING LIGHT INOPERATIVE. REPLACED THE LAMPS AND TESTED OK IAW AMM 33-51-00 .SDR CALA2018020200431Lamp · inoperativeDURING AN A CHECK, FOUND THE R2 DOOR EMERGENCY CEILING LIGHT INOPERATIVE. REPLACED THE LAMPS AND TESTED OK IAW AMM 33-51-00.SDR CALA2018020200445Lens · defectiveEMERGENCY FLOOR PROXIMITY LIGHT DOES NOT TURN ON 28C. REPLACED LENS OPS CHECKS GOOD.SDR CALA2018020200442Light · missingDOOR 1L SLIDE LIGHT IS MISSING. INSTALLED MISSING LIGHT.SDR CALA2018020200440Lens · missingEMER LIGHTS UNARMED LITE COVER MISSING. REPLACED CAP ASSY. OPS CHECKS GOOD.SDR CALA2018020200433Light · inoperativeMED 2L EXTERIOR EMERGENCY LIGHT INOP RELAMPED, OPS CHECKS GOOD. REF AMM 31-51-04-960-801SDR R61A201802020121Light · damagedFWD RT EMERGENCY LIGHT DAMAGED. R & R THE EMERGENCY LIGHT IAW AMM 33-50-21.SDR MASA2018020212952Light · inoperativeROW 9 CEILING EMERGENCY LIGHT INOPERATIVE.SDR BUEA20180202001Battery Pack · dischargedDURING AIRCRAFT PREFLIGHT, THE CREW REPORTED NONE OF THE EMERGENCY LIGHTS ILLUMINATED. THE CREW UTILIZING THE APU GENERATOR AND THE EMERGENCY ARM SWITCH WAS ABLE TO RECHARGE THE FOUR BATTERIES AND GET ALL EMERGENCY LIGHTS ILLUMINATED.SDR SWAA2018021519782Light · inoperativeRIGHT AFT GALLEY AISLE EMERGENCY LIGHT STRIP INOPERATIVE. R & R THE EMERGENCY LIGHT STRIP IAW AMM.SDR AALA20180202010Lens · brokenL1 DOOR EXIT SIGN LENS LOWER FASTENER BROKEN. REPLACED THE SIGN LENS IAW AMM 33-51-13.SDR AALA201802079015Unknown · malfunctionedTHE AIRCRAFT WAS NOT GROUNDED. ENTRY DOOR FLOOR EMERGENCY EXIT LIGHT STUCK IN THE ON POSITION AND VERY HOT TO THE TOUCH. CHECKED EMERGENCY LIGHT AT EXIT DOOR. COULD NOT DUPLICATE STUCK ON CONDITION PER MM 33-51-14. REATTACHED LENS TO FLOOR LIGHT AT ENTRY DOSDR AALA201802079014Lens · brokenTHE AIRCRAFT WAS NOT GROUNDED. EXIT LIGHT AT LOWER LEFT SIDE OF FORWARD GALLEY DOOR IS DAMAGED. REPLACED BROKEN EMERG EXIT LIGHT LENS AT FWD GALLEY R1 DOOR PER AMM 33-51-00, OPS NORMAL.SDR SWAA2018020719553Battery Pack · failedBATTERY PACKS FAILED TEST AT LOCATION M0168. R&R BATTERY PACK PER AMM.SDR SWAA2018020719526Battery Pack · failedEMERGENCY BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01674. R&R BATTERY PACK PER AMM.SDR SWAA2018020719519Battery Pack · failedBATTERY PACKS FAILED TEST AT LOCATION M0166. R&R BATTERY PACK PER AMM.SDR DALA2018020100706Light · shortedSEATS 6-9D AND AISLE EXIT SIGNS AT ROW 16 ARE INOPERATIVE. FOUND LIGHT BULB IN LEFT AISLE EXIT SIGN 16A SHORTED AND REPLACED BULB AND POWER SUPPLY. SYSTEM OPERATION IS NORMAL.SDR AALA201802029018Sign · damagedAIRCRAFT WAS NOT GROUNDED. L2 DOOR EXIT CEILING LIGHT WAS DAMAGED AND DETACHED FROM THE CEILING. MAINTENANCE ACCOMPLISHED REPAIR OF OVERHEAD AISLE EMERGENCY EXIT SIGN FORWARD OF DOOR 2L PER ENGINEERING AUTHORIZATION 277256. (SEE AALA201802029017)SDR AALA201802029023Battery Pack · no testEMERGENCY LIGHT POWER SUPPLY TEST FAILED. REMOVED AND REPLACED THE POWER SUPPLY BATTERY IAW AMM 33-51-38. OPS CHECKED GOOD.SDR DALA2018020200662Fuse · failedEMERGENCY LIGHTS INOPERATIVE AT ROW 1, 2, AND 3DC. FOUND A BAD FUSE IN THE POWER SUPPLY, REPLACED THE FUSE, OPS CHECKED GOOD.SDR AALA20180202002Power Supply · inoperativeFLIGHT CREW SEAT EGRESS LIGHTS INOPERATIVE. REPLACED THE POWER SUPPLY AT M33094 IAW AMM 33-51-06.SDR AALA201802029017Sign · looseEXIT SIGN, LEFT AISLE, JUST FORWARD OF THE L2 DOOR IS LOOSE. REPAIRED THE SIGN IAW ENGINEERING AUTHORIZATION 277256.SDR CALA2018020200402Battery Pack · dischargedR4 DOOR BATTERY PACK M33408 CAPACITY LOW. R4 DOOR BATTERY PACK M33408 REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR CALA2018020200401Battery Pack · dischargedDOOR R4 BATTERY PACK M33409 CAPACITY LOW. DOOR R4 BATTERY PACK M33409 REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR CALA2018020200400Battery Pack · dischargedL4 DOOR BATTERY PACK M33407 CAPACITY LOW. L4 DOOR BATTERY PACK M33407 REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR CALA2018020200399Battery Pack · dischargedDOOR R3 M33401 BATTERY PACK CAPACITY LOW. DOOR R3 M33401 BATTERY PACK REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR CALA2018020200398Battery Pack · dischargedDOOR R1 M33094 BATTERY PACK CAPACITY LOW. DOOR R1 M33094 BATTERY PACK REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR DALA2018020100027Power Supply · no testEPSU SYSTEM TEST FAILED. RESET EPUS AND REPLACED EPSU BATTERY 16WL.
Back to JASC 3350