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 DALA2016120709672Fuse · blownDURING INSPECTION FOUND L2 DOOR EMERGENCY LIGHT IS INOPERATIVE. MAINTENANCE FOUND BATTERY POWER PACK M1673 AT FAULT. R&R BATTERY POWER PACK FUSE PER AMM 33-51-06. OPS CKS OK.SDR AALA20161207014Lens · looseAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT AT R1 DOOR HAS A LOOSE LENS COVER. SECURED LENS COVER IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20161207013Battery · faultyAIRCRAFT GROUNDED. OVERHEAD EMERGENCY EXIT LIGHTS ROW 23 THROUGH 27 COME ON WITH BATTERY SWITCH IN THE OFF POSITION. REMOVED AND REPLACED BATTERY ASSEMBLY IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20161207012Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY ESCAPE PATH FLOOR PROXIMITY LIGHT AT SEAT 9G IS MISSING LENS. REPLACED LENS IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20161207011Lens · brokenAIRCRAFT NOT GROUNDED. EMERGENCY ESCAPE PATH FLOOR PROXIMITY LIGHT AT SEAT 15D HAS A BROKEN LENS. REMOVED AND REPLACED LENS IAW AMM 33-50-00. OPERATIONAL CHECK GOOD.SDR DALA2016120709661Charger · inoperativeEMERGENCY LIGHTS INOP FROM 30G-37G. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY CHARGER AT SEAT 30G.SDR UIEA2016112200865Battery Pack · inoperativeEMERGENCY LIGHTS FROM SEAT ROW 29 TO 42 INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-07-422.SDR UIEA2016120600990Light · inoperativeL2 DOOR EMERGENCY EXIT LIGHT IS INOPERATIVE. REMOVED AND REPLACED L2 DOOR EMERGENCY EXIT LIGHT IAW AMM 33-51-10.SDR REXA2016120602345Lens · brokenDURING WALK AROUND FOUND BULB OUT AND LENS ASSEMBLY BROKEN ON EXTERIOR EMERGENCY LIGHTS. REMOVED AND REPLACED BOTH EMERGENCY LIGHT BULB AND LENS ASSEMBLY IAW AMM 33-51-15. REMOVED AND REPLACED LENS AS REQUIRED. OPS CHECK GOOD.SDR AALA20161206017Housing · brokenAIRCRAFT WAS IN BASE MAINTENANCE. L1 LOWER EXIT MARKER HOUSING IS BROKEN. REMOVED AND REPLACED EXIT MARKER IAW AMM 33-51-13. OPERATIONAL CHECK NORMAL.SDR AALA20161206016Housing · brokenAIRCRAFT WAS IN BASE MAINTENANCE. R1 LOWER EXIT MARKER HOUSING IS BROKEN. REMOVED AND REPLACED EXIT MARKER IAW AMM 33-51-13. OPERATIONAL CHECK NORMAL.SDR AALA20161206002Portable Light · dimAIRCRAFT WAS NOT GROUNDED. INTERIOR PORTABLE EMERGENCY LIGHT BY FORWARD ENTRY DOOR TESTED DIM. REMOVED AND REPLACED PORTABLE LIGHT ASSEMBLY IAW 33-53-00.SDR DALA2016120609592Light · intermittentTHE PILOT DISCOVERED THAT THE EMERGENCY EXIT LIGHTS AT THE GALLEY DOOR AND THE FRONT OF THE FIRST CLASS SECTION OF THE CABIN WERE INTERMITTENT IN OPERATION. MAINTENANCE COULD NOT DUPLICATE THE PROBLEM AND SIGNED IT OFF AS NTF.SDR ASAA2016120521275Lens · missingFLOODLIGHT ON AFT WINDSCREEN ADJACENT TO LAVATORY D IS MISSING THE LENS. ACFT GROUNDED. REPLACED THE LENS AND TESTED THE LIGHT ASSEMBLY IAW AMM 33-51-01-960-801. OPS NORMAL.SDR SIMA20161205002Light · inoperativeDURING OPERATIONAL CHECK OF THE EMERGENCY LIGHTING SYSTEM, FOUND PAX DOOR EMERGENCY LIGHT INOP. AIRCRAFT WAS REMOVED FROM SERVICE FOR IMBV INSPECTION AND WILL BE RETURNED TO SERVICE AFTER IMBV INSPECTION. REMOVED AND REPLACED PAX DOOR EMERGENCY LIGHT ASSEMBLYSDR DALA2016121309823Lens · damagedEMERGENCY EXIT COVER LENS DAMAGED. REPLACED.SDR QXEA2016120900791Power Supply · malfunctionedEMERGENCY POWER SUPPLY PS1 ILLUMINATE AFTER POWER TURNED OFF & SWITCH IN THE OFF POSITION. R & R THE POWER SUPPLY IAW AMM 33-51-01-000/400-801. OPS CHECKED GOOD.SDR DALA2016120909725Lens · missingDURING INSPECTION, FOUND THE LENS MISSING FROM EMERGENCY AISLE LIGHT ABOVE 4B-4C . MAINTENANCE REPLACED THE LENS. ACFT OK FOR SERVICE.SDR SWAA2016120710271Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK M1672 FAILED CAPACITY CHECK. R&R BATTERY PACK PER AMM.SDR SWAA2016120710258Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK M1669 FAILED CAPACITY CHECK. R&R BATTERY PACK PER AMM.SDR DALA2016120609662Lens · missingEMERGENCY LIGHT LENS MISSING SEAT 2B, REPLACED LENSSDR DALA2016120709663Light · damagedEMERGENCY SEAT 29D MOUNTED LIGHTING DAMAGED, RE-INSTALLED LIGHT COVER.SDR AALA20161207007Sign · looseAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN BETWEEN SEATS 21H AND 21J IS LOOSE. REPEAT WRITE-UPS. SECURED EXIT SIGN. OPERATIONAL CHECK GOOD.SDR AALA201612069011Housing · brokenFLOOR LIGHT CAP ASSEMBLY DROPPED OUT OF SEAT 16ABC. REPLACED EMERGENCY LIGHT HOUSING IAW CMM 25-22-52.SDR AALA201612069010Lens · missingEMERGENCY LIGHT ON CEILING PANEL AT ROW 15 MISSING LENS. REPLACED THE LENS IAW AMM 33-20-00.SDR AALA201612069007Lens · missingMISSING EXIT LIGHT LENS. REPLACED THE LIGHT LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR DALA2016120609643Battery Pack · no testOVERWING EMERGENCY LIGHT FAILED DURING CHECK. EMERGENCY LIGHTS BATTERY PACK WAS REPLACED IAW AMM 33-53-00.SDR AALA20161206023Light · inoperativeAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT AT ROW 24 IS INOPERATIVE. REMOVED AND REPLACED LIGHT IAW AMM 33-51-03. OPERATIONAL CHECK GOOD.SDR AALA20161206022Lens · brokenAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT IN AFT GALLEY HAS A BROKEN LENS COVER. REPLACED LENS COVER. OPERATIONAL CHECK GOOD.SDR AALA20161205004Battery · dischargedAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY BATTERY ASSEMBLY B5-107 FAILED TEST. REMOVED AND REPLACED BATTERY ASSEMBLY IAW AMM 33-53-00.SDR SWAA2016120610255Lens · looseLT OVERWING EXIT INDICATOR LENS LOOSE. SECURED LENS IAW SIP.SDR SWAA2016120610244Sign · detachedOVERHEAD AISLE EMERGENCY EXIT SIGN DETACHED FROM ABEAM EXIT ROW. SECURED SIGN PER MM.SDR QXEA2016120600783Sign · looseLOWER EXIT SIGN ON FORWARD EMERGENCY EXIT DOOR IS LOOSE. SECURED THE SIGN. NO FURTHER DEFECTS NOTED. RETURNED TO SERVICE.SDR CALA2016120501034Battery Pack · dischargedTESTED EMERG LIGHTS ON FAP. GOT MSG "EPSU UNIT AFT L" PER TSM 33-51-00-810-801-A, NEED TO REPLACE BATTERY PACK AND BATTERY. PN 3214-54-10 AND 3214-31. REMOVED AND REPLACED AFT BATTERY PACK AND AFT BATTERY IAW AMM 33 -51-38. OPS NML.SDR CALA2016120501033Epsu · faultyEMERGENCY LIGHT TEST FAULTED EPSU BATTERY EMER. REMOVED FAULTY EMER BATT AT RT O/W REF MM33-51-38. INSTALLED EPSU BATTERY REF MM 33-51-38-000. OP CHECK NORMALSDR CALA2016120501032Ballast · faultyRT FWD EMERGENCY EXIT DOOR ILLUMINATING LIGHT INOP. REMOVED AND REPLACED BALLAST OPS CHECK NORMAL IAW MM 33-21-00-96 0-805 MEL REMOVED ACFT OK TO CONTINUE .SDR CALA2016120501031Light · inoperativeDOOR 1L EMERGENCY EXIT SIGN HAS BURNT BULB. INSTALLED NEW LIGHT LENS BULB OPS CHECKS GOOD.SDR CALA2016120501030Light · inoperativeAFT GALLEY CEILING PANEL OVERHEAD EMERGENCY LIGHT ASSY HAS 1 EA BULB INOP. REPLACED LAMP AT AFT GALLEY CEILING PANEL OVERHEAD LIGHT ASSY. OPS CHECK GOOD IAW AMM33-51-01-960-801.SDR CALA2016120501029Light · inoperativeRIGHT AFT SLIDE/OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LAMP FOR R/W AFT OVERWING EMERGENCY EXIT LIGHT, OPS CHECK GOOD IAW AMM 33-51-04-960-801.SDR CALA2016120501027Battery Pack · dischargedEEL LIGHTS BETWEEN ROWS 22-29 INOP. REPLACED CHARGER AND BATTERY PACK AT M1670. OPS CHECKED OK.SDR CALA2016120501025Light · inoperativeSEAT 36ABC EEL AISLE LIGHT INOP. REPLACED SEAT 36ABC AISLE EEL WHITE LIGHT, REF PATHFINDER EMERGENCY ESCAPE PATH LIGHTING SYSTEM DRAWING BR2013-P-7572CO-5 REV B. OPS CHECK GOOD.SDR CALA2016120501024Battery Pack · dischargedEMERGENCY EXIT LIGHTS OUT FROM ROW 31 AFT OUT. REPLACED M736 EMERGENCY POWER SUPPLY CHARGER AND BATTERY PACK, REF AMM 31-51-07. OPS CHECK OF EMERGENCY ESCAPE LIGHT SYSTEM, INCLUDING ALL SEATS GOOD.SDR CALA2016120501022Light · inoperativeR1 AND LEFT O/W SECOND FROM AFT EMERGENCY LIGHTS ARE INOP. RELAMPED OPS CHECK GOOD REF AMM 33-51-06.SDR CALA2016120501021Light · malfunctionedFLOOR EMERG LIGHTING IN FRONT OF EMERG EXITS STAYS ILLUMINATED AT ALL TIMES. ACCOMPLISHED EMERG LIGHT TEST REF MM33-51-00, ALL TEST PASSED, NO FAULTS FOUND.SDR CALA2016120501020Light · faultyMID LAV EMERG LIGHT IS FLASHING. EMERGENCY LIGHTS OPS TEST C/O IAW AMM 33-51-00 SATIS.SDR CALA2016120501014Light · inoperativeSEAT 24 ABC AISLE EMERGENCY LIGHT DOES NOT ILLUMINATE. REMOVED AND REPLACED LIGHT ASSY AND OPS CHECK GOOD ALL IAW AMM 33-51-11.SDR CALA2016120501013Battery Pack · dischargedEMERGENCY EXIT LIGHTS INOPERATIVE AT SEATS 22 - 25 ABC. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-06. OPS CHECKED GOOD IAW AMM 3 3-51-00.SDR CALA2016120501035Lens · defectiveEMERGENCY PATH LIGHT AT ROW 2B INOP. REPLACED LENS CAP AND CHECKED LIGHT OK.SDR CALA2016120501023Light · inoperativeMID LAV EMERGENCY LIGHT INOP RELAMP. OPS CK GOOD.SDR MASA2016120512529Bulb · inoperativeSERVICE DOOR EMERGENCY LIGHT HAD ONE BULB INOPERATIVE.
Back to JASC 3350