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 AALA201704189012Lens · missingR2 DOOR HAS EXIT COVER MISSING. INSTALLED NEW EXIT COVER AT 2R DOOR.SDR SWAA2017041913227Sign · looseMIDDLE CABIN EXIT ROW SIGN LOOSE. SECURED THE SIGN IAW SIP.SDR SWAA2017041913206Battery Pack · inoperativeLEFT AFT WING LOWER EMERGENCY LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW WDM AND AMM.SDR FDEA201704171227Power Supply · failedEMER LT BATT 1 LOW DURING EMER LIGHT TEST, TEST FAILED. REMOVED AND REPLACED EMERGENCY EXIT LIGHTS POWER SUPPLY PER AMM 33-51-01-4. OPS CHECKED GOOD. A/C OK FOR SERVICE.SDR AALA201704189007Battery · no testWHILE ACCOMPLISHING J/C 33C22033002 EMERGENCY LIGHT OPS TEST, BATTERY 15WL FAILED. REPLACED BATTERY 15WL FOR EMERGENCY LIGHTS. AIRCRAST WAS GROUNDED.SDR AALA201704189005Battery · no testEPSU BATTERY 12WL FAILED EPSU TEST IAW J/C 33C22033002. REPLACED EPSU BATTERY 12WL. AIRCRAFT WAS GROUNDED.SDR AALA201704189004Battery · failedEPSU BATTERY 17WL AT POSITION L4 FAILED EPSU TEST IAW J/C 33C22033002. REPLACED THE BATTERY 17WL. AIRCRAFT WAS GROUNDED.SDR AALA201704189003Battery · no testEPSU BATTERY 16WL AT POSITION R3 FAILED EPSU TEST IAW J/C 33C22033002. REPLACED THE BATTERY. AIRCRAFT WAS GROUNDED.SDR AALA201704189002Battery · failedEPSU BATTERY 11WL AT POSITION 1L FAILED EPSU TEST IAW J/C 33C22033002. REPLACED THE BATTERY. AIRCRAFT WAS GROUNDED.SDR DALA2017041803154Battery Pack · inoperativeCOCKPIT AND GALLEY EMERGENCY LIGHTS INOPERATIVE. REPLACED THE BATTERIES IN THE EMERGENCY LIGHT MODULE. CHECKED GOOD.SDR CALA2017041701042Light · unsecureROW 34ABC SEAT EMERG LITE HANGING OUT. R&R EMERG LITE ASSY. OPS CHK OK ITEM CLRD.SDR CALA2017041701037Lens · missingLENS IS MISSING FROM EMERGENCY LIGHT ON CEILING AT 32B. REPLACED LENS.SDR CALA2017041701036Light · inoperativeDOOR 4L LARGE INTERIOR DOOR MOUNTED EEL LIGHT INOP. REPLACED 4L LARGE INTERIOR DOOR MOUNTED EEL LIGHT, OPS CHECK GOOD.SDR CALA2017041701035Light · inoperativeEMERGENCY EXIT LIGHTING FLOOR ILLUMINATION DOES NOT ILLUMINATE AT MED 5R (SQUARE LIGHT ASSY LOCATED IN CEILING). RELAMPED AND TESTED OKAY REF AMM 33-51-00-501 INSPECTED EMERGENCY EXIT LIGHT AT DOOR (R5) TESTED GOOD REF MM 33-51-00-501.SDR CALA2017041701034Light · inoperativeEXTERIOR EMERGENCY SLIDE LITE INOP AT DOOR 3L. RELAMPED LIGHT CHEEKS NORMALSDR CALA2017041701031Power Supply · faultyEMERGENCY LIGHT TEST FAILED, MSG "EPSU BATTERY AFT L" DISPLAYED ON CIDS. REPLACED EPSU PER AMM 33-51-38. EMERGENCY LIGHT TESTED OK PER AMM TASK 33-51-38-400-001-A, MESSAGE CLEAR.SDR CALA2017041701029Warning System · false activationON 2 SERVICE CHECK. DURING EMERGENCY LIGHTS OPS CHECK PTP DISPLAYED EPSU INT LOAD EMER L FAULT. WAITED A FEW HOURS. ACCOMPLISHED OPERATIONAL TEST OF EMERGENCY LIGHTS REF MM 33-51-00, TEST OK.SDR CALA2017041701045Fuse · blownEMERGENCY EEL LITES INOP ROWS 15-21. ROW 20L AND 20R EMERGENCY EXIT SIGN LITES INOP. REPLACED BLOWN FUSES, CHECKS NORMAL.SDR CALA2017041701044Cover · looseEMERGENCY EXIT SIGN BROKEN OFF, MISSING A LATCHING MECHANISM. RE-INSTALLED OVERHEAD EMERGENCY EXIT SIGN COVER. OK TO CONTINUE.SDR CALA2017041701041Battery · discharged2 SEGMENTS OF EMERGENCY LIGHTS OUT. R&R BATTERY IN AFT GALLEY AND UNDER 8TH WINDOW FROM EMERGENCY EXIT. OP CHECK GOOD. REF AMM 33-51-06.SDR CALA2017041701040Light · inoperativeEMERGENCY EXIT LIGHTS UNARMED LIGHT ON OVERHEAD PANEL HAS 1 BULB INOP RELAMPED, OPS CHECK OK.SDR AALA20170417001Battery · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHTS AT R4/L4 DOORS AND SEAT MOUNTED ESCAPE PATH LIGHTS AT SEATS 26D-36D ARE VERY DIM. REMOVED AND REPLACED BATTERY PACK AT L4 DOOR IAW AMM 33-51-07. OPERATIONAL CHECK GOOD.SDR QXEA2017041700271Lens · looseTYPE II/III DOOR EXIT LIGHT COVER NEED TO BE REATTACHED. REMOVED AND REPLACED TYPE II/III DOOR EXIT (EMERGENCY) BRACKET AND LENS. OPS CHECK GOOD NO FURTHER DEFECTS NOTED.SDR SWAA2017041713149Lens · crackedLEFT EMERGENCY LIGHT LENS CRACKED AT ROW 14. R & R THE LENS IAW AMM.SDR SWAA2017041713143Lens · crackedL/H EMERGENCY LIGHT LENS CRACKED BETWEEN ROWS 15 TO 27. R & R THE LENS IAW AMM.SDR DALA2017041703107Light · inoperativeEMERGENCY LIGHTS BETWEEN ROWS 25 AND 32 WONT COME ON. TROUBLESHOT IAW WDM 33-51-12 AND WDM 33-51-11. FOUND B5-106 AND B5-104 BAD. R & R IAW AMM 33-52.SDR MASA2017041712746Lamp · inoperativeEMERGENCY LIGHT ROW 12AC INOPERATIVE. REPLACED THE LAMPS.SDR AALA201704199026Power Supply · no testFOUND DURING AN EMERGENCY LIGHT TEST BATTERY, EMERGENCY POWER SUPPLY UNIT (12WL) EXIT RIGHT FAULT. REPLACED EPSU IAW AMM 33-51-38.SDR AALA201704179063Lens · brokenEMERGENCY EXIT LIGHT L1 DOOR BROKEN OFF LOWER FASTNER. REPLACED THE L1 DOOR EMERGENCY LIGHT LENS IAW MM 33-51-13.SDR AALA201704179062Lens · brokenEMERGENCY EXIT LIGHT R1 DOOR BROKEN OFF LOWER FASTNER. REPLACED THE EMERGENCY LIGHT LENS IAW MM 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR REXA2017041600524Bulb · inoperativeLEFT EMERGENCY LIGHT FWD OF EMERGENCY EXIT DOOR IS INOPERATIVE. EXTERIOR EMERGENCY LIGHT 5. REMOVED AND REPLACED THE BULBS IAW AMM 33-51-21, OPS CHECKED GOOD.SDR DALA2017041903252Lens · missingDURING INSPECTION FOUND EMERGENCY CLEAR AISLE LIGHT LOCATED ON RIGHT HAND AFT LAV LENS MISSING. MAINTENANCE INSTALLED LENS ON AISLE EMERGENCY LIGHT, RT AFT LAV, FWD LIGHT. SYS CK GOOD.SDR SIMA20170416002Light · inoperativeBULB OUT IN EMER EXIT SIGN AT LEFT OVERWING EXIT, FLOOR LEVEL. INSPECTED EMERGENCY LIGHTS. THEY ALL WORK. OPS CHECK GOOD. NO DAMAGE NOTED AT THIS TIME.SDR AALA201704189029Light · missingEXIT SIGN MISSING RIGHT SIDE FORWARD GALLEY. REMOVED AND REPLACED LIGHT ASSEMBLY L1186 IN FWD GALLEY R1 DOOR PER AMM 33-51-00. OPS CHECKED NORMAL.SDR AALA201704189028Guard · out of positionEMERGENCY EXIT LIGHTS GUARD BLOCKS THE ACTUAL SWITCH FROM FUNCTIONING. REPLACED SWITCH GUARD. EMERGENCY LIGHTS OP CK GOOD IAW AMM 33-51-00. THE AIRCRAFT WAS NOT GROUNDED.SDR SWAA2017040913205Lamp · inoperativeLEFT OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMPS LIGHT IAW MM.SDR AALA201704179041Light · inoperativeSEAT MOUNTED EMERGENCY LIGHTS AT 8R INOPERATIVE. REPLACED THE EMERGENCY LIGHTSDR AALA201704179040Light · inoperativeSEAT MOUNTED EMERGENCY LIGHT AT 34L INOPERATIVE. REPLACED SEAT MOUNTED EMERGENCY LIGHT.SDR FDEA201704161224Battery Pack · dischargedRT EMERGENCY LIGHTS INOP. REMOVED AND REPLACED RT EMERGENCY LIGHT BATTERY PACK, REF WDM 33-51-12 AND AMM 33-51-07-2. OPS CHECK GOOD.SDR FDEA201704161205Battery Pack · dischargedRT EMERGENCY LIGHTS INOP. REMOVED AND REPLACED RT EMERGENCY LIGHT BATTERY PACK, REF WDM 33-51-12 AND AMM 33-51-07-2. OPS CHECK GOOD.SDR SWAA2017041813201Cover · detachedRIGHT OVERWING EXIT ROW SIDEWALL LIGHT COVER FELL OFF. INSTALLED THE COVER IAW MM.SDR AALA201704179045Battery · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY FLASHLIGHT AT FORWARD FLIGHT ATTENDANT STATION HAS BEEN INSTALLED INCORRECTLY AND ONE CANNOT SEE THE STATUS LIGHT INDICATION. REPLACED FLASHLIGHT BATTERY.SDR AALA201704179021Lens · detachedC1 EMERGENCY SEAT LIGHT COVER BROKE OFF. ATTACHED THE LENS TO THE EMERGENCY LIGHT.SDR HALA2017041700155Light · unsecureROW 17A EMERGENCY LIGHT NOT SECURE. SECURED THE EMERGENCY LIGHT.SDR DALA2017041703106Battery Pack · inoperativeTAIL CONE EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACKS IAW AMM 33-53.SDR DALA2017041703077Lens · missingDURING INSPECTION, FOUND EMERGENCY LIGHT LENS MISSING. MAINTENANCE REPLACED LIGHT ASSY AND LENS IAW AMM 33-31. OPS NORMAL.SDR DALA2017041700154Battery · no testDURING A EMERGENCY LIGHTS TEST, A FAULTED 17WC BATTERY WAS FOUND. REPLACED THE BATTERY.SDR AALA201704179031Light · brokenEMERGENCY SEAT MOUNTED LIGHT AT SEAT 14C BROKEN. REMOVED AND REPLACED EMERGENCY LIGHT.SDR AALA201704179030Light · brokenEMERGENCY SEAT MOUNTED LIGHT AT SEAT 8C BROKEN. REMOVED AND REPLACED EMERGENCY LIGHT.SDR AALA201704179024Lens · missingL4 DOOR AFT GALLEY EXIT LENS COVER MISSING. INSTALLED NEW EXIT LENS COVER.
Back to JASC 3350