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 E07A201802140003Battery Pack · failedEMERGENCY LIGHTS STAYS ON IN ARM POSITION OR FLASHES ON/OFF IN ARM AND ON.SDR E07A201802140001Battery Pack · failedEMERGENCY LIGHTS STAYS ON IN ARM POSITION OR FLASHES ON/OFF IN ARM AND ONSDR AALA201707069014Lens · brokenLAVATORY L EMERGENCY LIGHT LENS BROKEN. MAINTENANCE REPLACED THE LENS IAW AMM 33-51-18-4.SDR AALA201707069013Lens · crackedR3 DOOR EMERGENCY EXIT LIGHT LENS CRACKED. MAINTENANCE REPLACED THE LENS IAW AMM 33-51-13-4.SDR SWAA2017071114936Lens · looseCENTER AISLE EMERGENCY EXIT LIGHT SIGN LENS LOOSE AT ROW 24. SECURED LENS PER AMM.SDR SWAA2017071014894Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R & R BATTERY PACK IAW AMM.SDR SWAA2017071014870Cover · looseRIGHT EMERGENCY EXIT LIGHT COVER LOOSE. R & R THE COVER IAW AMM.SDR SWAA2017071014831Sign · looseMID CABIN OVERHEAD EXIT SIGN LOOSE. SECURED THE SIGN IAW MM.SDR SWAA2017071014829Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R & R THE BATTERY IAW AMM.SDR AALA201707079022Sign · brokenTHE AIRCRAFT WAS NOT GROUNDED. EXIT IDENTIFIER IS BROKEN ON THE LEFT G4B GALLEY. REPLACED LIGHT L1190 PER AMM 33-51-01. EXIT IDENT CHECKS GOOD.SDR AALA201707079020Light · damagedTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT IDENTIFIER LIGHT ASSY DAMAGED AT 2R CABIN DOOR. R&R EMERGENCY LT ASSY AT 2R DOOR, OPS CK OK REF AMM 33-51-01.SDR AALA20170705003Power Supply · inoperativeR3 DOOR EMERGENCY LIGHTS POWER SUPPLY INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06. OPS CHECKED GOOD FOR SERVICE.SDR REXA2017070500771Light · inoperativeCENTER EMERGENCY LIGHT ON LEFT SIDE OF FUSELAGE IS OUT. REMOVED AND REPLACED THE EMERGENCY LIGHT. OPS CHECKED GOOD IAW 33-51-00-710-801.SDR 29GA2017070600001Bulb · inoperativeEMERGENCY LIGHT PUSH ON BUTTON AT FLIGHT ATTENDANT STATION NOT ILLUMINATING. REPLACED FLIGHT ATTENDANT EMERGENCY PUSH BUTTON BULB, OPERATIONAL CHECKED GOOD.SDR DALA2017070605234Lens · missingAFT EMERGENCY RED LENS ON BOTH SIDE MISSING. REPLACED THE RED LENSES.SDR AALA201707069017Housing · brokenEMERGENCY LIGHT HOUSING BROKEN AT SEATS 21C AND 26C. REPLACED LIGHT HOUSING AT 26C IAW CMM 25-22-52.SDR AALA201707069011Lens · brokenEMERGENCY LIGHT COVER AT THE R2 DOOR FELL OFF. REPLACED BROKEN LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201707069010Bezel · damagedAIRCRAFT WAS NOT GROUNDED. ROW 9C EMERGENCY LIGHT BEZEL DAMAGED. REPLACED ROW 9C EMERGENCY LIGHT BEZEL AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201707069009Housing · brokenEMERGENCY LIGHT HOUSING BROKEN AT SEATS 21C AND 26C. REPLACED LIGHT HOUSING IAW CMM 25-22-52.SDR AALA201707069008Housing · brokenEMERGENCY LIGHT HOUSING BROKEN AT SEAT 20C. REPLACED LIGHT HOUSING IAW CMM 25-22-52.SDR MASA2017070512439Light · inoperativeROW 17 EMERGENCY CEILING LIGHT INOPERATIVE.SDR PNSA2017070501Power Supply · no testEMERGENCY LIGHTING POWER SUPPLY FAILED DURING FUNCTION CHECKSDR DALA2017070505218Battery Pack · inoperativeFWD GALLEY OVERHEAD EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY PACKS IAW AMM 33-50. OPS CHECKED GOOD.SDR SWAA2017070514799Battery Pack · dischargedLT OVERWING EMERGENCY LIGHT INOP. R&R BATTERY PACK PER AMM.SDR IPXA2017070518937Battery · inoperativeUPPER DECK EMERGENCY LIGHTS L1533, L5733, L5767, AND M4915 INOPERATIVE. REPLACED THE EMERGENCY LIGHT BATTERY (M5169 )IAW AMM 33-51-04-902-001-001, REV 89.01, AND PERFORMED AN EMERGENCY LIGHT TEST, RESULTS WERE SATISFACTORY.SDR MASA2017070512437Lamp · inoperativeROW 12 OVERHEAD EMERGENCY FLOOD LIGHT INOPERATIVE. REPLACED THE LAMPS.SDR MASA2017070512436Light · inoperativeROW 14 OVERHEAD EMERGENCY FLOOD LIGHT INOPERATIVE.SDR DALA2017070505188Battery Pack · inoperativeWHILE PERFORMING A SERVICE CHECK, FOUND FIRST CLASS OVERHEAD CEILING LIGHTS, EMERGENCY LIGHTS INOPERATIVE. INSTALLED A NEW BATTERY IAW AMM 33-51 OPS CHECKED OK. OK FOR SERVICE.SDR CALA2017070702101Charger · inoperativeEMERGENCY BATTERY CHARGER INOP. M33404 EMERGENCY BATTERY CHARGER REPLACED.SDR CALA2017070702100Battery Pack · dischargedZONE 2 AFT AREA EMERGENCY CEILING LIGHT FOUND DIM. ZONE 2 AFT AREA EMERGENCY CEILING LIGHT BATTERY(M33404) REPLACED AND TESTED NORMAL AMM 33-51-06.SDR AALA201707079019Cover · missingTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN COVER MISSING FROM LEFT AFT GALLEY. REPLACED LEFT AFT GALLEY DOOR EMERGENCY LIGHT PER AMM 33-51-00. OPS CHECKS GOOD.SDR AALA201707079018Sign · brokenTHE AIRCRAFT WAS NOT GROUNDED. EXIT LIGHT SIGN AT DOOR 1R LOWER EDGE GALLEY BROKEN. REPLACED LIGHTED EXIT SIGN AT 1R DOOR PER MM 33-51-01, CHECKS GOOD.SDR AALA201707079016Sign · damagedTHE AIRCRAFT WAS NOT GROUNDED. RIGHT AFT DOOR EXIT IDENTIFIER LENS ASSY RETAINER CLIPS BROKEN. REPLACED EXIT SIGN IDENTIFIER ASSY IAW/AMM 33-51-01 SIGN POS CKD NML.SDR AALA201707079015Lens · unsecureTHE AIRCRAFT WAS NOT GROUNDED. LENS ATTACH VIA TAPE EMERGENCY EXIT LIGHT 1R DOOR LENS FELL OFF. REPLACED LENS COVER AND BEZEL AT R1 DOOR IAW MM 25-60-00.SDR AALA20170704002Battery Pack · faultyFWD EMERGENCY LIGHTS A VERY DIM WHEN POWERED BY THE AB5-1 BATTERY PACK . REMOVED AND REPLACED THE BATTERY PACK. EMERGENCY LIGHTS OP CHECKED NORMAL.SDR AALA201707059019Power Supply · faultedEMERGENCY POWER SUPPLY UNIT 11WL BY THE LEFT OVERWING ESCAPE HATCH SHOWED FAULTS DURING TEST. RESET EPSU IAW AMM 33-51-00. OPERATIONAL CHECKED GOOD.SDR AALA201707059033Lens · missingEMERGENCY EXIT LIGHT LENS MISSING ABOVE THE R4 DOOR. REPLACED MISSING LENS AT 4R DOOR AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201707059024Lens · missingR4 DOOR EMERGENCY EXIT LIGHT COVER MISSING. MAINTENANCE INSTALLED A NEW LENS. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201707059003Light · looseL3 EXIT SIGN LOOSE AND A SCREW MISSING. REPLACED LIGHT FRAME ASSY.SDR AALA20170705001Power Supply · no testEMERGENCY POWER SUPPLY UNIT SYSTEM TEST (CIDS 1), ACTIVE FAULT AT (14WL) MID RIGHT. REPLACED THE POWER SUPPLY IAW AMM 33-51-38. ACCOMPLISHED A SATISFACTORY OPERATIONAL TEST IAW AMM 33-51-00.SDR SWAA2017070614826Lens · missingRIGHT OVERWING EXIT LIGHT LENS MISSING. INSTALLED A NEW LENS IAW AMM.SDR SWAA2017070614810Charger · inoperativeRIGHT EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE BATTERY PACK CHARGER IAW MM.SDR DALA2017070505232Power Supply · inoperativeEMERGENCY LIGHT IS INOPERATIVE AT ROWS 6-19 BOTH AB AND FG SEATS. REPLACED THE POWER SUPPLY AND BATTERY. SYSTEM OPERATION IS NORMAL.SDR A6WA201745084Sign · inoperativeEXIT SIGN INOPERATIVE. REMOVED AND REPLACED EMERGENCY EXIT SIGN IAW AMM 33-51-10, OPS CHECKED GOOD.SDR RAIA201707040001Lens · crackedSERVICE DOOR FLOOD LIGHT HAS A CRACKED LENS. R & R THE LENS, OPS CHECKED GOOD.SDR AALA201707059004Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT COVER LENS MISSING AT DOOR 4L. REPLACED WALL MOUNT EMERGENCY LIGHT ASSEMBLY.SDR ASAA2017070421262Lens · detachedMID-CABIN OVERHEAD EXIT ROW SIGN DAMAGED. ACFT GROUNDED. FOUND BOTH MID-CAIN CEILING EXIT SIGN LENS COVERS OFF. CHECKED CONDITION OF BOTH LENS COVERS AND HOLDER OK. REINSTALLED LENS IAW AMM 33-51-01-960-801.SDR ASAA2017070421261Cover · detachedEXIT SIGN COVER FOUND ON FLOOR IN FORWARD GALLEY. ACFT GROUNDED. ATTACHED EXIT SIGN, OK FOR SERVICE.SDR SWAA2017070514798Lens · missingR1 DOOR EXIT SIGN LENS MISSING. INSTALLED LENS PER SIP.SDR MASA2017070412433Light · inoperativeROW13 EMERG EXIT LIGHTS INOP. RELAMPED.
Back to JASC 3350