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 IPXA2017072419696Lamp · inoperativeLAVATORY MIRROR AUX LIGHT INOPERATIVE. REPLACED THE LAMPS LAVATORY MIRROR LIGHT IAW AMM 33-51-21-0401. OPS CHECKED GOOD.SDR AALA20170722002Battery Pack · no testEMERGENCY POWER SUPPLY UNIT BATTERY 11WL FAILED TO TEST. REPLACED EMERGENCY POWER SUPPLY BATTERY PACK IAW AMM 33-51-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR SIMA20170722001Lamp · inoperativeWHILE PERFORMING PS-1 CHECK, FOUND RT OVERWING EMERGENCY LIGHT LAMP NOT WORKING. R & R THE LAMP IAW AMM 33-50-10. OPS CHECKED GOOD.SDR MASA2017072212482Light · inoperativeROW 14 CEILING FLOOD LIGHT INOP. PLACED ON MEL.SDR AALA20170728015Power Supply · inoperativeAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY EXIT LIGHT IN THE RIGHT AFT ZONE CEILING IS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY M33401 PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA201707269021Lens · missingAIRCRAFT WAS NOT GROUNDED. 4L DOOR EMERGENCY LIGHT COVER MISSING. MAINTENANCE REPLACED EXIT LIGHT LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201707269020Light · inoperativeAIRCRAFT WAS NOT GROUNDED. 4R JUMPSEAT EXIT LIGHT INOPERATIVE. MAINTENANCE REPLACED EMERGENCY EXIT MARKER LENS PER AMM 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201707269019Lens · missingAIRCRAFT WAS NOT GROUNDED. 4R EMERGENCY EXIT LIGHT COVER, MISSING. MAINTENANCE REPLACED EXIT LIGHT LENS COVER AT R4 DOOR AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201707269018Lens · missingAIRCRAFT WAS NOT GROUNDED. SEAT 3 LEFT EMERGENCY LIGHT LENS MISSING. REPLACED LED LIGHT ASSEMBLY PER AMM 33-51-19. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201707269013Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE L2 DOOR HAS A MISSING LENS COVER. REPLACED LENS COVER. OPERATIONAL CHECK GOOD.SDR SWAA2017072515281Light · inoperativeEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R LIGHT PER AMM.SDR SWAA2017072515280Light · inoperativeLT EXTERIOR ESCAPE HATCH EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2017072515266Light · inoperativeEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R&R LIGHT PER AMM.SDR DALA2017072405679Light · inoperativeEMERG LIGHT UNDER O/H BAG BIN AT SEATS 17 AB AND 19 AB INOP. RELAMPED OVERHEAD EMERGENCY LIGHTS AT ROW 17 AND 19AB PER AMM 33-50. OPS CHECK GOOD.SDR SWAA2017072515232Lens · crackedLEFT OVERHEAD BIN BULLNOSE EMERGENCY LIGHT LENS CRACKED BETWEEN ROWS 6 TO 10. R & R THE LENS IAW SIP.SDR SWAA2017072515231Cover · looseOVERHEAD OVERWING EXIT SIGN LIGHT PLATE COVER LOOSE. SECURED THE COVER IAW MM.SDR HNAA2017072500247Battery · dischargedFWD RT EXTERNAL EMERGENCY LIGHT INOPERATIVE, GALLEY CEILING, RT FWD EMERGENCY EXIT TOP, NOT WORKING . CHANGED THE BATTERY AT 3351 PS2 LOCATION IAW AMM 33-51-00, OPS CHECKED GOOD.SDR JJBA20170721025Inverter · inoperativeAISLE EMERGENCY LIGHT INOPERATIVE. R & R THE NR 4 INVERTER, OPS CHECKED GOOD.SDR AALA201707249039Lens · missingR3 DOOR EMERGENCY EXIT LIGHT MISSING THE LENS. REPLACED R3 DOOR EMERGENCY EXIT LIGHT IAW AMM 33-51-13.SDR AALA201707249038Lens · missingR2 DOOR EMERGENCY EXIT LIGHT MISSING THE LENS. REPLACED R2 DOOR EMERGENCY EXIT LIGHT IAW AMM 33-51-13.SDR AALA201707249009Lens · missingR1 DOOR EMERGENCY EXIT LIGHTS MISSING THE LENS. REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-13.SDR AALA201707249049Battery Pack · dischargedTHE AIRCRAFT WAS NOT GROUNDED. FIRST CLASS EMERGENCY CABIN LIGHTS INOP. REMOVED AND REPLACED EMERGENCY BATTERY PACK B5-100 PER AMM 33-53-00. OPS CHECK OK.SDR AALA201707249048Cover · brokenTHE AIRCRAFT WAS NOT GROUNDED. FWD GALLEY SERVICE DOOR EMERGENCY EXIT LIGHT COVER BROKE OFF. REPLACED FWD GALLEY SERVICE DOOR EMERGENCY EXIT LIGHT ASSY PER MM 33-51-01 OPS CHECKS NORMAL.SDR AALA201707249047Sign · looseTHE AIRCRAFT WAS NOT GROUNDED. F/C GALLEY EXIT LIGHT LOOSE AND WILL NOT STAY ON. REMOVED AND REPLACED EXIT SIGN ASSY IAW AMM 33-51-01 OPS CKS GOOD IAW AMM 33-51-01.SDR AALA201707249046Lens · brokenTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT COVER LENS BROKEN AT GALLEY AISLE POSITION. REMOVED AND REPLACED FLOOR PROXIMITY FLOODLIGHT AND LENS COVER PER AMM 33-51-14. OPERATIONAL CHECK GOOD.SDR DALA2017072405646Charger · inoperativeEMERGENCY LIGHTS ARE INOPERATIVE AT 24FG-32FG. REPLACED BATTERY PACK CHARGER AT 24FG. SYSTEM OPERATION IS NORMAL.SDR SWAA2017072415172Sign · brokenAFT RT EMERGENCY EXIT SIGN BROKEN. R & R THE SIGN IAW AMM.SDR DALA2017072405644Battery Pack · inoperativeDURING A SERVICE CHECK, FOUND SEAT ROWS 1-3, 10-12 AND FWD GALLEY EMERGENCY LIGHTS INOPERATIVE. REPLACED THE BATTERY PACK.SDR AALA201707249028Lens · missingRED LENS MISSING ON A EMERGENCY LIGHT. REPLACED THE RED EMERGENCY LENS.SDR CALA2017072102338Battery Pack · failedAFT LT EMER LIGHT BATTERY PACK FAILS CAP CHECK. REMOVED AND REPLACED AFT LT EMER LIGHT BATTERY PACK. OPS CHECK GOOD. REF 33-51-38-400-002-A.SDR CALA2017072102337Battery Pack · failedLT EMER LIGHT BATTERY PACK FAILS CAP CHECK. REMOVED AND REPLACED LT EMER LIGHT BATTERY PACK, OPS CHECK GOOD REF 33-51-38-400-002-A.SDR CALA2017072102336Battery Pack · failedRT EMER EXIT BATTERY PACK FAILS CAP CHECK. REPLACED RT EMER EXIT BATTERY PACK PER AMM 33-51-38-400-002-A. OPS CHECK GOOD.SDR CALA2017072102335Battery Pack · failedLT FWD EMER LIGHT BATT PACK FAILS CAP CHECK. REPLACED LT FWD EMER LIGHT BATTERY PACK PER AMM 33-51-38-400-002 -A. OPS CHECK GOOD.SDR CALA2017072102333Lens · brokenEMERGENCY EXIT LIGHT LENS BROKEN ON RIGHT SIDE OF AIRCRAFT. REPLACED EMERGENCY EXIT LIGHT LENS ON RIGHT SIDE OF AIRCRAFT.SDR CALA2017072102331Light · inoperativeDOOR 2L EXTERIOR EMERGENCY LIGHT INOP. RELAMPED BULB. OPS CHK GOOD.SDR CALA2017072102330Light · not seatedR1 DOOR, EXT EMERGENCY LIGHT INOP. RESEAT BULB OPS CHECK GOOD.SDR CALA2017072102329Battery Pack · dischargedLT AFT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED EMERGENCY LIGHTS POWER SUPPLY BATTERY PACK AT LOCATION M1670 REF AMM33-51-06. OPS CHECK GOOD.SDR CALA2017072102318Light · inoperativeEXTERNAL EMERGENCY EXIT LIGHT AFT OF RT WING TO BODY FAIRING IS INOP. RE-LAMPED LIGHT ASSY OPS CKS GOOD.SDR CALA2017072102317Unknown · malfunctionedEMER EXIT LIGHT OVER EXIT ON RT HAND SIDE OVERWING CAME ON DURING APPROACH. LIGHT EXTINGUISHED. SYSTEM OPS CHECKS GOOD.SDR CALA2017072102315Light · brokenROWS 4,5,6 SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHTS DO NOT WORK WITH ALL EMERGENCY SWITCH IN CABIN AND INCLUDING P5 PANEL SWITCH. TROUBLESHOT BATTERY PACK FUSE SHORT PER WDM 33-51-15. FOUND ROW 5D SEAT EEL ASSY BROKEN REPLACED OPS CHECK GOOD.SDR CALA2017072102314Light · brokenGALLEY CTR LEFT A4 GALLEY CTR TTL 3EA LWR EMER LIGHTS FOUND BROKEN. M/D M1 GALLEY CTR A4 GALLEY CTR TTL 3EA LWR EMER LIGHTS REPLACED & FUNCTIONAL TEST C/O FOUND "STATIS" REF AMM 33-51-05-9 60-802 REV 80.SDR CALA2017072102313Light · brokenA & B ZONE PARTITION 4EA LWR EMER LIGHTS FOUND BROKEN. M/D A & B ZONE PARTITION 4EA LWR EMER LIGHTS REPLACED & FUNCTIONAL TEST C/O FOUND "STATIS" REF AMM 33-51-05-960-802 REV 80.SDR CALA2017072102312Light · broken6G, 8C SEAT LWR EMER LIGHTS 2EA FOUND BROKEN. M/D SEAT 6G/8C SEAT LWR EMER LIGHTS REPLACED & FUNCTIONAL TEST C/O FOUND "SATIS" REF AMM 33-51-05-960-802 REV 80.SDR CALA2017072102311Light · inoperativeEMERGENCY EXIT GUIDE LIGHT IS INOP AT SEAT 55H. REPLACED AND SECURED NEW LIGHT STRIP. OP CHK OK. ACP'D IDT INSPECTION ON EEL LIGHT STRIP AT SEAT 55H, SECURED AND OP CHK GOOD.SDR CALA2017072102309Power Supply · inoperativeEMERGENCY LIGHTS L5195 AND L1166 AFT OF LT BODY FAIRING ARE INOP. RPL BATT POWER SUPPLY M7919 REF WD 33-51-42 P1 AND AMM33-51-04-9 02-001-002 AND OP TEST OK. VERIFIED OPERATION, SAFETY AND SECURITY.SDR CALA2017072102308Light · inoperativeEMERGENCY LIGHT INOP AT CEILING LIGHT ROW 22 ABC. RELAMPED LIGHT ASSY CEILING LIGHT AT ROW 22ABC AND CKS OK. VERIFIED OPERATION, SAFETY AND SECURITY.SDR CALA2017072102328Lens · brokenAFT EMERGENCY EXIT SEAT LIGHT LENS BROKEN AT 20C. REPLACED LENS AT SEAT 20C. EMERGENCY EXIT SEAT LIGHT OPS CHECK NORMAL.SDR CALA2017072102327Lens · missingEMERGENCY PATH LIGHT ON LOWER BULKHEAD IN FRONT OF SEAT 2B IS MISSING ITS COVER. INSTALLED NEW LENS CAP, LIGHT OPS CKS OK.SDR CALA2017072102324Lens · missingEMERGENCY EXIT SIGN LENS AT LAV M MISSING. REPLACED MISSING EXIT SIGN LENS AT LAV M. OPS CK GOOD.SDR CALA2017072102321Light · inoperativeR1 DOOR EXTERIOR SLIDE LIGHT INOP. REMOVED AND REPLACED LAMP FOR R1 SLIDE LIGHT. OPS CHECKS GOOD. REF MM 33-51-06.
Back to JASC 3350