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 AALA201708089049Light · dislodgedTHE AIRCRAFT WAS NOT GROUNDED. FLOOR LIGHT ON FORWARD CLOSET IS DISLODGED AND MISSING COVER. REMOVED AND REPLACED EMERGENCY FLOOR LIGHT, TEST OK IAW AMM 33-51-05.SDR AALA201708109004Sign · brokenLOWER EMERGENCY EXIT SIGN BROKEN OFF OF LOWER FASTENER AT R2 DOOR. REPLACED EMERGENCY LIGHT IAW AMM 33-51-13.SDR AALA201708109003Sign · brokenLOWER EMERGENCY EXIT SIGN BROKEN OFF OF LOWER FASTENER. REPLACED EMERGENCY LIGHT AT R1 DOOR IAW AMM 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201708099018Lens · brokenAIRCRAFT WAS NOT GROUNDED. BROKEN EMERGENCY PATH LIGHT LENS / COVER AT LAVATORY L. REPLACED LIGHT LENS ASSEMBLY PER MM 33-51-19-400.SDR AALA201708089013Lens · brokenAIRCRAFT WAS NOT GROUNDED. BROKEN EMERGENCY PATH LIGHT LENS COVER AT LAVATORY D. REPLACED LIGHT LENS ASSEMBLY PER MM 33-51-19-400.SDR AALA201708099002Power Supply · faultyFOUND AFT POWER SUPPLY UNIT FAULTY. REMOVED AND REPLACED AFT POWER SUPPLY UNIT IAW AMM.SDR REXA2017080600858Light · inoperativeEMERGENCY LIGHT SECTION JUST AFT OF EXIT ROW NOT ILLUMINATING. REMOVED AND REPLACED THE EMERGENCY LIGHT SECTION IAW AMM 33-51-01.SDR AALA201708079034Power Supply · no testFOWARD EMERGENCY POWER SUPPLY UNIT WILL NOT TEST. REPLACED FWD EPSU IAW AMM 33-51-38. OPS CHECKED GOOD.SDR AALA201708079031Power Supply · inoperativeEMERGENCY LIGHT AT 3L AND 3R INOPERATIVE. REPLACED EMERGENCY POWER SUPPLY UNIT AT 3R DOOR.SDR AALA201708079030Lens · missingRED EMERGENCY LIGHT LENS MISSING AT 8C. INSTALLED THE RED LENS.SDR AALA201708079029Power Supply · no testEMERGENCY LIGHTS FAILED TO TEST. REPLACED EMERGENCY POWER SUPPLY UNIT.SDR AALA201708079026Lens · crackedEMERGENCY EXIT COVER FELL OFF AND CRACKED. REPLACED EMERGENCY EXIT COVER, OPS GOOD.SDR DALA2017080700209Bulb · missingSEAT 11B MISSING EMERGENCY PROXIMITY LENS AND BULBS. REPLACED BULBS AND LENS.SDR ASAA2017080621546Power Supply · no testWHILE PERFORMING T/C 78233001 EMERGENCY LIGHTING OPS CHECK, FOUND BATTERY PACKS M1674, FAILED TO TEST. ACFT GROUNDED. POWER SUPPLY REMOVED AND REPLACED FOR M1694 IAW AMM 33-51-06-960-806.SDR HNAA2017080700264Light · inoperativeROW 12 RT SIDEWALL EMERGENCY LIGHT INOPERATIVE. R & R ROW 12 EMERGENCY LIGHT IAW AMM 33-50-14-400-801-A, OPS CHECKED GOOD.SDR MASA2017080612516Battery Pack · dischargedTWO AFT OVHD EMER FLOOD LIGHTS INOP. REPLACED BATT PACK NR 4.SDR MASA2017080612515Battery Pack · dischargedROW 18RH LWR EXIT SIGN INOP. REPLACED BATT PACK NR 4.SDR SWAA2017081515674Sign · brokenL1 DOOR LOWER FORWARD BULKHEAD EXIT SIGN BROKEN. REPAIRED SIGN PER EA.SDR SWAA2017081415639Bulb · inoperativeLEFT PASSENGER CABIN STOW BIN EMERGENCY LIGHT INOPERATIVE AT ROW 20. R & R THE BULB IAW AMM.SDR FDEA201708052120Power Supply · no testDURING AN EMERGANCY LIGHT TEST, RECEIVED EMERGANCY LGHT BATTERY 1 LOW. REMOVED AND REPLACED THE POWER SUPPLY IAW MM 33-51-01-4. OPS GOOD.SDR AALA201708089014Battery · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT SYSTEM TEST FAILED BATTERY 14WL. REPLACED BATTERY (14WL) PER AMM 33-51-38. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201708089009Lens · missingAIRCRAFT WAS NOT GROUNDED. EXIT SIGN MISSING AIRCRAFT RIGHT (WINDOW). REPLACED EXIT SIGN LENS FOR RIGHT WINDOW PER AMM 33-51-01.SDR SWAA2017080815572Light · inoperativeL2 DOOR EXTERNAL EMERGENCY FLOOD LIGHT INOP. RELAMPED LIGHT PER SIP.SDR SWAA2017080815522Light · inoperativeL1 DOOR EXTERNAL EMERGENCY FLOOD LIGHT INOP. RELAMPED LIGHT PER SIP.SDR IPXA2017080720237Lamp · inoperativeEXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP AND OPS CHECKED GOOD IAW AMM 33-51-16.SDR DALA2017080706092Cover · missingAFT LEFT DOOR EMERGENCY LIGHT COVER LOWER, MISSING. INSTALLED THE COVER. OK FOR SERVICE.SDR AALA201708089045Lens · damagedTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY AISLE LIGHT LENS ON ROWS 10D, 15C ARE DAMAGED. EMERGENCY AISLE LIGHT LENS ON ROWS 10D, 15C WERE REPLACED IAW AMM 33-51-03 GOOD FOR SERVICE.SDR REXA2017080500859Light · looseEMERGENCY LIGHT STRIP LOOSE AT SEAT 12 C/D. SECURED THE EMERGENCY LIGHT IAW AMM 33-51-01.SDR AALA201708079033Lens · missingL4 DOOR EMERGENCY EXIT LIGHT LENS MISSING. REPLACED IAW AMM 33-51-13.SDR AALA201708079032Lens · missingSEAT MOUNTED EMERGENCY LIGHT LENS MISSING AT SEAT 26A. REPLACED THE LENS.SDR AALA201708079028Lens · missingL2 DOOR EMERGENCY LIGHT LENS MISSING. INSTALLED LENS IAW AMM.SDR AALA201708079021Battery · failedAIRCRAFT WAS NOT GROUNDED. EPSU BATTERY TEST 11WL FAILED. REPLACED 1L 11WL EPSU BATTERY.SDR SWAA2017080715516Sign · looseCEILING OVERWING EXIT SIGN LOOSE. SECURED SIGN PER AMM.SDR MASA2017080512514Light · inoperativeROW 17 EMER LIGHT INOP. PLACED ON MEL.SDR SIMA20170804004Light · crackedSEVERAL EMERGENCY LIGHTS ARE CRACKED. REMOVED AND REPLACED THE EMERGENCY LIGHTS IAW AMM 33-50-12.SDR SWAA2017081115569Light · inoperativeLT EMERGENCY BIN LIGHT INOP AT ROW 16. RELAMPED LIGHT PER AMM.SDR DALA2017080706128Light · looseEMERGENCY SEAT MOUNTED LIGHTING ARE INOPERATIVE AT 40F. SECURED LIGHT MODULE. SYSTEM OPERATION IS NORMAL.SDR SWAA2017080815542Fuse · blownLT OVERWING EMERGENCY EXIT SIDEWALL LIGHT INOP. R&R FUSE PER MM.SDR AALA201708089043Sign · detachedTHE AIRCRAFT WAS NOT GROUNDED. AFT RIGHT EMERGENCY EXIT SIGN COVER KEEPS COMING OFF. REMOVED AND REPLACED AFT RIGHT SERVICE DOOR EXIT SIGN LIGHT ASSEMBLY AS PER AMM 33-51-01. OPS CHECK GOOD.SDR AALA201708089042Light · damagedTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT ASSY IN DOOR PASSENGER AFT DAMAGED. EMERGENCY EXIT LIGHT ASSY IN DOOR PASSENGER AFT WAS REPLACED IAW AMM 25-63-00.SDR AALA201708089041Cover · missingTHE AIRCRAFT WAS NOT GROUNDED. 4R DOOR EXIT LIGHT COVER MISSING. REMOVED & REPLACED 4R DOOR EXIT SIGN ASSY. PER IAW AMM 33-51-01. OPS CHK OK.SDR AALA201708089011Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. PERFORMED EMERGENCY POWER SUPPLY UNIT TEST, FOUND EMERGENCY BATTERY POSITION 13WL FAULT. REPLACED BATTERY PACK 13 WL (AFT) PER MM 33-50-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201708089010Light · brokenAIRCRAFT WAS NOT GROUNDED. SEAT ROW 11ABC MOUNTED EMERGENCY PATH LIGHT BROKEN. REPLACED EMERGENCY LIGHT 11ABC PER AMM 33-51-18.SDR AALA201708089027Lens · unsecurePLASTIC EXIT COVER CAME OFF AFT RIGHT DOOR. INSTALLED EMERGENCY EXIT SIGN COVER.SDR DALA2017080600210Power Supply · inoperativeLOWER EMERGENCY LIGHTS IN MID BUSINESS CLASS INOPERATIVE. REPLACED POWER PACK M33098.SDR DALA2017080600208Power Supply · inoperativeEMERGENCY LIGHTS AT SEAT ROWS 10-12 INOPERATIVE. REPLACED EMERGENCY LIGHT POWER SUPPLY AND BATTERY PACK M33098.SDR AALA201708079019Power Supply · failedAIRCRAFT WAS GROUNDED. EMERGENCY LIGHT POWER UNIT NR 6 FAILED FUNCTIONAL TEST. REPLACED EMERGENCY POWER SUPPLY UNIT NR 6.SDR AALA201708079018Power Supply · failedAIRCRAFT WAS GROUNDED. EMERGENCY LIGHT POWER UNIT NR 5 FAILED FUNCTIONAL TEST. REPLACED EMERGENCY POWER SUPPLY UNIT NR 5.SDR AALA201708079017Power Unit · failedAIRCRAFT WAS GROUNDED. EPLU NR 2 FAILED FUNCTIONAL TEST. REPLACED EMERGENCY LIGHT POWER UNIT.SDR AALA201708079016Power Supply · failedAIRCRAFT WAS GROUNDED. EMERGENCY LIGHT POWER UNIT 1 FAILED FUNCTIONAL TEST. REPLACED EMERGENCY POWER SUPPLY UNIT NR 1.
Back to JASC 3350