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 SWAA2018062522979Lens · brokenAFT GALLEY DOOR EXIT ARROW LENS BROKEN. R&R LENS PER MM.SDR SWAA2018062522970Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER AMM.SDR SWAA2018062522961Light · inoperativeLT EMERGENCY LIGHT BEHIND FLAPS INOP. RELAMPED LIGHT PER AMM.SDR ASOA2018062515159Battery Pack · inoperativeDURING MX INSPECTION THE AFT EMERGENCY LIGHTS AND OVER WING LIGHTS WERE FOUND NOT TO ILLUMINATE. MX REMOVED AND REPLACED NR 4 EMERGENCY LIGHT BATTERY. OPS CHECKED GOOD. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR AALA2018062529008Light · damagedCABIN EMERGENCY LIGHT DAMAGED. REPLACED THE EMERGENCY LIGHT IAW DWG 19P33D1283.SDR AALA201806229013Battery Pack · dischargedAIRCRAFT WAS GROUNDED. LEFT OVERWING EXIT LIGHTS COME ON DURING TAKE OFF ROLL. REPLACED BATTERY PACK M1694, OPERATIONS CHECKS NORMAL ON GROUND REF AMM 33-51-06.SDR AALA201806229012Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHTS OVERHEAD SEATS 25 AND 27 RIGHT HAND SIDE FAILED TO STAY ON DURING TEST OF BATTERY PACK CAPACITY CHECK. REPLACED EMERGENCY POWER SUPPLY BATTERY PACK (M1672) PER AMM 33-51-06. OPERATIONS CHECK NORMAL.SDR AALA201806229011Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHTS SEAT MOUNTED ROW 22 THRU ROW 30 RIGHT HAND SIDE FAILED TO STAY ON DURING TEST OF BATTERY PACK CAPACITY CHECK. REPLACED BATTERY PACK (M1671) PER AMM 33-51-06 OPERATIONS CHECK NORMAL.SDR AALA201806229010Battery · dischargedAIRCRAFT WAS NOT GROUNDED. WHILE PERFORMING OPERATIONS TEST OF EMERGENCY LIGHTS, CLASS ONE MESSAGE "33-50-00 EPSU 13WL AFT LEFT". REPLACED EMERGENCY POWER SUPPLY UNIT BATTERY (13WL) PER AMM 33-51-38. OPERATIONS CHECK GOOD.SDR REXA2018062100534Light · inoperativeEMERGENCY LIGHT TRACK INOP. REMOVED AND REPLACED LIGHT ON EMERGENCY TRACK IAW AMM 33-51-01. OPS CHECK GOOD AT THIS TIME.SDR SIMA20180621002Charger · failedLEFT EXTERNAL OVERWING EMERGENCY LIGHT, AFT OF THE EMERGENCY EXIT FAILED TO ILLUMINATE. REMOVED AND REPLACED THE NR 2 BATTERY PACK CHARGER ASSY IAW AMM 33-51-17. OPS CHECKED GOOD. PERFORMED AN OPS CHECK OF THE EXTERIOR EMERGENCY LIGHTS IAW AMM 33-51-15. OPSSDR YENA2018062210263Lens · missingRIGHT OVERWING EXIT, TWO EMERGENCY EXIT SIGN COVERS WERE MISSING. REPLACED THE COVERS IAW AMM 33-51-15. OPS CHECKED GOOD. ACFT OK FOR SERVICE.SDR REXA2018062210529Light · missingEMERGENCY LIGHT STRIP AT THE LEFT REAR EMERGENCY EXIT WAS MISSING. REPLACED THE EMERGENCY LIGHT TRACK IAW AMM 33-51-01.SDR YENA2018062210262Battery Pack · no testBATTERY PACKS 10WL, 11WL, AND 12WL FAILED AN EMERGENCY LIGHT TEST. R & R THE BATTERY PACKS IAW AMM 33-51-38. CHECKED GOOD.SDR YENA2018062210261Battery Pack · no testBATTERY PACKS 10WL, 11WL, AND 12WL FAILED AN EMERGENCY LIGHT TEST. R & R THE BATTERY PACKS IAW AMM 33-51-38. CHECKED GOOD.SDR YENA2018062210260Battery Pack · failedBATTERY PACKS 10WL, 11WL, AND 12WL FAILED AN EMERGENCY LIGHT TEST. R & R THE BATTERY PACKS IAW AMM 33-51-38. CHECKED GOOD.SDR YENA2018062210259Light · inoperativeOVERWING DOOR EMERGENCY LIGHT INOPERATIVE, ESCAPE HATCH HANDLE LIGHT. REPLACED THE OVERWING DOOR ESCAPE HATCH EMERGENCY LIGHT IAW AMM 33-51-11.SDR MASA2018062113339Light · inoperativeCEILING EMERGENCY LIGHTS AT ROW 16, 21, 22 INOP. REPLACED BULBS.SDR SIMA20180621001Bulb · inoperativeLEFT OVERWING EMERGENCY LIGHT WAS INOPERATIVE. REMOVED AND REPLACED THE BULB IAW AMM 33-50-07. OPS CHECKED GOOD.SDR HALA2018062100296Sign · detachedEXIT SIGN AT THE R3 DOOR FELL OFF INFLIGHT. ATTACHED THE EXIT SIGN. SECURITY CHECKED GOOD.SDR DALA2018062104126Battery Pack · inoperativeEMERGENCY LIGHTS ON BOTH SIDES OF THE RT EMERGENCY EXIT DOOR WERE INOPERATIVE. R & R THE BATTERY IAW AMM 33-55. OPS CHECKED GOOD.SDR REXA2018062000567Battery Pack · dischargedMULTIPLE EMERGENCY LIGHTS DO NOT WORK THROUGHOUT CABIN. REMOVED AND REPLACED EMERGENCY LIGHTING BATTERY PACKS 1,3,4,5 AMM 33-51-17. OPERATIONAL TEST OF THE EMERGENCY LIGHTS GOOD IAW AMM 33-51-00-710-802.SDR AALA20180621001Switch · brokenAIRCRAFT IN BASE MAINTENANCE. EMERGENCY LIGHT SWITCH ON P-40 BROKE DURING ACTUATION FOR FUNCTIONAL CHECK. REPLACED SWITCH.SDR SWAA2018062523050Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER AMM.SDR SWAA2018062523049Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER AMM.SDR SWAA2018062523048Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1668. R&R BATTERY PER AMM.SDR SWAA2018062523032Battery Pack · failedAFT LT EMERGENCY BATTERY FAILED CAPACITY CHECK. R&R BATTERY PACK PER AMM.SDR SWAA2018062523031Battery Pack · failedLT FORWARD GALLEY EMERGENCY LIGHT BATTERY PACK FAILED CAPACITY TEST. R&R BATTERY PACK PER AMM.SDR SWAA2018062523013Light · inoperativeLT OVERWING EXIT DOOR LIGHT INOP. R&R LIGHT IAW AMM.SDR SWAA2018062522969Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R&R BATTERY PER AMM.SDR SWAA2018062522968Battery Pack · failedFORWARD LT EMERGENCY BATTERY FAILED CAPACITY CHECK. R&R BATTERY PACK PER AMM.SDR SWAA2018062522965Light · inoperativeR2 DOOR EMERGENCY LIGHT INOP. RELAMPED LIGHT IAW MM.SDR SWAA2018062522958Battery Pack · dischargedR1 DOOR EMERGENCY LIGHTS INOP. R&R BATTERY PACK ASSEMBLY IAW MM.SDR AALA201806219009Lens · missingTHE AIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY LIGHT LENS MISSING. REPLACED LIGHT ASSEMBLY PER AMM 33-51-19. OPERATIONS CHECK NORMAL.SDR REXA2018062000533Battery Pack · dischargedEXTERIOR EMERGENCY LIGHTS DS5LF AND DS8LF WILL NOT WORK. REPLACED EMERGENCY LIGHT BATTERY PACK PS3LF IAW AMM 33-51-04 AND OPS CHECKS GOOD IAW AMM 33-51-04.SDR DALA2018062214152Lens · detachedEMERGENCY LIGHT COVER AT THE L2 DOOR FELL OFF. REINSTALLED THE EMERGENCY LIGHT COVER IAW IAW AMM 33-51.SDR IPXA2018062203902Holder · damagedEMERGENCY EXIT SIGN, LOWER LIGHTS INOPERATIVE. FOUND THE BULB HOLDER NOT MAKING CONTACT. R & R THE HOLDER & TESTED IAW AMM 33-51-01. OPS CHECKED NORMAL. ALL LIGHTS TEST NORMALSDR REXA2018062200527Bulb · inoperativeEMERGENCY LIGHTS IN THE RT GALLEY, THE BULBS WERE INOPERATIVE. R & R THE BULBS. OP CHECKED GOOD IAW AMM 33-51-00.SDR CALA2018062211499Charger · inoperativeL3 DOOR EMERGENCY LIGHT POWER SUPPLY M33400 CHARGER WAS INOPERATIVE. REPLACED THE CHARGER , TESTED NORMAL IAW AMM 33-51-06SDR CALA2018062211498Battery Pack · dischargedL3 DOOR EMERGENCY LIGHT POWER SUPPLY BATTERY HAD LOW CAPACITY. THE BATTERY PACK WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR CALA2018062201514Charger · inoperativeL3 DOOR EMERGENCY LIGHT POWER SUPPLY M33400 CHARGER WAS INOPERATIVE. THE POWER SUPPLY CHARGER WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR C77A2018062100003Battery · inoperativeRIGHT AFT FA FLASHLIGHT NOT FLASHING. REPLACED THE FLASHLIGHT BATTERY IAW AMM 33-51-01, OPS CHECKED GOOD.SDR SIMA2018062100002Light · inoperativeFLOOR EMERGENCY LIGHT IN THE CABIN, ALONG SEATS 12A AND 13A DID NOT ILLUMINATE. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-12. OPS CHECKED GOOD. NO OTHER DEFECTS NOTED.SDR REXA201806210525Lens · crackedLEFT MIDDLE OVERWING EMERGENCY EXIT LIGHT LENS WAS CRACKED. REMOVED AND REPLACED THE LENS IAW CMM 33-51-02.SDR REXA201806210524Lens · damagedLEFT OVERWING EMERGENCY EXIT LIGHT HAD A DAMAGED LENS. REMOVED AND REPLACED LT AFT EMERGENCY LIGHT LENS IAW CMM 33-52-07.SDR AALA201806219013Lamp · inoperativeLAVATORY H EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-24-12.SDR SWAA2018062122945Lens · missingAFT PORTION OF CENTER AISLE OVERHEAD OVERWING EMERGENCY EXIT SIGN LENS MISSING. INSTALLED LENS IAW AMM.SDR SWAA2018062022915Lens · missingCEILING ABOVE CENTER AISLE OVERWING EMERGENCY EXIT SIGN COVER MISSING. INSTALLED LENS PER AMM.SDR MASA2018062013334Lamp · inoperativeROW 9 OVERHEAD CEILING LIGHT INOPERATIVE. REPLACED THE LAMP.SDR SWAA2018071823582Light · inoperativeL2 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED PER MM.
Back to JASC 3350