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 AALA201706159010Lens · missingROW 26C EXIT LIGHT LENS MISSING. REPLACED MISSING THE EXIT LIGHT LENS AT ROW 26.SDR JJBA20170614010Power Supply · inoperativeFA EMERGENCY EXIT LIGHT ON RT SIDE OF THE CABIN IS INOPERATIVE. R & R ASSOCIATED INVERTER POWER SUPPLY OPS CHECK SAT.SDR AALA20170614003Lens · crackedR1 DOOR EMERGENCY EXIT SIGN COVER CRACKED. INSTALLED NEW LENS ON R1 DOOR EMERGENCY LIGHT IAW AMM 33-51-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR MASA2017061412381Light · inoperativeROW 18 CEILING EMERGENCY FLOOD LIGHT INOPERATIVE.SDR MASA2017061412380Switch · failed50 PERCENT OF CABIN EMERGENCY LIGHTS FOUND INOPERATIVE. R & R THE FA PANEL EMERGENCY LIGHT SWITCH.SDR DALA2017061404687Battery Pack · inoperativeEMERGENCY LIGHT TEST FAULTING LT PSEU, REPLACED THE BATTERY.SDR JJBA20170614009Battery Pack · inoperativeALL EMERGENCY LIGHTS INOPERATIVE. R & R THE EMERGENCY LIGHT BATTERIES. OPS CHECKED GOOD.SDR JJBA20170614008Switch · malfunctionedEMERGENCY LIGHT BY GALLEY DOOR INOPERATIVE. RESET EMERGENCY LIGHT SWITCH, OPS CHECKED GOOD.SDR SWAA2017062014510Cover · looseRIGHT EXIT SIGN COVER LOOSE AT ROW 12. SECURED THE COVER IAW SIP.SDR SWAA2017061914470Battery Pack · failedAFT LT EMERGENCY BATTERY PACK FAILED CAPACITY CHECK. R&R BATTERY PACK PER AMM.SDR SWAA2017061914408Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK AT M01669 FAILED CAPACITY TEST. R&R BATTERY PACK PER AMM.SDR SWAA2017061914399Battery Pack · failedAFT RT EMERGENCY BATTERY PACK FAILED CAPACITY CHECK. R&R BATTERY PACK PER AMM.SDR DALA2017061404773Lens · detachedEXIT SIGN LENS AT THE R2 DOOR FELL OFF. SECURED THE LENS COVER IAW AMM 33-50.SDR DALA2017061304772Sign · detachedEXIT SIGN ABOVE THE L2 DOOR FELL OFF. SECURED THE SIGN. OK FOR SERVICE.SDR AALA201706159056Power Supply · dischargedEMERGENCY LIGHTS DO NOT TURN ON. REMOVED AND REPLACED BATTERY POWER SUPPLY AT OVERHEAD BIN 29 IAW AMM 33-60-98-401. OPS CHECKED GOOD, OK FOR SERVICE. THE AIRCRAFT WAS GROUNDED.SDR AALA201706159042Power Supply · dischargedEMERGENCY LIGHTS DO NOT TURN ON. REMOVED AND REPLACED BATTERY POWER SUPPLY AT OVERHEAD BIN 13 IAW AMM 33-60-98-401. OPS CHECK GOOD, OK FOR SERVICE. THE AIRCRAFT WAS GROUNDED.SDR AALA201706159038Power Supply · inoperativeLEFT FWD EMERGENCY EXIT LIGHT INOPERATIVE. REMOVED AND REPLACED THE BATTERY POWER SUPPLY IAW AMM 33-51-06, OPS CHECKED GOOD.SDR DALA2017061404730Charger · inoperativeEMERGENCY LIGHTS FROM SEATS 32ABC TO 41ABC AND FROM SEAT 31GF TO 41GF ARE INOPERATIVE. REPLACED THE BATTERY AND CHARGER. SYSTEM OPERATION IS NORMAL.SDR SWAA2017061514394Cover · brokenCEILING OVERWING EMERGENCY EXIT SIGN COVER BROKEN. R&R LIGHT ASSEMBLY PER MM.SDR SWAA2017061514376Light · brokenR2 DOOR LOWER EMERGENCY EXIT LIGHT LENS BROKEN. R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2017061514365Lens · missingRT FORWARD GALLEY EMERGENCY LIGHT COVER MISSING. INSTALLED LENS ASSEMBLY IAW MM.SDR AALA201706149021Light · missingEMERGENCY EXIT SIGN COVER MISSING BY THE L1 DOOR. REMOVED & REPLACED FWD GALLEY ENTRANCE LIGHT BASE PLATE. OPS CHECKED NORMAL IAW AMM 33-51-14. OK FOR SERVICE.SDR AALA201706149019Sign · detachedEXIT SIGN HAS COME OFF AT THE AFT LEFT DOOR. REPLACED EXIT SIGN IAW MM 33-51-01, CHECKED OK.SDR SWAA2017061414340Cover · missingAFT GALLEY ENTRY HALF WALL EMERGENCY LIGHT LENS COVER MISSING. INSTALLED COVER PER MM.SDR HNAA2017061400208Terminal · damagedEMERGENCY LIGHT NR 4 FROM FWD DAMAGED. REPLACED THE TERMINAL SPLICE, OPS CHECKED GOOD.SDR DALA2017061404688Battery Pack · inoperativeESPU 13WL BATTERY FAULT, REPLACED 13WL BATTERY PACKSDR YENA201706130485Sign · malfunctionedAIRCRAFT'S LEFT EXIT SIGN INOPERATIVE. RESET EXIT SIGN.SDR AALA201706149015Lens · brokenEXIT LIGHT LENS AT THE R4 DOOR FOUND BROKEN. REPLACED EXIT LIGHT LENS.SDR AALA201706149013Battery · dischargedDURING PERIORDIC SERVICE CHECK, FOUND SEAT WALL MOUNTED EMERGENCY LIGHTS AT R3 AND L3 INOPERATIVE. REPLACED THE BATTERY12WL IAW AMM 33-51-01,OPS TESTED OK.SDR AALA201706149012Lens · missingL1 DOOR EMERGENCY EXIT LIGHT MISSING THE LENS. INSTALLED THE LENS IAW AMM 33-51-13-400-001-A, LIGHT OPS CHECKED OK.SDR MASA2017061312378Power Supply · inoperativeFWD FA SEAT EMER EXIT SIGN INOP. REPLACED PWR SUPPLY.SDR MASA2017061312376Light · inoperativePAX DOOR FLOOR FLOOD LIGHT INOPERATIVE.SDR MASA2017061312375Light · inoperativeCELING EMERGENCY FLOOD LIGHT INOPERATIVE ROW 14 AND 17.SDR CALA2017061601821Lamp · inoperativeSEAT 31C MOUNTED EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP, OP CHECKED GOOD.SDR DALA2017061304763Charger · inoperativeL1 EMERGENCY EXIT LIGHT DOES NOT ILLUMINATE DURING TEST. INSPECTED AND FOUND BATTERY PACK AND CHARGER AT FAULT. REMOVED AND REPLACED M731. OPS CHECKED GOOD.SDR SWAA2017061514391Light · brokenR1 DOOR LOWER EMERGENCY EXIT LIGHT BROKEN. R&R LIGHT ASSEMBLY PER MM.SDR SWAA2017061514389Lens · looseFORWARD ENTRY WAY EXIT SIGN COVER LENS LOOSE. SECURED LENS PER MM.SDR SWAA2017061514371Lens · brokenFORWARD ENTRY EMERGENCY EXIT SIGN LENS BROKEN. R&R SIGN ASSEMBLY IAW AMM.SDR DALA2017061404725Light · missingEMERGENCY EXIT LIGHT AT SEAT 34D MISSING. REPLACED LIGHT ASSEMBLY.SDR AALA201706149018Light · missingEXIT LIGHT AT AFT LEFT ENTRY DOOR IS MISSING. REMOVED AND REPLACED AFT GALLEY LEFT EMERGENCY EXIT LIGHT ASSEMBLY. OPS OK IAW AMM 33-51-14.SDR AALA201706149017Lens · missingLENS FOR EMERGENCY EXIT SIGN MISSING AT THE L4 DOOR. R & R THE SIGN ASSY IAW AMM 33-51-01. OPS CHECKED NORMAL.SDR SWAA2017061414359Light · inoperativeR1 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER AMM.SDR HNAA2017061400206Lamp · burned outEMERGENCY FLOOR PATHLIGHTS ARE INOP AT ROWS 2 AND 6. R & R THE EMERGENCY LIGHT LAMPS.SDR AALA201706139011Battery · malfunctionedEMERGENCY POWER SUPPLY TEST FAILED. RESET EMERGENCY BATTERY PACK 13WL EPSU LIGHT TESTED GOOD IAW AMM 33-51-00-10-003ASDR AALA201706139022Light · unsecureEMERGENCY LIGHT ON SIDE TRIM, LOCATED AT 1L FWD CLOSET, WILL NOT STAY IN POSITION ON WALL. REPLACED THE LIGHT IAW SWP 20-30-12 & ACCOMPLISHED OP CHECKED NORMAL IAW AMM 33-51-00.SDR AALA201706139020Sign · dislodgedRIGHT REAR CABIN SERVICE DOOR EMERGENCY EXIT SIGN DISLODGED FROM DOOR. INSTALLED A NEW EXIT SIGN ASSY IAW AMM 33-51-01. OPS CHECKED OK.SDR SWAA2017061314336Lens · unsecureR1 DOOR EMERGENCY EXIT SIGN FELL OFF. R&R LENS ASSEMBLY PER AMM.SDR SWAA2017061314335Lens · crackedRT CABIN OVERHEAD BULLNOSE EMERGENCY LIGHT LENS CRACKED BETWEEN ROW 17 TO ROW 25. R&R LENS PER SIP.SDR SWAA2017061314314Lens · crackedLT CABIN OVERHEAD BULLNOSE EMERGENCY LIGHT LENS CRACKED BETWEEN ROW 16 TO ROW 27. R&R LENS PER SIP.SDR CALA2017061201814Lens · looseSEAT 37C EMERGENCY EXIT LIGHT HANGING LOOSE. SECURED THE LENS AND OPS CHECKED OK.
Back to JASC 3350