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 UHLA201608240423Control Panel · malfunctionedEMERGENCY LIGHT BATTERY FAULT MESSAGE. R & R PASSENGER SIGN PANEL IAW AMM 33-23-07. RAN ACFT APU FOR 10 MINUTES, NO MESSAGE PRESENT.SDR VNAA2016082400031Battery Pack · inoperativeEMERGENCY LIGHTS NOT ILLUMINATING. MAINTENANCE REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK NR ONE AND PERFORMED CHECKS IAW THE AMM. THE AIRCRAFT WAS RELEASED FOR SERVICE.SDR AALA20160825005Power Supply · inoperativeDURING MAINTENANCE WALK AROUND, OBSERVED THE EMERGENCY LIGHT FAILED AT THE L3 DOOR. REPLACED THE POWER SUPPLY IAW AMM 33-51-06.SDR CALA2016082695690Switch · stickingAFT ATTENDANT EMERGENCY LIGHT TEST SWITCH STICKS IN ON POSITION. REPLACED THE PANEL, GROUND TESTED, NO DEFECTS.SDR CALA2016082695688Light · malfunctionedCABIN EMERGENCY LIGHTS CAME ON FOR 8 MINUTES. OCCURRED SAME TIME AS CABIN PRESSURIZED. GROUND CHECKED NORMALSDR CALA2016082695687Lamp · inoperativeEMERGENCY LIGHTS AT SEATS 11C, 29C DO NOT ILLUMINATE WHEN POWER IS OFF. REPLACED THE LAMPS, TESTED OK.SDR DALA2016082606225Battery Pack · inoperativeDURING TEST, FOUND RIGHT AFT EMERGENCY LIGHT INOPERATIVE, WONT TEST. MAINTENANCE R & R THE RIGHT AFT EMERGENCY LIGHT PACK ASSY BATTERY IAW AMM 33-51. OPS CHECKED GOOD.SDR REXA2016082401606Light · malfunctionedEMERGENCY FLOOR TRACK LIGHTING NOT WORKING ROW 2 TO ROW 5. RESET ACFT POWER, PERFORMED OPS CHECK OF EMERGENCY LIGHTS NO DEFECT NOTED IAW AMM 33-51-00SDR UHLA201608240420Warning Message · false indicationEMERGENCY LIGHT BATTERY FAULT MESSAGE. RESET ACFT POWER IAW FIM 33-50-00-810-802-A. FAULT CLEARED.SDR AALA201608259003Lens · brokenAIRCRAFT WAS NOT GROUNDED. SEAT 12C WHITE EMERGENCY ESCAPE PATH LIGHT HAS BROKEN LENS. R & R EMERGENCY LIGHT ASSY AT SEAT 12C. OPS CHECKED NORMAL IAW CMM 25-22-50.SDR SWAA2016082555152Lamp · brokenL1 DOOR EMERGENCY EXIT LIGHT BROKEN. R & R THE LAMP IAW MM.SDR SWAA2016082555151Cover · missingL1 DOOR EXIT SIGN COVER MISSING. INSTALLED THE COVER IAW SIP.SDR SWAA2016082555143Battery Pack · no testBATTERY PACK FAILED CAPACITY CHECK. R & R THE BATTERY PACK IAW AMM.SDR SWAA2016082555142Battery Pack · no testBATTERY PACK FAILED CAPACITY CHECK. R & R THE BATTERY PACK IAW AMM.SDR SWAA2016082555162Battery Pack · no testBATTERY PACK FAILED CAPACITY CHECK. R & R THE BATTERY PACK IAW AMM.SDR ASOA20160825022Inverter · inoperativeRIGHT OVERWING EXIT LOCATOR LIGHT INOPERATIVE. R & R AC/DC INVERTER. OPS CHECK GOOD. AIRCRAFT RELEASED AND RETURNED TO SERVICE.SDR N6WA2016082402Light · inoperativeNR 3 CEILING EMERGENCY LIGHT IS INOPERATIVE. R & R EMERGENCY CEILING LIGHT NR 3 IAW AMM 33-51-09.SDR CALA2016082500582Light · inoperativeUPPER DECK RT SLIDE LIGHT INOPERATIVE. RELAMPED TESTED OK.SDR N6WA2016082401Light · inoperativeEMERGENCY CEILING LIGHT BULB INOPERATIVE. R & R BULB IAW AMM 33-51-09. OPS CHECK GOOD.SDR KCSA201608241061Battery Pack · defectiveEMERGENCY BATTERY PACK WILL NOT HOLD A CHARGE.SDR KCSA201608241060Light · inoperativeEMERGENCY AISLE LIGHT ASSY WON'T LIGHT UP.SDR KCSA201608241059Light · inoperativeEMERGENCY AISLE LIGHT ASSY WON'T LIGHT UP.SDR CALA2016082400578Power Supply · inoperativeEMERGENCY EXIT LIGHTS INOPERATIVE ROWS 21-26 ABC. REPLACED THE BATTERY PACK ON POWER SUPPLY IAW MM33-51-06-960- 805, OPS CHECKED GOOD.SDR CALA2016082400577Power Supply · failedCABIN EMERGENCY LIGHTS ILLUMINATING UNCOMMANDED AT RIGHT OVERWING SLIDE EXIT AREA. REPLACE POWER SUPPLY AND BATTERY PACK M1554 FOR INTERMITTENT ILLUMINATION OF EXIT LIGHTS IN CABINSDR CALA2016082400576Light · inoperativeDURING CHECK, FOUND LT SEAT 5DE FWD MOUNTED EMERGENCY LIGHT WOULD NOT ILLUMINATE. THE LIGHT WAS REPLACED AND TESTED OK IAW AMM 33-51-05SDR MASA2016082412339Light · inoperativeROW 11 CEILING EMERGENCY FLOOD LIGHT INOPERATIVE.SDR MASA2016082412338Light · inoperativeROW 3 CEILING EMERGENCY FLOOD LIGHT INOPERATIVE.SDR MASA2016082412337Bulb · inoperativeSIDEWALL EXIT SIGN 13DF HAD ONE BULB INOPERATIVE.SDR PNSA2016082401Power Supply · failedEMERGENCY LIGHTING POWER SUPPLY FAILED DURING THE 6 MONTH CHECK. POWER SUPPLY 23 LN FAILED.SDR SWAA2016090855597Bulb · inoperativeFORWARD GALLEY CEILING PANEL AREA EMERGENCY EXIT SIGN BULB INOPERATIVE AT BS 400. R & R THE BULB IAW MM.SDR SWAA2016082655175Lens · looseR2 DOOR EXIT EMERGENCY EXIT SIGN LENS LOOSE. R & R LENS IAW MM.SDR CALA2016082695691Light · inoperativeEMERGENCY LIGHT TEST FAILED. REPLACED L1 SLIDE.SDR DALA2016082406222Sign · missingEXIT SIGN MISSING FROM ASILE AT ROW 26. INSTALLED MISSING EXIT SIGN.SDR VNAA2016082300030Battery Pack · dischargedEMERGENCY LIGHT STRIP OUT IN ROWS 2, 3, AND 4. MAINTENANCE R & R EMERGENCY BATTERY PACK NR 1, AND PERFORMED CHECKS IAW AMM. AIRCRAFT RELEASED FOR SERVICE.SDR AALA20160824001Light · damagedEMERGENCY LIGHT AT SEAT 25B DAMAGED. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-10. OPS CHECKED NORMAL.SDR SWAA2016082555123Light · detachedCEILING OVERWING EXIT AISLE LIGHT FELL OFF. R & R THE LIGHT ASSEMBLY IAW SIP.SDR ASAA2016082317786Sign · detachedEXIT SIGN FOUND LOOSE ON GROUND. ACFT GROUNDED. REINSTALLED EXIT SIGN. OK FOR CONTINUED SERVICE.SDR AALA201608249005Cover · missingAIRCRAFT WAS NOT GROUNDED, EMERGENCY EXIT LIGHT COVER AT SEAT 14A MISSING. INSTALLED EMERGENCY EXIT LIGHT COVER AT SEAT 14A.SDR SWAA2016082455117Lens · looseAISLE OVERWING EXIT SIGN LENS LOOSE. SECURED LENS IAW MM.SDR SWAA2016082455084Cover · brokenR1 DOOR EMERGENCY EXIT LIGHT COVER BROKEN. R & R COVER IAW SIP.SDR AALA20160824006Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE INBOARD OF SEATS 8 HJ, REPLACED THE BATTERY PACK IAW MM 33-51-06, OPS CHECKED NORMAL.SDR AALA20160823003Battery Pack · dischargedFORWARD SECTION OF EMERGENCY LIGHTS ARE DIM. REMOVED AND REPLACED BATTERY PACK. FORWARD EMERGENCY LIGHTS OPS CHECKED OK.SDR AALA20160823002Battery Pack · dischargedAFT SECTION OF EMERGENCY LIGHTS ARE DIM. REMOVED AND REPLACED THE BATTERY PACK. LIGHTS OPS CHECKED OK.SDR AALA20160823001Battery Pack · inoperativeTAIL CONE EMERGENCY LIGHTS ARE INOPERATIVE. REMOVED AND REPLACED THE BATTERY MODULE. EMERGENCY LIGHTS OPS CHECKED NORMAL.SDR AALA20160822011Battery Pack · inoperativeEMERGENCY EXIT SIGN ABOVE L3 DOOR IS INOPERATIVE. REPLACED THE BATTERY PACK.SDR AALA20160822010Battery Pack · inoperativeEMERGENCY EXIT SIGNS ABOVE ROW 30 ARE INOPERATIVE. REPLACED THE BATTERY PACK IAW MM 33-51-06, OPS CHECKED NORMAL.SDR AALA20160822009Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE INBOARD OF SEATS 8HJ, REPLACED THE BATTERY PACK IAW MM 33-51-06, OPS CHECKED NORMAL.SDR SIMA20160823004Light · inoperativeEMERGENCY LIGHT PREVIOUSLY IS ALMOST COMPLETELY INOPERATIVE. REMOVED AND REPLACED THE LIGHT IAW AMM 33-50-21. OPS CHECKED GOOD. ACFT OK FOR SERVICESDR REXA2016082301571Light · unsecureEMERGENCY LIGHTING STRIP PULLED UP AT SEAT 12C/D. SECURED LIGHT LIGHT AT SEAT 12C/D IAW AMM 33-51-01.SDR REXA2016082301570Lamp · inoperativeEMERGENCY EXIT LIGHTING IS INOPERATIVE. REPLACED THE LAMP, OPS CHECKED GOOD IAW AMM 33-51-00.
Back to JASC 3350