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 DALA2017013100836Power Supply · inoperativeAFT RIGHT OVERWING EXIT LIGHT INOPERATIVE, REPLACED THE POWER SUPPLY AND BATTERY.SDR AALA20170201026Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY R2 DOOR HAS A MISSING LENS COVER. REPLACED LENS COVER IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170201025Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE R2 DOOR TOP RIGHT HAS A MISSING LENS COVER. REMOVED AND REPLACED EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170201024Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AFT OF FORWARD GALLEY HAS A DETACHED LENS COVER. SECURED LENS COVER. OPERATIONAL CHECK GOOD.SDR AALA20170131026Light · damagedAIRCRAFT WAS NOT GROUNDED. FLOOR EMERGENCY PROXIMITY FLOODLIGHT AT G2 GALLEY IS DAMAGED. REMOVED AND REPLACED FLOODLIGHT IAW AMM 33-51-14. OPERATIONAL CHECK GOOD.SDR ASAA2017013019603Lamp · inoperativeR2 DOOR EMERGENCY EXIT SIGN LAMPS INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMPS, OPS CHECK NORMAL IAW AMM 33-51-01-960-801.SDR R61A201701300077Battery Pack · inoperativeCREW REPORTED THAT TWO OVERHEAD CABIN EMERGENCY LIGHTS WERE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE BATTERY PACK IAW AMM AND OPS CHECKED GOOD.SDR HALA2017013100015Sign · detachedEXIT SIGN WAS FOUND AT DOOR 3R JUMP SEAT DETACHED FROM THE WALL. RE-ATTACHED EXIT SIGN.SDR AALA201701319011Lens · missingAIRCRAFT NOT GROUNDED. LIGHTED EXIT COVER MISSING FROM L-4 DOOR EMERGENCY EXIT LIGHT ASSY. INSTALLED REPLACEMENT EMERGENCY EXIT LIGHT COVER AT 4L DOOR AS REQUIRED.SDR SWAA2017013111588Lamp · inoperativeR2 DOOR EXTERIOR SLIDE LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR SWAA2017013111579Lamp · inoperativeL2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR DALA2017013000790Battery Pack · inoperativeCENTER CEILING EMERGENCY LIGHTS 11-20 LEFT SIDE INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACKS AT BS 731 AND 500 IAW AMM 33-53. OPS CHECKED GOOD.SDR N6WA2017013001Power Supply · dischargedEMERGENCY LIGHTS WILL NOT TURN ON. RECHARGED EMERGENCY POWER SUPPLY UNITS IAW AMM 33-51-17 AND MX-043, OPS CHECK GOOD, AIRCRAFT OK FOR SERVICE.SDR MASA2017013012487Light · inoperativeROW 2 AND 4 OVERHEAD CEILING EXIT LIGHTS. RE-LAMPED.SDR MASA2017013012846Light · inoperativeROW 18 OVHD EMERGENCY FLOOD LIGHT INOP. PLACED ON MEL.SDR MASA2017013012845Light · inoperativeROW 14 OVHD EMERGENCY FLOOD LIGHT INOP. RE-LAMPED.SDR MASA2017013012842Light · inoperativeLT EMER EXIT DOOR FLOOR LEVEL LT 1 BULB INOP. RE-LAMPED.SDR MASA2017013012841Light · inoperativeSVC DOOR FLOOR LEVEL EMER LT 1 BULB INOP. RE-LAMPED.SDR CALA2017013000217Power Supply · faultyL AFT EMERG POWER SUPPLY HAS UNIT FAIL LIGHT ILLUMINATED. REMOVED AND REPLACED L AFT EPSU AND BATTERY REF AMM 33-51-38. TESTED GOOD REF AMM 33-51-38-400-001-A.SDR CALA2017013000216Power Supply · faultyWHEN PERFORMING EMERGENCY LIGHT CK ON 2 SERVICE GOT FAULT EPSU UNIT EMER L MESSAGE. UNABLE TO CLEAR. REPLACED EMERGENCY POWER SUPPLY UNIT AND BATTERY AT 11WL PER 33-51-38AMM. OPS CK GOOD.SDR CALA2017013000207Light · inoperativeEMERGENCY LIGHT UNARMED NEEDS A NEW LIGHT BULB RELAMPED, OPS CHKS GOOD.SDR CALA2017013000221Light · malfunctionedEMERGENCY EXIT LTS ALL ON IN ARMED SWITCH POSITION CYCLED EMERG. LIGHT SWITCH EMERG LIGHTS OPS CHECK NORMAL OK TO CONTINUE.SDR CALA2017013000220Battery Pack · faultyEMERGENCY LIGHT TEST, REF 2 SVC, WILL NOT PASS. FAULTS SHOWS R-H UNIT FAULT. REPLACED EMERGENCY LIGHT BATTERY PACK AT RT EMERGENCY EXIT PER A MM 33-51-38-400-002. OPS CHECK GOOD.SDR CALA2017013000218Battery · faultyAFT LT EEL BATTERY FAILED CAPACITY TEST. REPLACED BATTERY REF AMM 33-51-38-000-002A AND 33-51-38-400-002A . OPS CHECKED OKSDR CALA2017013000215Light · malfunctionedEMERGENCY LIGHTS ARE ON DOOR 2L, DOOR 2R ACCOMPLISHED RESET OF EMERGENCY LIGHT SYSTEM PER AMM-33-51-00 OPS CHECKS OK.SDR CALA2017013000214Battery Pack · dischargedEMERGENCY LIGHTS ON RIGHT AFT OVERHEAD BINS WORK ONLY MOMENTARILY. FOUND POWER SUPPLY M2627 FAILS CAPACITY CHECK. REPLACED BATTERY PACK ON M2627 IAW AMM 33-51-06.SDR CALA2017013000213Light · inoperativeRT AFT OVERWING EMERGENCY EXIT LIGHT INOP. RE-LAMPED LIGHT REF MM 33-51-04. OPS CK OK.SDR CALA2017013000209Battery Pack · dischargedEMERGENCY LIGHT INOP ABOVE SEATS 26ABC REPLACED POWER SUPPLY-CHARGER, M735, MM TASK 33-51-07-022-020, 33-51-07-862-054. REPLACED BATTERY PACK ON M735, MM TASK 33-51-0 7-902-001. REPLACED LAMP FOR AISLE (BULLNOSE) LIGHT, L1065. TEST OK REF WDM33-51-14, PG 1.SDR CALA2017013000208Power Supply · faultyPER 2SVC, FOUND 2EA EMERGENCY EXIT SIGN LIGHTS INOP AT ROW 20L AND 20R REF WD 33-51-21 AND 22,M10567 AND M10568 LIGHT POWER SUPPLY CONNECTORS ,NO WIRINGS AT POSITION 11 AND 12. REPLACED POWER SUPPLY AT STATION 1248 REF WD33-51-22, PG902 OPS OKSDR CALA2017013000206Battery · dischargedPER 2 SVC FOUND EXTERIOR EMERGENCY LIGHT INOP BY MED 2R, 4R & 4L. RELAMPED 2R AND 4L OPS CK GOOD. DISASSEMBLED 4R FOR TS LIGHT INOP FOUND BATTERY TO BE BAD. REPLACED BATTERY AND TESTED. OPS CHECKS GOOD. REF AMM 33-51-07-902-001 REASSEMBLED 4R EXTERIOR EMERGENCSDR CALA2017013000204Light · malfunctioned1L MED EMER LIGHT FLASHING CREW VERBAL REPORT: EMER LIGHT CAME ON AND WENT OFF ON ONE OCCASION AT DR 1L AREA. EMERGENCY LIGHTS OPERATIONAL TEST PERFORMED PER AMM 33-51-00. ALL LIGHT FUNCTIONS ARE NORMAL AND NIL DISCREPANCIES FOUND. AIRCRAFT RESTORED TO NORMAL SDR CALA2017013000203Light · inoperativeRT EMERGENCY EXIT SLIDE PATH AFT LIGHT IS INOP. RELAMPED, OPERATIONAL CHECK GOOD REF AMM 33-51-06SDR CALA2017013000219Light · malfunctionedEMERGENCY EXIT LIGHTS ON AT OVERWING AND AISLE LEFT SIDE OF CABIN. RESET SYSTEM AND OPS CKS NORMAL.SDR HNAA2017013000030Bulb · inoperativeFLOOR EMERGENCY LIGHT IS OUT AT ROW 1DF. REMOVED AND REPLACED THE BULB. OPS CHECKED GOOD.SDR MASA2017013012840Charger · inoperativeMULTIPLE FWD CABIN EMERGENCY LIGHTS OUT. R & R THE NR 1 CHARGER.SDR JJBA20170130022Light · inoperativeWD AND THIRD EMERGGENCY LIGHT INOPERATIVE. ADJUSTED THE LIGHT, OPS CHECKED GOOD. NO DEFECTS NOTED AT THIS TIME.SDR VNAA2017012900039Light · detachedEMERGENCY LIGHT ON SERVICE DOOR FELL OFF. SECURED THE LIGHT, OPS CHECKED GOOD.SDR AALA20170201015Light · inoperativeAIRCRAFT WAS NOT GROUNDED. AFT RIGHT OVERWING EMERGENCY EXIT LIGHT IN THE LOWER PANEL IS INOPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170201014Sign · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN OVER L2 DOOR IS DETACHED. REPLACED EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170201013Bolt · damagedAIRCRAFT WAS NOT GROUNDED. CROSS-AISLE EMERGENCY EXIT SIGN BY SEAT 24HJ IS DETACHED DUE TO BOLT ON RIGHT SIDE IS DAMAGED. SECURED EXIT SIGN IAW EA 267074. OPERATIONAL CHECK GOOD.SDR AALA20170201011Lens · missingAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT AT SEAT 20D IS MISSING LENS COVER. INSTALLED LENS COVER IAW AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA20170201010Lens · missingAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT AT SEAT 38C IS MISSING LENS COVER. INSTALLED LENS COVER IAW AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA20170201009Lens · missingAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT AT SEAT 32C IS MISSING LENS COVER. INSTALLED LENS COVER IAW AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA20170130001Battery · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT AT 12WL FAILED TEST. REMOVED AND REPLACED EPSU BATTERY IAW AMM 33-51-38. OPERATIONAL CHECK GOOD.SDR AALA201701309003Cover · missingAIRCRAFT NOT GROUNDED: EXIT PLACARD MISSING DOOR 4L.REPLACED COVER . AIRCRAFT NOT GROUNDED.SDR AALA201701309001Switch · defectiveAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT ARE ON IN ARMED POSITION. REPLACED EMERGENCY LIGHT SWITCH ESPM 20-45-21 AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-00.SDR SWAA2017013011576Battery Pack · dischargedLT OVERWING DOOR EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2017013011575Battery Pack · dischargedCENTER AISLE OVERHEAD EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2017013011574Battery Pack · dischargedLT EXTERIOR OVERWING DOOR EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2017013011517Sign · looseR2 DOOR EXIT SIGN LOOSE. R & R THE SIGN ASSEMBLY IAW AMM.
Back to JASC 3350