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 CALA2017041000934Battery Pack · dischargedRT DOOR 2 OVERHEAD EXIT SIGN FOUND DIM. M33097 EMER BATTERY PACK REPLACED AND EMER LT LAMP TESTED NORMAL AS PER AMM 33-51-00SDR CALA2017041000933Charger · inoperativeZONE D AFT GALLEY EMER LT FOUND DIM. M33409 BATTERY PACK AND BATTERY CHARGER REPLACED AND EMER LT TESTED NORMAL AS PER AMM 33-51-00.SDR CALA2017041000932Battery Pack · dischargedZONE LT AISLE EMER LT FOUND DIM ZONE C LT OVERHEAD. BATTERY PACK M33400 REPLACED AND TESTED NORMAL AS PER AMM 33-51-00.SDR CALA2017041000931Charger · inoperativeZONE D RT AISLE EMER LT FOUND DIM. ZONE D RT M33408 BATTERY CHARGER REPLACED AND TESTED AS PER AMM 33-51-00.SDR CALA2017041000930Battery Pack · dischargedCABIN RT DR 2 FWD EXIT IDENTIFY FOUND POOR CONDITION. CABIN RT DR 2 FWD EXIT IDENTIFY AND BATTERY PACK M33099 REPLACED AND TEST FOUND NORMAL AS PER AMM 33-51-00.SDR AALA201704109058Battery · dischargedAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANT EMERGENCY FLASHLIGHT MID GALLEY LEFT SIDE IS LOW. REMOVED AND REPLACED FLASHLIGHT BATTERY IAW AMM 25-63-00. OPERATIONAL CHECK GOOD.SDR DALA2017041002889Cover · looseEMERGENCY EXIT SIGN COVER LOOSE AT LOCATIONS: 102. EMERGENCY EXIT SIGN AT 102 RE-SECURED IAW AMM 25-60.SDR AALA201704109037Lens · brokenL4 SEAT MOUNTED EMERGENCY EXIT LIGHT LENS BROKEN. REPLACED THE LIGHT ASSEMBLY.SDR AALA201704109034Light · inoperativeFOUND EXIT LIGHT AT SEAT 22D INOPERATIVE. SECURED THE LIGHT AT 22D.SDR AALA201704109031Lens · missingEMERGENCY LIGHT AT THE L4 DOOR MISSING THE LENS. REPLACED THE LENS.SDR AALA201704109026Cover · missingEXIT LIGHT COVER ARE MISSING. INSTALLED MISSING COVER.SDR AALA201704109025Lens · missingEXIT LIGHT AT 2L AND 2R HAVE THE PLACARD MISSING THE COVER ARE MISSING. INSTALLED MISSING COVERS AT 2R EMERGENCY EXIT LIGHT.SDR SWAA2017041013028Cover · missingEMERGENCY EXIT ROW LIGHT COVER MISSING. INSTALLED A NEW COVER IAW AMM.SDR SIMA20170408003Lamp · not seatedSERVICE DOOR GROUND ILLUMINATION EMERGENCY LIGHT INOPERATIVE. RESEATED THE LAMP IAW AMM 33-50-09. OPS CHECKED GOOD.SDR DALA2017041002871Battery Pack · inoperativeOVERHEAD CABIN EMERGENCY LIGHTS INOPERATIVE FROM ROWS 1 TO 16. REMOVED AND REPLACED THE BATTERY PACKS IAW AMM 33-53. CHECKED GOOD.SDR N6WA2017040801Light · missingEMERGENCY EXIT ROW FLOOR LIGHTING MISSING. REPLACED EMERGENCY LIGHT IAW AMM 25-25-01.SDR ASOA201704083070Battery · inoperativeTHE CREW REPORTED FORWARD FLOOR EMERGENCY LIGHTING WAS INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY LIGHT BATTERY. OPERATIONAL CHECKS WERE GOOD.SDR MASA2017040812726Light · inoperativeROW 15 CEILING FLOOD LIGHT INOP. PLACED ON MEL.SDR R61A201704080268Battery · dischargedWHILE THE ACFT WAS IN HEAVY CHECK, MAINT REPORTED L1 DOOR EMERGENCY LIGHT INOP. REMOVED AND REPLACED L1 EMERGENCY BATTERY IAW AMM 33-50-10. OPS CHECK GOOD.SDR SWAA2017041913246Lens · brokenRIGHT OVERHEAD BULLNOSE STOWAGE BIN EMERGENCY EXIT LIGHT LENS BROKEN AT ROW 22. R & R THE LENS IAW AMM.SDR SWAA2017041913207Lens · brokenLEFT OVERHEAD BULLNOSE STOWAGE BIN EMERGENCY EXIT LIGHT LENS BROKEN AT ROW 24. R & R THE LENS IAW AMM.SDR AALA201704109054Light · looseAIRCRAFT WAS NOT GROUNDED. LOOSE EMERGENCY LIGHT AT 11C (HANGING OUT). SECURED EMERGENCY LIGHT AT 11C AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR DALA2017041002923Charger · inoperativeAFT OVERHEAD EXIT SIGN AND EXIT SIGN IN TAIL CONE IS FLASHING. REMOVED AND REPLACED BATTERY PACK CHARGER B5-239. OPERATION CHECKS GOOD.SDR SWAA2017041113068Lens · looseRT OVERWING EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA2017041113058Lens · looseEMERGENCY EXIT LIGHT LENS LOOSE ABOVE ROW 14 ABC. SECURED LENS PER MM.SDR AALA201704109059Lens · missingEMERGENCY EXIT LENS CAP MISSING AT ROW 14. INSTALLED NEW LENS CAP ON EMERGENCY EXIT SIGN AT ROW 14 IAW IPC 33-51-01. THE AIRCRAFT WAS NOT GROUNDED.SDR CALA2017040800926Battery · dischargedR3 FWD DM33404 BATTERY PACK FOUND INOP. R3 FWD DM33404 BATTERY PACK REPLACED AND CHECKED NORMAL AS PER A MM 33-51-06.SDR AALA201704109053Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT R4 DOOR HAS A DETACHED LENS COVER. REINSTALLED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201704109048Lens · looseAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT L2 DOOR HAS A LOOSE LENS COVER. SECURED LENS COVER IAW AMM 33-24-00. OPERATIONAL CHECK GOOD.SDR AALA201704109046Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT L1 DOOR HAS A DETACHED LENS COVER. REINSTALLED LENS COVER. OPERATIONAL CHECK GOOD.SDR ASAA2017040720399Sign · inoperativeFOUND CENTER AISLE OVERHEAD EMERGENCY SIGN INOPERATIVE. ACFT GROUNDED. REMOVED AND REPLACED EMERGENCY EXIT SIGN IN THE CENTER AISLE IAW AMM 33-51-01-960-802, OPS CHECKED GOOD.SDR ASAA2017040720398Battery Pack · dischargedFOUR INTERIOR EMERGENCY OVERHEAD BIN LIGHT INOPERATIVE ROW 17R TO 24R. ACFT GROUNDED. REMOVED AND REPLACED EMERGENCY LIGHT POWER SUPPLY BATTERY PACK IAW AMM 33-51-06-960-805. OPS CHECKED GOOD.SDR AALA201704109033Lens · missingRED EMERGENCY LIGHT LENS MISSING AT EXIT ROW, SEAT 8D. INSTALLED A NEW LENS.SDR AALA201704109021Battery Pack · no test13WL EPSU WONT SELF TEST. R & R THE BATTERY PACK. AIRCRAFT WAS GROUNDED.SDR AALA201704109020Power Supply · no test13WL EPSU WONT SELF TEST. R & R THE EPSU. AIRCRAFT WAS GROUNDED.SDR AALA201704109019Battery Pack · no test11WL EPSU SUSPECT BAD. REPLACED THE BATTERY PACK. AIRCRAFT WAS GROUNDED.SDR AALA201704109017Power Supply · failed11WL EPSU SUSPECT BAD. REPLACED EPSU. AIRCRAFT WAS GROUNDED.SDR AALA201704109035Sign · missingSEAT 21DEF EXIT SIGN MISSING. REPLACED THE SIGN.SDR AALA201704109027Lens · missingEXIT ROW 11 EMERGENCY LIGHT LENS COVER MISSING. REPLACED EMERGENCY COVER LENS.SDR AALA201704109001Switch · inoperativeEMERGENCY EXIT LIGHTS STAY ON IN ARMED POSITION. REPLACED TOGGLE SWITCH, EMERGENCY EXIT LIGHT SWITCH, TESTED OK.SDR RAIA201704070001Battery Pack · inoperativeLT AND RT OVERWING EMERGENCY LIGHTS NR 5 & 6, INOPERATIVE. R & R THE NR 4 EMERGENCY LIGHT BATTERY PACK. OPS CHECKED GOOD.SDR DALA2017040902879Battery Pack · no testNR 2 ASPSU BATTERY CHECK PER WC 5271-7016. REPLACED NBR 2 ASPSU BATTERY PER AMM 52-71.SDR IPXA2017040815923Bulb · inoperativeEMERGENCY LIGHT ASSY HAS FOUR BULBS OUT. R & R THE BULBS IAW AMM 33 51 01 02.SDR HNAA2017041000114Bulb · inoperativeEMERGENCY LIGHT ON AISLE FLOOR, SEAT 6DF, BULB IS OUT. REMOVED AND REPLACED THE BULB.SDR MASA2017040712724Light · inoperativeEMER FLOOD LIGHT ROW 156 INOP. PLACED ON MEL.SDR CALA2017040700911Light · looseEMERGENCY LIGHTS ON CORNER BUMPER AFT OF 1L IS LOOSE/HANGING. SECURED AS REQUIRED.SDR CALA2017040700908Light · inoperativeNR 4L MED EEL INOP. RELAMPED OPS CHECKED GOOD ACPD IDT INSPECTION OF 4L MED EEL LIGHT.SDR CALA2017040700923Charger · faultyAFT EMERG SEAT LIGHTS INOP. R&R AFT SEAT EMERG LIGHT BATTERY CHARGER OPS CK NORMAL.SDR CALA2017040700920Light · looseEMERGENCY FLOOR PROXIMITY LIGHT DOES NOT TURN ON. EMERG LIGHT AT 15C DAMAGED, SECURED EMERGENCY LIGHT AT 15C. PERFORMED OPS CHECK OF EMERGENCY LIGHTING IAW MM 33-51-00 WITH NO DEFECTS NOTED.SDR CALA2017040700919Lens · missingEXIT LENS MISSING AT RT OVERWING EMERG EXIT LOWER BULKHEAD. REPLACED LENS WITH CORRECT DUAL LANGUAGE LENS.
Back to JASC 3350