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 MASA2018060613300Light · inoperativeROW 11 CEILING FLOOD LIGHT WAS INOPERATIVE.SDR AALA201806079017Light · failedTHE AIRCRAFT WAS NOT GROUNDED. PHOTOLUMINESCENT TEST COUPON FAILED. DUE TO REPORT TO ENGINEERING THAT THE PHOTOLUMINESCENT TEST COUPON HAS FAILED ACCOMPLISH LIGHT PATH REPAIRS PER EA 280866. REPLACED FIRST CLASS RIGHT SIDE STRIPS AND BUSINESS CLASS RIGHT SIDE SDR SWAA2018061122660Cover · defectiveAFT GALLEY LT EXIT LIGHT ASSEMBLY INOP. R&R COVER PER AMM.SDR SWAA2018061122633Lens · unsecureAFT FACING OVERWING CEILING EMERGENCY 'EXIT" LIGHT LENS FELL OFF. REINSTALLED LENS PER AMM.SDR 4TXA20180611002Battery Pack · no testEMERGENCY LIGHT, BATTERY PACK AT BS 670, RBL 68 FAILED A CAPACITY CHECK.SDR REXA2018060850473Bulb · inoperativeTWO BULBS INOPERATIVE FOR THE EMERGENCY LIGHTS. R & R IAW 33-51-03. CHECKED GOOD.SDR ASAA2018060754937Bulb · inoperativeROW 16F EMERGENCY EXIT OVERWING LIGHT WAS INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMP IAW AMM 33-20-00, OPS CHECKED OK.SDR AALA201806079012Charger · inoperativeONE LEFT OVERWING EMERGENCY LIGHT WAS INOPERATIVE. REPLACED THE CHARGER IAW AMM 33-51-00.SDR AALA201806076003Battery Pack · dischargedONE LEFT OVERWING EMERGENCY LIGHT WAS INOPERATIVE. REPLACED THE BATTERY PACK IAW AMM 33-51-00.SDR AALA201806076002Battery · dischargedAIRCRAFT WAS IN BASE MAINTENANCE. TWO LEFT OVERWING SLIDE EMERGENCY LIGHTS WAS INOPERATIVE. REPLACED THE BATTERY AT STA 1340 PER AMM 33-51-00.SDR AALA2018060769011Lens · missingONE EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS.SDR AALA2018060769032Lens · missingEMERGENCY LIGHT LENS MISSING, SEAT 3 LEFT. REPLACED THE LENS IAW AMM 33-51-11. OPS CHECKED GOOD.SDR DALA2018060763868Lens · missingEMERGENCY LIGHT LENS AT SEAT 27A WAS MISSING. INSTALLED A NEW LENS IAW AMM 33-51.SDR SWAA2018060622574Fuse · inoperativeR2 DOOR FLOOR PROXIMITY EMERGENCY LIGHT INOP. R&R FUSE PER AMM.SDR SWAA2018060622573Cover · unsecureRT SIDE AFT OVERWING EMERGENCY EXIT LIGHT COVER FELL OFF AT ROW 15. SECURED COVER PER SIP.SDR SWAA2018060622562Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01675. R&R BATTERY PER AMM.SDR SWAA2018060622561Battery Pack · failedAFT RT EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK. R&R BATTERY PACK PER MM.SDR SWAA2018060622560Battery Pack · failedAFT LT EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK. R&R BATTERY PACK PER MM.SDR SIMA201806065003Bulb · failedRIGHT OVERWING EXTERNAL EMERGENCY LIGHT FAILED TO ILLUMINATE. FOUND THE BULB TO BE SHATTERED. INSTALLED A NEW BULB AND OPS CHECKED GOOD IAW AMM 33-50-10.SDR KCSA201806051140Light · inoperativeUPPER DECK DOORS EMERGENCY LIGHTS FAILS TO ILLUMINATE.SDR DALA2018060503830Cover · looseEMERGENCY EXIT SIGN COVER LOOSE. RE-FITTED EMERGENCY LIGHT COVER.SDR MASA2018060513294Power Supply · disconnectedROW 14 EMERGENCY EXIT SIGNS WERE INOPERATIVE. CONNECTED THE POWER SUPPLY.SDR MASA2018060513293Power Supply · disconnectedROW 4 EMERGENCY EXIT SIGN WAS INOPERATIVE. CONNECTED THE POWER SUPPLY.SDR SWAA2018062022941Lens · crackedLT EMERGENCY LIGHT LENS CRACKED AT ROW 9. R&R LENS PER MM.SDR SWAA2018062022940Lens · crackedLT CLEAR EMERGENCY LIGHT LENS CRACKED ABOVE SEATS BETWEEN ROW 14 TO ROW 24. R&R LENS PER MM.SDR SWAA2018062022939Lens · crackedRT CLEAR EMERGENCY LIGHT LENS CRACKED ABOVE SEATS BETWEEN ROW 13 TO ROW 19. R&R LENS PER MM.SDR SWAA2018061822877Lens · crackedLT EMERGENCY LIGHT LENS CRACKED AT ROW 1. R&R LENS PER AMM.SDR SIMA2018061404016Light · crackedNR 7 FLOOR EMERGENCY LIGHT STRIP WAS CRACKED. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-12.SDR REXA2018060840470Bulb · inoperativeCEILING EMERGENCY FLOOD LIGHT NR 3 WAS INOPERATIVE. REPLACED THE BULB IAW AMM 33-51-16. OP CHECKED GOOD.SDR REXA2018060740467Light · missingFLOOR EMERGENCY LIGHT STRIP WAS MISSING AT ROW 12. REPLACED THE LIGHT STRIP IAW AMM 33-51-01.SDR REXA2018060740466Battery Pack · inoperativeEMERGENCY LIGHTS DO NOT REMAIN ON WHEN SELECTED. REMOVED AND REPLACED THE BATTERY PACKS IAW AMM 33-51-17. OPS TEST PASSED. ACFT OK FOR SERVICE.SDR AALA201806075006Battery Pack · inoperativeFLIGHT DECK EMERGENCY LIGHT WAS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK LIG5192 IAW AMM 33-51-00. OPS CHECKED OK.SDR AALA201806079016Charger · inoperativeTWO LEFT OVERWING SLIDE EMERGENCY LIGHTS WERE INOPERATIVE. REPLACED THE CHARGER AT BS 1340 IAW AMM 33-51-00.SDR AALA2018060769010Power Supply · inoperativeLEFT OVERWING EMERGENCY LIGHT INOPERATIVE. REPLACED 13WEL POWER SUPPLY IAW AMM 33-51-38.SDR DALA2018060753869Cover · missingROW 19 D, E, & F EMERGENCY LIGHT COVER WAS MISSING. INSTALLED A NEW COVER. OK FOR SERVICE.SDR AALA2018060769016Battery · no testEMERGENCY LIGHT POWER SUPPLY TEST FAILED MESSAGE. EPSU 13WL AFT LEFT. REPLACED THE POWER SUPPLY BATTERY IAW MM 33-51-38, OPS CHECKED GOOD.SDR SWAA2018060622584Fuse · inoperativeRT OVERWING EMERGENCY EXIT SIDEWALL IDENTIFIER INOP. R&R FUSE PER AMM.SDR SWAA2018060622558Light · inoperativeRT OVERWING EMERGENCY EXIT SIDEWALL IDENTIFIER INOP. R&R IDENTIFIER PER AMM.SDR SIMA201806064010Inverter · inoperativeEMERGENCY LIGHT IN ROW 3 (B+C SIDE) DID NOT WORK. REMOVED AND REPLACED THE INVERTER IAW AMM 33-50-11. OPS CHECKED GOOD. ACFT OK FOR SERVICE.SDR DALA2018060653857Sign · detachedON LANDING, THE L2 DOOR OVERHEAD EXIT SIGN FELL OFF. INSTALLED THE SIGN IAW AMM 33-51. NO FURTHER DEFECT NOTED. ACFT RETURNED TO SERVICE.SDR DALA2018060653856Light · inoperativeSEAT 4C MOUNTED EMERGENCY LIGHT WAS INOPERATIVE. THE EMERGENCY LIGHT RESET, LIGHT OPS CHECKED GOOD IAW AMM 33-52-00.SDR DALA2018060653855Sign · unsecureEXIT SIGN, MID SHIP WAS NOT SECURE. SECURED THE EXIT SIGN.SDR ASAA2018060544911Sign · missingEXIT SIGN NEAR THE L2 DOOR WAS MISSING. ACFT GROUNDED. REPLACED THE SIGN IAW AMM 33-51-01-960-8001, OPS CHECKED GOOD.SDR SWAA2018060522556Cover · brokenL1 DOOR EMERGENCY EXIT LIGHT COVER NEAR FLOOR BROKEN. R&R COVER PER AMM.SDR SWAA2018060522554Light · inoperativeL2 DOOR EXTERIOR EMERGENCY LIGHT INOP. R&R LAMP IAW MM.SDR AALA2018060769003Battery Pack · no testEMERGENCY LIGHT BATTERY PACK M1673 FAILED A FUNCTIONAL CHECK. REPLACED THE BATTERY PACK IAW 33-51-06. OPS CHECKED GOOD.SDR AALA2018060769002Battery Pack · no testEMERGENCY LIGHT BATTERY PACK M1671 FAILED A FUNCTIONAL CHECK. REPLACED THE BATTERY PACK IAW AMM 33-51-06. OPS CHECKED GOOD.SDR AALA201806069001Battery Pack · no testEMERGENCY LIGHT BATTERY PACK M1695 FAILED A FUNCTIONAL CHECK. REPLACED THE BATTERY PACK IAW AMM 33-51-06. OPS CHECKED GOOD.SDR AALA201806069026Battery Pack · no testEMERGENCY POWER SUPPLY BATTERIES FAULTED. MAINTENANCE REPLACED THE BATTERIES IAW AMM 33-51-38, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201806069025Battery Pack · no testEMERGENCY POWER SUPPLY BATTERIES FAULTED. MAINTENANCE REPLACED THE BATTERIES IAW AMM 33-51-38, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.
Back to JASC 3350