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 SIMA20180701011Light · damagedCABIN FLOOR LT #4 EMERGENCY LIGHT STRIP DAMAGED AT AFT END. C/A-COMPLETE:INSTALLED EXISTING LIGHT STRIP IN NEW EXTRUSION IAW 33-50-12.SDR SIMA20180701012Light · damagedCABIN FLOOR LT #6 EMERGENCY LIGHT STRIP DAMAGED AT FWD AND AFT END. C/A-COMPLETE:INSTALLED EXISTING LIGHT STRIP IN NEW EXTRUSION IAW 33-50-12SDR SWAA2018071123407Sign · damagedFORWARD LAVATORY LOWER EMERGENCY EXIT SIGN ON AFT WALL HOUSING DAMAGED. R&R SIGN IAW AMM.SDR DALA2018070304371Battery · dischargedEXIT LIGHTS AT OVER WING EXIT LT SIDE OF A/C WILL NOT EXTINGUISHED. REPLACED EMERG LIGHTS BATTERY AND CHARGER PER AMM 33-51 LIGHTS TEST AND OP OK.SDR SWAA2018070323302Cover · missingLT OVERHEAD OVERWING EXIT SIGN MISSING. INSTALLED COVER PER SIP.SDR SWAA2018070323298Power Supply · failedEMERGENCY LIGHTS BATTERY FAILED TEST AT LOCATION M1675. R&R POWER SUPPLY IAW AMM.SDR SWAA2018070323297Sign · disconnectedR2 DOOR OVERHEAD EMERGENCY EXIT SIGN INOP. RECONNECTED SIGN PER AMM AND WDM.SDR SWAA2018070223263Charger · faultyRT AFT CABIN EMERGENCY LIGHTS CHARGER CIRCUIT BREAKER FOUND OPEN. R&R BATTERY CHARGER IAW AMM.SDR SWAA2018070223186Sign · unsecureRT EXIT ROW SIGN CAME OFF. INSTALLED LIGHT PER AMM.SDR SCNA20180701094Battery Pack · dischargedEMERG LIGHTS AT ROWS 5, 6, 7, 9, AND 10 DO NOT WORK. REMOVED AND REPLACED LT AND RT BATTERY PACKS AT ROW 7AC/7FD. OPS CHECK NORMAL.SDR AALA201807039009Battery Pack · failedESPU SYSTEM TEST FAILED. REMOVED AND REPLACED THE ESPU BATTERY IAW AMM 33-51-38. OPS CHECKED GOOD. OK FOR SERVICE.SDR CALA2018070301569Battery · dischargedM/D LLAR EMER LT BATTERY 1EA FOUND LOW CAPACITY. REPLACED THE CABIN LLAR EMERGENCY LT PWR PACK BATTERY AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-06-960-802 REV 83.SDR CALA2018070301568Light · brokenM/D MID GALLEY, 5EA LWR EMER LIGHTS FOUND BROKEN. REPLACED THE CABIN MID GALLEY 5EA LWR EMERGENCY LIGHTS AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-05-960-802 REV 83.SDR CALA2018070301567Light · brokenM/D A & B ZONE CTR PARTITION, 4EA LWR EMER LIGHTS FOUND BROKEN. REPLACED THE CABIN ZONE A & B CTR PARTITION TOTAL 4EA LOWER EMERGENCY LT AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33 -51-05-960-802 REV 83.SDR CALA2018070301566Light · brokenM/D A4 GALLEY LT 1EA LWR EMER LT FOUND BROKEN. REPLACED THE CABIN A4 GALLEY LT SIDE 1EA LWR EMERGENCY LIGHT AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-05-960-802 REV 83.SDR CALA2018070301565Lens · brokenFLIGHT CREW LEFT RED EMERGENCY EXIT LIGHT LENS IN FLIGHT DECK. REPLACED BROKEN RED LENS FOR SEAT 20F EMERGENCY LIGHT. OPS CHECK NORMAL REF AMM 33-51-10.SDR REXA2018070300588Battery Pack · dischargedEMERGENCY LIGHTS ONLY WORK FOR A FEW SECONDS WHEN "ON". REMOVED AND REPLACED ALL 4 EMERGENCY LIGHT BATTERY PACKS IAW AMM 33-510-04. OPS CHECK GOOD. ALL EMERGENCY LIGHTS ILLUMINATE WITH SWITCH SELECTED TO "ON". A/C OK FOR SVC.SDR AALA201807029045Lamp · inoperativeROW 34ABC EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-19-0401. OPS CHECKED GOOD.SDR MASA2018070113372Light · inoperativeCEILING FLOOD LIGHT ROW 11 INOP. PLACED ON MEL.SDR MASA2018070113370Battery · dischargedROW 18 EXIT SIGN INOP. CHARGED BATTERIES.SDR MASA2018070113369Battery · discharged2 FWD CABIN CEILING FLOOD LIGHTS INOP. CHARGED BATTERIES.SDR MASA2018070113368Battery · dischargedROW 7C EXIT SIGN INOP. CHARGED BATTERIES.SDR SIMA2018072630004Light · loose1A CEILING PANEL EMERGENCY LIGHT LOOSE. REBONDED 1A CEILING PANEL EMERGENCY LIGHT IAW AMM 33-50-15.SDR SIMA2018072630005Battery · dischargedFLOOR PROXIMITY LIGHTING STRIPS 6, 7 8 NOT LIT. R&R NR 4 EMERGENCY LIGHTING BATTERY ASSEMBLY AND R&R NR 6 LIGHT STRIP ONTO PANEL COVER IAW AMM 33-50-04. OPS CHECK GOOD.SDR IPXA2018070231300Screw · missingEXT EMERG EGRESS LIGHT ASSY MISSING 3 SCREWS. INSTALLED 3 EA MISSING SCREWS IAW MM 33-51-06-201-3.SDR SWAA2018070323290Lens · brokenR2 DOOR EXIT SIGN LENS BROKEN. R&R LENS PER MM.SDR SWAA2018070223256Lens · looseAFT DOOR EXIT SIGN LENS LOOSE. REINSTALLED LENS PER SIP.SDR SWAA2018070223246Sign · brokenCENTER AISLE OVERHEAD OVERWING EXIT SIGN BROKEN AT ROW 12. R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2018070223244Lens · brokenR2 DOOR EXIT SIGN LENS BROKEN. R&R LENS PER MM.SDR REXA2018070300591Light · inoperativeLT AFT OVERWING EXTERIOR EMERGENCY LIGHT. R&R LT EXTERIOR AFT OVERWING EMERGENCY LIGHT HOUSING ASSY IAW AMM 33-51-15.SDR CALA2018070301564Power Supply · failedRR DOOR 1 M33096 EMER CAPACITY CHECK FOUND FAIL. RT DOOR 1 M33096 EMER LT POWER SUPPLY REPLACED AND TEST NORMAL AS PER AMM 33-51-06.SDR DALA2018070304345Light · inoperativeFWD GALLEY EMER. EXIT SIGN HAS SEVERAL INOP BULBS. RELAMPED FWD GALLEY EMER EXIT SIGN LIGHT BULBS PER AMM 33-51-18. OPS CHECKS GOOD.SDR AALA201807029036Lens · brokenTHE AIRCRAFT WAS NOT GROUNDED. BROKEN DOOR FRAME LINING PANEL 262VW LENS EXIT IN PASSENGER CABIN. REPLACED LENS EXIT AT DOOR FRAME PANEL 262VW IN PASSENGER CABIN PER AMM 33-51-13-400-001-A.SDR ASAA2018070225251Lens · missingAFT RIGHT HAND EMERGENCY EXIT DOOR LOWER EMERGENCY LIGHT ASSEMBLY COVER MISSING. GROUNDED - YES. INSTALLED NEW COVER ASSEMBLY FOR EXIT LIGHT ASSEMBLY, L1188 OPS CHECK NORMAL PER AMM 33-51-00-710-801.SDR ASAA2018070225243Sign · unsecureFA REPORTS MID CABIN EXIT SIGN FELL DOWN. GROUNDED - YES. REINSTALLED PLASTIC EXIT SIGN HALF AT MID CABIN OVERHEAD PANEL. EXIT SIGN ASSEMBLY SECURE GOOD FOR SERVICE.SDR HALA2018070200321Light · missingAFT GALLEY EMERGENCY LIGHT STRIP MISSING A PORTION. REPLACED EMERGENCY LIGHT STRIP IAW AMM 33-52, OPS CHECKED NORMAL. OK FOR SERVICE.SDR DALA2018070204326Light · inoperativeCOCKPIT EMERGENCY LIGHTS ARE INOPERATIVE. REPLACED LIGHT ASSEMBLY. SYSTEM OPERATION IS NORMAL.SDR DALA2018070204322Switch · looseEMERGENCY LIGHTS OVERHEAD PANEL SPRING PART OF SWITCH LOOSE. REPLACED EMERGENCY LIGHTS SWITCH GUARD. SYSTEM OPERATION IS NORMAL.SDR DALA2018070204312Fuse · blownEMERGENCY LIGHTS INOP ROW 18-23. REPLACED FUSE AT POWER SUPPLY M733. LIGHTS OP CK NORMAL. OK FOR SERVICE.SDR 29GA2018070100001Battery Pack · dischargedFLIGHT 0075 MCO/EYW REPORT: EMERG LIGHT OUT AT ROW 9A INOP. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY IAW AMM 33-50-10-04-1. OPS CHECKS GOOD IAW AMM 33-50-00-05-1SDR SWAA2018071723502Light · damagedMID CABIN CEILING EXIT LIGHT DAMAGED. R&R LIGHT ASSY PER MM.SDR SWAA2018070223277Light · inoperativeRT EMERGENCY EXIT LIGHTS FORWARD OF OVERWING EXIT ON SIDEWALL BULB INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018070223275Sign · inoperativeFORWARD GALLEY OUTBOARD LOWER EMERGENCY EXIT LIGHT INOP. R&R SIGN PER MM.SDR SWAA2018070223250Fuse · inoperativeEMERGENCY LIGHT ON G4 BULB INOP. R&R FUSE PER MM.SDR SWAA2018070223211Light · inoperativeRT OVERWING EMERGENCY EXIT LIGHT BULB INOP. R&R BULB IAW AMM.SDR SWAA2018070223210Fuse · inoperativeLT OVERWING EMERGENCY EXIT LIGHT BULB INOP. R&R FUSE PER AMM.SDR SWAA2018070223206Light · inoperativeLT EMERGENCY EXIT LIGHTS FORWARD OF OVERWING EXIT ON SIDEWALL BULB INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018070223205Light · inoperativeFORWARD ENTRYWAY EMERGENCY LIGHT BULB INOP ON FORWARD LAV. RELAMPED LIGHT PER AMM.SDR SWAA2018070223191Power Supply · inoperativeRT WING TRAILING EDGE EXTERNAL EMERGENCY LIGHT INOP. R&R POWER SUPPLY PER AMM.SDR SWAA2018070223190Light · inoperativeRT EMERGENCY EXIT SIDE WALL LIGHT INOP. RELAMPED LIGHT PER AMM.
Back to JASC 3350