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 SIMA20170819001Lamp · inoperativeMAIN DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE IAW PS-2 INSPECTION. R & R LAMP ON MAIN DOOR EXTERNAL EMERGENCY LIGHT IAW AMM 33-50-10. OPS CHECKED GOOD.SDR DALA2017082006319Power Supply · faultedDURING L2 DOOR SLIDE REPLACEMENT, EPSU SYSTEM TEST FAULTED, EPSU 19WL. REPLACED EPSU 19WL.SDR MASA2017081912559Light · inoperativeROW 20 OVHD EMER FLOOD LIGHT INOP. PLACED ON MEL.SDR MASA2017081912558Charger · dischargedSIDEWALL EMER LIGHTS AT ROW 13 INOP. R&R NR 3 EMER BATT CHARGER.SDR MASA2017081912557Charger · inoperativeMID CABIN OH EXIT SIGN FWD FACE INOP. R&R NR 3 EMER BATT CHARGER.SDR AALA201708219064Lens · looseAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY SEAT 21 RIGHT HAS A LOOSE LENS COVER. RESECURED LENS COVER. OPERATIONAL CHECK GOOD.SDR AALA201708219063Sign · looseAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE L4 DOOR IS LOOSE. READJUSTED EXIT SIGN PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201708219060Sign · detachedAIRCRAFT WAS NOT GROUNDED. RIGHT FORWARD OVERWING EMERGENCY EXIT SIGN IS DETACHED AND IN THE COCKPIT. REPOSITIONED EXIT SIGN.SDR AALA201708219055Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT SEAT 23ABC HAS A MISSING LENS COVER. INSTALLED LENS COVER PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA201708219054Sign · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE R2 DOOR IS MISSING. REPLACED EXIT SIGN PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA201708219053Lens · dislodgedAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH LIGHT AT THE BASE OF FORWARD GALLEY WALL JUST FORWARD OF SEATS 2C/2B HAS A DISLODGED LENS COVER. INSTALLED LENS COVER PER AMM 33-51-14. OPERATIONAL CHECK GOOD.SDR AALA201708219051Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT IN LAVATORY E HAS A MISSING LENS COVER. INSTALLED LENS COVER PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR DALA2017081906332Battery Pack · no testEMERGENCY LIGHT BATTERY PACKS M33404 AND M33409 FAILED FUNCTIONAL CAPACITY CHECK IAW W/C 0591-1204. R & R THE BATTERY PACKS IAW AMM 33-51.SDR DALA2017082106335Cover · detachedEXIT SIGN, MID CABIN DETACHED. SECURED THE SIGN COVER.SDR AALA201708219009Sign · brokenEMERGENCY EXIT SIGN AT THE L1 DOOR IS BROKEN AT THE BOTTOM. REPLACED THE SIGN ASSEMBLY 90WL1 IAW MM 33-51-19. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201708219010Sign · brokenEMERGENCY EXIT SIGN AT THE R1 DOOR IS BROKEN AT THE BOTTOM. REPLACED EMERGENCY EXIT SIGN ASSEMBLY 90W2 IAW MM 33-51-19. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201708219031Light · inoperativeSEAT MOUNTED EMERGENCY LIGHT INOPERATIVE AT ROW 6C. REMOVED AND REPLACED THE EMERGENCY LIGHT AT ROW 6C IAW AMM.SDR AALA201708219027Lens · missingSEAT MOUNTED EMERGENCY LIGHT LENS COVER MISSING. REPLACED LENS IAW AMM 33-51-19.SDR AALA201708219017Light · brokenEMERGENCY LIGHT. BROKEN OFF. REPLACED EMERGENCY LIGHT. OPS CHECKED GOOD.SDR SWAA2017082215866Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1674. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017082215865Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1673. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017082215864Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1672. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017082215863Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1670. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017082215862Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED A CAPACITY TEST AT LOCATIONS M1669. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017082215861Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1675. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017082215859Sign · looseAFT EMERGENCY SIGN LOOSE. R & R THE LIGHT ASSEMBLY IAW CMM.SDR SWAA2017082215856Cover · missingL1 DOOR EMERGENCY EXIT LIGHT COVER MISSING. INSTALLED THE COVER IAW AMM.SDR SWAA2017082215841Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1668. R & R THE BATTERY IAW AMM.SDR SWAA2017082115805Sign · unsecureR2 DOOR EXIT SIGN FELL OFF. R&R LENS BASE ASSEMBLY IAW AMM.SDR ASAA2017081821665Lamp · inoperativeOVERHEAD LIGHTING ABOVE BINS AT ROW 2AB AND 31DEF, WILL NOT ILLUMINATE. ACFT GROUNDED. REPLACED THE LAMPS ON BOTH OVERHEAD EMERGENCY LIGHTS ABOVE ROW 2AB, AND ROW 31DEF, OPS CHECKED NORMAL IAW AMM 33-51-03.SDR HNAA2017082100281Lamp · inoperativeLEFT ABOVE WING EMERGENCY LIGHT NOT ILLUMINATING . R & R THE LAMP.SDR 29GA2017082000001Light · debonded2A EMERGENCY LIGHT STRIP ON FLOORBOARD IS DISBONDED. R & R THE EMERGENCY LIGHT, OPS CHECKED GOOD IAW AMM 33-50-20-04.SDR MASA2017081812552Light · inoperativeROW 21 EMERGENCY CEILING LIGHT INOP. PLACED ON MEL.SDR CALA2017081802794Battery Pack · dischargedDURING 2SVC FOUND EMERGENCY LIGHTS AT ROW 5-7L TO BE INOP. REPLACED SEAT 6 AND SEAT 7 P1 CONNECTORS REF SWPM 20-610-28 AND REPLACED M10567 BATTERY PACK REF AMM-33-51-07-902-001. OPS CK GOOD. ACP INSP OK FOR SVC OPS CHK GOOD REF AMM 33-51-07.SDR CALA2017081802793Battery · dischargedEMERGENCY LIGHTS TEST FAULT AFT L BATTERY. REPLACED AFT L BATTERY PER MM 33-51-38. EMERGENCY LIGHTS TEST OK.SDR CALA2017081802791Lens · missingEMERGENCY FLOOR PROXIMITY LIGHT DOES NOT TURN ON 01 EMERGENCY FLOOR LIGHT BY SEAT 1B MISSING A LENS COVER. REPLACED LAMP ASSEMBLY LENS COVER. OPS CHECK GOOD REF AMM 33-51-14.SDR CALA2017081802790Light · looseEMERGENCY EXIT FLOOR LIGHTING IS COMING LOOSE FROM THE FLOOR AT SEAT 31C. MOUNT FOR LIGHT UNDER SEAT LOOSE. SECURED.SDR CALA2017081802789Lens · missingEMERGENCY LIGHT LENS MISSING AT SEAT 30C. REPLACED EMERGENCY LIGHT LENS.SDR CALA2017081802788Power Supply · faultyOUTSIDE EMERGENCY LIGHTS ON RIGHT SIDE OF A/C, AFT MOST LIGHT ABOVE THE RIGHT WING AND ONE AFT OF WING ARE INOP. REF LOG 5162438 PROBLEMS ARE CORRELATED TO EACH OTHER VIA FAULTY POWER SUPPLY REF OTHER LOG ITEM FOR ACTIONS AND CORRECTION TAKEN.SDR CALA2017081802787Battery Pack · dischargedALL EMERGENCY EXIT LIGHTS AT R-2 DOOR INOP. REMOVED AND REPLACED BATTERY CHARGER AND BATTERY PACK AFT GALLEY CEILING RIGHT SIDE REF MM 33-51-06 ALL LIGHTS AT R-2 DOOR OPS CK GOOD.SDR CALA2017081802786Lens · missingDOOR 122 EMER LIGHT COVER MISSING. REINSTALLED LENS COVER.SDR CALA2017081802785Lens · missingMID CABIN EMERGENCY EXIT LENS COVER MISSING. REPLACED LENS COVER.SDR CALA2017081802784Sign · looseONE HALF OF MID CABIN EMERG EXIT SIGN IS MISSING. RE-ATTACHED FWD HALF OF MID CABIN EMERG EXIT SIGN.SDR CALA2017081802783Power Supply · inoperativeEMERGENCY AISLE LIGHTS ROW 36,37,38 ABC INOP. REMOVED AND REPLACED ''M1672'' EMERGENCY POWER SUPPLY W/ BATTERY PACK PER WDM REF 33-51-12 AMM REF 33-51-06. OPERATIONALLY TEST NORMAL AT THIS TIME.SDR CALA2017081802781Battery Pack · dischargedM1694, M1695, M1676, M1671 EMERGENCY LIGHTS POWER SUPPLY BATTERIES FAIL CAPACITY CHECK PER W/C 29-3350-1-7100. REPLACED CHARGER ASSY M1671 IAW AMM 33-51-06. REPLACED BATTERY PACKS IN CHARGERS M1671, M1676, M1694, M1695 IAW AMM 33-51-06.SDR CALA2017081802780Light · looseAFT GALLEY EMERG EXIT LIGHT NEEDS TO BE SECURED. REMOVED AND REPLACED AFT OVERHEAD EMERGENCY LIGHT ASSY PER AMM 33-51-01. OPS NORMAL, OK TO CONT.SDR CALA2017081802778Light · inoperativeSLIDE LIGHT ABOVE DOOR 1L DOES NOT ILLUMINATE WHEN DOOR ARMED. RELAMPED SLIDE LIGHT OPS CHECK OK.SDR CALA2017081802774Light · inoperativeL1 (EMERGENCY) AISLE LIGHT INOP. REMOVED AND REPLACED L1 AISLE LIGHT ASSY. OPERATION NORMAL REF AMM TASK 33-51-05-002-016 (REMOVE) AMM TASK 33-51-05-402-024 (INSTALL) AND IPC 33-51-04-02.SDR CALA2017081802773Light · inoperativeL1 DOOR EXTERIOR SLIDE LIGHT INOP. RELAMPED L1 DOOR EXT SLIDE LIGHT ASSY. REF: B767-300 AMM TASK 33-51-06-902-082. OPERATION NORMAL.SDR CALA2017081802771Power Supply · inoperativeEMERGENCY FLOOR LIGHTS OUT ON LEFT AISLE ROWS 24-33. REPLACED POWER SUPPLY AND BATTERY PACK REF AMM 33-51-07.
Back to JASC 3350