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 DALA2017070205148Battery · dischargedBATTERY POWER SUPPLY BS-229 INOPERATIVE. REMOVED AND REPLACED BATTERY ASSEMBLY. OPERATION CHECKS GOOD.SDR REXA2017062500721Battery · dischargedOVERWING EMERGENCY LIGHTS, BOTH SIDES DIM AFTER 30 SEC. REMOVED AND REPLACED EMERGENCY BATTERY NR 4 IAW AMM 33-51-17. OPS CHECK GOOD.SDR AALA201706269031Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT AISLE LIGHT BY THE FORWARD GALLEY HAS A BROKEN LENS COVER. REPLACED LENS COVER. OPERATIONAL CHECK GOOD.SDR AALA201706269026Battery · dischargedAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT AT SEAT 4E IS DIM. RECHARGED BATTERIES IAW AMM 33-51-07. OPERATIONAL CHECK GOOD.SDR ASAA2017062521203Lens · missingEXIT LIGHT COVER MISSING AT 16F. ACFT GROUNDED. INSTALLED THE LENS. OPS GOOD.SDR AALA201706279007Light · brokenSEAT ROW 4 LEFT EMERGENCY LIGHT BROKEN. REMOVED AND REPLACED THE EMERGENCY LIGHT .SDR AALA201706279006Lens · missingR2 DOOR EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED A NEW LENS.SDR AALA201706279004Lens · missingTHE L2 DOOR EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED A NEW LENS.SDR AALA201706279002Power Supply · faultyEMERGENCY LIGHTS POWER SUPPLY 11WL UNIT FAULTED.SDR CALA2017062601981Inverter · inoperativeL2, R2, AND LEFT FORWARD OVERWING LOWER EMERGENCY EXIT SIGNS INOPERATIVE. RESEATED CONNECTOR D6660 ON LEFT EFD OVERWING SIGN IAW BSOPM 20-42-01 AND REMOVED AND REPLACED INVERTER M10826 IAW SRM 51-40-02, PG 7, AND BSWPM 20-42-01. OP CHECKED GOOD IAW AMM 32-51-SDR CALA2017062601980Battery Pack · inoperativeR1 DOOR UPPER EMERGENCY EXIT SIGN INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-07-022-020, AND 33-51-07-862-054. OPS CHECKED GOOD IAW AMM 33-51-07-862-036.SDR ASAA2017062521185Lamp · inoperativeEMERGENCY LIGHT, SIGN ADJACENT TO LEFT AFT OVERWING EXIT HAS MULTIPLE LAMPS INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMPS AND TESTED IAW AMM 33-51-01-960-801. OPS NORMAL.SDR DALA2017062604992Charger · inoperativeFOUND EMERGENCY LIGHTS INOPERATIVE ROW 41-45. REPLACED THE CHARGER AND BATTERY M737 IAW AMM 33-51. OPS CHECKED GOOD.SDR SWAA2017062614598Lens · detachedMID CABIN EMERGENCY EXIT LIGHT COVER CAME OFF. R & R THE LIGHT ASSEMBLY IAW MM.SDR SIMA20170625005Battery Pack · failedAFT CABIN FLOOR MOUNTED EMERGENCY EXIT LIGHTS ARE INOPERATIVE. REMOVED AND REPLACED THE LIGHT IAW AMM 33-50-12, OPS CHECKED GOOD.SDR HNAA2017062500217Bulb · inoperativeEXIT EMERGENCY LIGHT AT ROWS 1,4,5 INOPERATIVE. R & R THE BULBS. GOOD FOR SERVICESDR MASA2017062512404Light · inoperativeFLOOR LEVEL OW BOTH EMERGENCY EXIT SIGNS INOP. REPLACED BULBS.SDR MASA2017062512402Light · inoperativeCENTER CAB FWD CEILING EMERGENCY CALL LIGHT INOP. REPLACED BULB.SDR AALA20170629005Battery Pack · failedAIRCRAFT WAS IN BASE MAINTENANCE. L3 EMERGENCY POWER SUPPLY M33406 FAILED TEST. REMOVED AND REPLACED BATTERY PACK ASSEMBLY IAW AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR DALA2017062605151Sign · missingFORWARD EXIT SIGNS MISSING. REPLACED.SDR SWAA2017062914676Lens · looseAFT LAV FORWARD WALL LOWER EXIT LIGHT LENS LOOSE. SECURED LENS IAW AMM.SDR ASOA201706245090Light · malfunctionedPILOT REPORTED EMERGENCY LIGHTS ARE NOT WORKING. MX RESET AIRCRAFT POWER. EMERGENCY LIGHTS OPS CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA2017062814665Cover · brokenL2 DOOR EMERGENCY EXIT LIGHT COVER BROKEN. R&R COVER PER AMM.SDR SWAA2017062814654Lens · looseFORWARD LAV AFT WALL LOWER EXIT LIGHT LENS LOOSE. SECURED LENS IAW AMM.SDR SWAA2017062814649Lens · unsecureRT OVERWING EXIT SIGN LENS FELL OFF. SECURED LENS PER SIP.SDR AALA201706269028Battery · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH LIGHT AT SEAT 18D IS DIM. RECHARGED BATTERIES IAW AMM 33-51-07. OPERATIONAL CHECK GOOD.SDR AALA201706269027Battery · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH LIGHTS AT ROWS 26D THROUGH 32D ARE DIM. RECHARGED BATTERIES IAW AMM 33-51-07. OPERATIONAL CHECK GOOD.SDR AALA201706269059Lens · brokenEMERGENCY LIGHT LENS AT THE R4 EXIT LIGHT BROKEN. REPLACED THE LENS.SDR F3LA2017062700181Battery Pack · no testBATTERY PACK FAILED DURING EPSU TEST. REPLACED THE BATTERY PACK. OPERATIONAL CHECKED NORMAL. IAW AMM 33-51-38-000-002-A, AND AMM 33-51-38-400-002-A.SDR HALA2017062500194Light · detachedEMERGENCY PATHWAY LIGHT STRIP IN FIRST CLASS GALLEY COMING OFF. RE-ATTACHED EMERGENCY PATHWAY LIGHT STRIP IN FIRST CLASS GALLEY.SDR AALA201706269050Lens · missingTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT PLACARD COVER AFT DOOR IN THE EXIT ROW MISSING/BROKEN. INSTALLED EMERG COVER LENS IAW AMM 33-29-00, CK OK.SDR ASAA2017062421177Lens · detachedMID CABIN EXIT SIGN CAP FELL OFF. ACFT GROUNDED. REINSTALLED MID CABIN EXIT SIGN AND SECURED.SDR DALA2017062604993Sign · unsecureEXIT SIGN FROM OVERHEAD ROW 26 UNSECURE. SECURED THE EXIT SIGN AT ROW 26. OK FOR SERVICE.SDR MASA2017062423401Light · inoperativeROW 15 EMERGENCY CEILING LIGHT INOP. PLACED ON MEL.SDR MASA2017062412400Battery · dischargedEMERGENCY LIGHT BATTERIES DRAINED. CHARGED BATTERIES.SDR SWAA2017071715063Cradle · faultyFORWARD CABIN L/H EMERGENCY LIGHT BATTERY CRADLE FAULTY. R&R BATTERY CRADLE IAW AMM.SDR SWAA2017070514749Light · inoperativeLT EMERGENCY LIGHT BULB INOP AT ROW 20. R&R BULB IAW AMM.SDR SWAA2017070514733Lens · missingRIGHT OVERWING EMERGENCY EXIT SIGN COVER LENS MISSING. REPLACED THE LENS IAW MM.SDR SWAA2017062814670Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER AMM.SDR SWAA2017062814669Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PER AMM.SDR SWAA2017062814668Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER AMM.SDR SWAA2017062814667Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R&R BATTERY PER AMM.SDR SWAA2017062814664Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R&R BATTERY PER AMM.SDR DALA2017062705027Fuse · no testFOUND LEFT SIDE ROW 21-23 EMERGENCY LIGHT INOPERATIVE DURING SERVICE CHECK. REPLACED F1 FUSE ON M9009 POWER SUPPLY. SYSTEM OPERATION IS NORMAL.SDR AALA201706269032Light · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH LIGHT AT SEAT 34H FORWARD IS INOPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLY IAW ESO 11910. OPERATIONAL CHECK GOOD.SDR R61A201706230464Battery · dischargedEMERGENCY LIGHT IN COCKPIT WILL NOT COME ON. R & R EMERGENCY LIGHT BATTERY 1 IAW AMM 33-50-01. OPS CHECK IAW AMM 33-50-00. ALL OPS CHECKED GOOD.SDR AALA201706269054Lens · missingEXIT LIGHT LENS AT THE R4 DOOR IS MISSING. INSTALLED A NEW LENS.SDR AALA201706269016Lens · brokenEMERGENCY EXIT LIGHT LENS BY FWD F/A JUMPSEAT BROKEN. REPLACED THE LENS.SDR AALA201706269018Cover · detachedEXIT SIGN COVER AT THE R3 DOOR DETACHED. REIINSTALLED EXIT SIGN COVER.SDR AALA20170623007Light · brokenDURING MAINTENANCE INSPECTION, FOUND LAVATORY L EMERGENCY FLOOD LIGHT BROKEN. REPLACED THE LIGHT IAW AMM 33-51-18. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.
Back to JASC 3350