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 DALA2017090606645Sign · missingEXIT SIGN MISSING. FOUND THE SIGN AND SECURED BACK IN PLACE. OK FOR SERVICE.SDR ASOA201709062006Lamp · inoperativeRIGHT EXTERIOR OVERWING EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS. OPS CHECKED GOOD IAW AMM 33-51-15.SDR ASOA201709062005Lamp · blownLEFT EXTERIOR OVERWING EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-15. OPS CHECKED GOOD.SDR REXA2017090501010Light · missingFLOOR EMERGENCY LIGHT STRIP MISSING IN GALLEY. INSTALLED THE EMERGENCY LIGHT STRIP IAW AMM 33-50-00. OK FOR SERVICE.SDR SIMA20170905003Lamp · inoperativeCABIN EMERGENCY LIGHT IN OVERHEAD, SECOND FROM REAR INOPERATIVE. REMOVED AND REPLACED THE CEILING FLOOD EMERGENCY LIGHT LAMP IAW AMM 33-51-09. OPS CHECKED GOOD.SDR HALA2017090600232Sign · brokenEXIT SIGN AT THE R3 DOOR IS BROKEN AND HELD TOGETHER WITH BLUE TAPE. REMOVED EXIT SIGN.SDR AALA201709069019Cover · brokenAIRCRAFT WAS NOT GROUNDED. BROKEN EMERGENCY LIGHT LENS COVER AT 1L DOOR. REPLACED LENS COVER ABOVE L1 DOOR. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201709069018Housing · brokenAIRCRAFT IN BASE MAINTENANCE. BROKEN EMERGENCY PATH LIGHT HOUSING AT SEAT 14C. REPLACED EMERGENCY PATH LIGHT HOUSING AT SEAT 14C PER CMM 25-22-52.SDR AALA201709069017Lens · missingAIRCRAFT WAS NOT GROUNDED. LEFT ENTRY DOOR EMERGENCY EXIT LENS MISSING. INSTALLED LEFT ENTRY DOOR EMERGENCY EXIT LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR R61A201709050701Light · missingEMERGENCY LIGHT MISSING AT ROWS 11 AND 16. REPLACED THE LIGHT IAW 33-50-00-1.SDR R61A201709050700Light · inoperativeEMERGENCY LIGHT INOPERATIVE RIGHT SIDE ROW 1 - 4. R & R THE LIGHT IAW AMM 33-50-21.SDR AALA20170906006Battery · no testEMERGENCY EXIT LIGHTS BATTERY PACK FAILED THE 10 MINUTE CHECK. REMOVED AND REPLACED CHARGER ASSEMBLY AND BATTERY. OPS CHECKED GOOD.SDR AALA20170906005Charger · no testEMERGENCY EXIT LIGHTS BATTERY PACK FAILED THE 10 MINUTE CHECK. REMOVED AND REPLACED THE CHARGER ASSEMBLY AND BATTERY. OPS CHECKED GOOD.SDR DALA2017090706716Light · damagedDURING INSPECTION, FOUND EMERGENCY FLOOD LIGHT AT LAVATORY E MISSING. THE RED COVER AND LIGHT ASSY IS DAMAGED. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY FLOOD LIGHT ASSY IAW AMM 33-51.SDR DALA2017090606684Charger · inoperativeEMERGENCY LIGHTS AT SEATS 21-32GF ARE INOPERATIVE. REPLACED CHARGER. SYSTEM OPERATION IS NORMAL.SDR SWAA2017090616169Battery Pack · dischargedINTERIOR OVERHEAD LT OVERWING EMERGENCY EXIT SIGN LIGHT FAILED TEST. R&R BATTERY PACK PER AMM.SDR SWAA2017090616168Battery Pack · dischargedL1 DOOR OVERHEAD EMERGENCY EXIT SIGN LIGHT FAILED TEST. R&R BATTERY PACK PER AMM.SDR SWAA2017090616167Battery Pack · dischargedEXTERIOR R1 DOOR EMERGENCY EXIT LIGHT FAILED TEST. R&R BATTERY PACK PER AMM.SDR SWAA2017090616166Battery Pack · dischargedEXTERIOR LT OVERWING EMERGENCY EXIT SIGN LIGHT FAILED TEST. R&R BATTERY PACK PER AMM.SDR SWAA2017090616165Battery Pack · dischargedR1 DOOR OVERHEAD EMERGENCY EXIT SIGN LIGHT FAILED TEST. R&R BATTERY PACK PER AMM.SDR SWAA2017090616162Light · unsecureR1 DOOR EMERGENCY EXIT PLACARD FELL OFF. R&R LIGHT ASSEMBLY PER MM.SDR SIMA20170905004Bulb · inoperativeDURING PS-1, FOUND THE LAST ASILE EMERGENCY LIGHT INOPERATIVE. REPLACED THE BULB IAW AMM 33-50-08, OPS CHECKED GOOD.SDR AALA20170904005Light · no testEMERGENCY EXIT LIGHT L191 BY THE R2 DOOR FAILED. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-00. OPERATIONAL CHECKED GOOD.SDR REXA2017090500966Charger · inoperativeOVERWING MID EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BATTERY CHARGER NR 3 PS3LF IAW AMM 33-51-05. OPS CHECKED GOODSDR DALA2017090506620Charger · inoperativeON SERVICE CHECK, FOUND THE EMERGENCY LIGHTS INOPERATIVE AT ROWS 24G -34G. REPLACED BATTERY PACK AND CHARGER. SYSTEM OPERATION IS NORMAL.SDR SWAA2017090816198Light · damagedAFT ENTRY CEILING PANEL EMERGENCY LIGHT DAMAGED. R & R THE LIGHT IAW AMM.SDR AALA201709069016Light · brokenAIRCRAFT WAS NOT GROUNDED. BROKEN SEAT MOUNTED EMERGENCY LIGHT AT 9C. REPLACED EMERGENCY ESCAPE PATH LIGHT PER CMM 25-22-52.SDR AALA201709059015Battery · dischargedAFT FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE, BATTERY DISCHARGED. REPLACED BATTERY IN AFT FLIGHT ATTENDANT FLASHLIGHT AMM 25-65-00.SDR DALA2017090706717Lens · missingDURING INSPECTION, FOUND PAX SEAT 29 DEF EMERGENCY LIGHT BULB & LENS COVER MISSING. MAINTENANCE REPLACED MISSING LENS AND BULB. OPS CHECKED OK.SDR SWAA2017090716173Sign · missingOVERWING OVERHEAD EMERGENCY EXIT SIGN PLACARD MISSING. INSTALLED THE SIGN IAW SIP.SDR SWAA2017090716172Cover · detachedR1 DOOR EMERGENCY EXIT SIGN COVER FELL OFF. INSTALLED THE COVER IAW SIP.SDR SWAA2017090616147Cover · looseLT WING EMERGENCY EXIT COVER LOOSE. SECURED COVER REF SIP.SDR AALA201709069003Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHTS ON RIGHT SIDE OF AIRCRAFT, ROW 20 BELOW ESCAPE DOOR ARE INOPERATIVE. REMOVED AND REPLACED BATTERY PACK AND POWER SUPPLY CONTROL MODULE (AALA201709069009) PER AMM 33-60-98. OPERATIONAL CHECK GOOD.SDR YENA201709040739Battery Pack · no testDURING WEEKLY EMERGENCY LIGHT TEST OF THE EPSU BATTERY FAILED TO TEST. R & R THE BATTERY IAW AMM 33-51-38. EMERGENCY LIGHT SYSTEM CHECKED GOOD.SDR SCNA20170904161Lens · missingEMERGENCY LIGHT LENS UNDER OVERHEAD BIN AT SEAT ROW 15 ABC. FOUND MISSING. REPLACED THE LENS. OK FOR SERVICE.SDR DALA2017090506618Light · unsecureEMERGENCY FLOOR LIGHTING INOPERATIVE AT 24F. SECURED EMERGENCY FLOOR LIGHT TO SEAT. SYSTEM OPERATION IS NORMAL.SDR SIMA20170904001Lamp · inoperativeMAIN DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-50-10-000-801-A & 33-50-10-400-801-A. OPS CHECKED GOOD.SDR REXA2017090400961Bulb · inoperativeFORWARD EMERGENCY LIGHTS NEAR MAIN AND SERVICE DOORS ARE INOPERATIVE. R & R THE BULBS AND OPS CHECKED IAW AMM 38-51-10.SDR REXA2017090400958Battery Pack · inoperativeOVERWING EMERGENCY EXIT LIGHT ON CEILING INOPERATIVE. REMOVED AND REPLACED THE NR 3 EMERGENCY BATTERY PACK IAW AMM 33-51-04. OPS CHECKED GOOD.SDR DALA2017090506615Power Supply · defectiveTHE AFT CABIN EMERGENCY EXIT SIGN REMAINED ON WITH THE EMERGENCY SWITCH OFF. MAINTENANCE REPLACED B5-260 EMERGENCY POWER SUPPLY PER AMM 33-51-03 AND THE SYSTEM CHECKS OK.SDR CALA2017090403055Power Supply · faultyDURING CABIN EMERGENCY LIGHT OPS CHECK ON PTP, HAD MESSAGES FOR THE EPSU BATTERY FWD L AND EPSU INT LOAD AFT L. REPLACED EPSU 13WL IAW AMM 33-51-38-000-001, OPS CHECKED GOOD.SDR CALA2017090403054Power Supply · faultyDURING A NR 2 SERVICE TEST OF EMERGENCY LIGHTS, CIDS FAULTED COMM EMER FWD L, COMM EMER AFT L. . SYSTEM WOULD NOT PASS TEST. EXTERIOR OVERWING LIGHT DID NOT ILLUMINATE. REPLACED POWER EMERGENCY SUPPLY 10WL IAW MM 33-51-38-000-001 AND 33-51-38-400-001. REPLSDR CALA2017090403050Light · looseEMERGENCY LIGHT, ROW 33D AND 23D WAS HANGING OUT. INSTALLED THE EMERGECNY LIGHT.SDR DALA2017090406602Charger · inoperativeEMERGENCY LIGHTS INOPERATIVE. TROUBLESHOT THE FIRST CLASS EMERGENCY LIGHTS IAW AMM 33-53. REPLACED THE BATTERY AND CHARGER IAW AMM 33-53. OPS CHECKED GOOD.SDR MASA2017090412600Flashlight · inoperativeFWD F/A FLASHLIGHT WOULD NOT CHARGE.SDR SIMA20170903003Power Supply · inoperativeNR 2 AND 3 EMERGENCY LIGHTS FOUND INOPERATIVE. INSTALLED A NEW POWER SUPPLY AND BATTERY IAW AMM 33-50-04, OPS CHECKED GOOD.SDR SIMA20170903004Light · damagedNR 5 EMERGENCY LIGHT IS DAMAGED. REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-12.SDR SIMA20170903006Sign · inoperativeSIGN ON AFT SIDE OF G2 GALLEY INOPERATIVE. INSTALLED A NEW POWER SUPPLY AND BATTERY IAW AMM 33-50-04. OPS CHECKED GOOD.SDR SIMA20170903005Light · damagedNR 4 EMERGENCY LIGHT IS DAMAGED ON THE END. REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-12.SDR SIMA20170903002Light · damagedR1 AND R7 EMERGENCY LIGHT PROFILES ARE CRACKED AND DAMAGED. REPLACED THE R1 AND R7 EMERGENCY LIGHT PROFILES IAW AMM 33-50-12.
Back to JASC 3350