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 CALA2017061901913Battery Pack · dischargedEMERGENCY LIGHTS ROW 22-28 ISLE INOP. REMOVED AND REPLACED EMERGENCY POWER BATTERY PACK. OPS CHECK GOOD REFAMM 33-51-06-960-805.SDR CALA2017061901912Light · inoperativeLT EMERGENCY OVERWING SLIDE LAMP INOP. REPLACED LAMP REF AMM 33-51-04. OPERATIONAL CHECK NORMAL.SDR CALA2017061901916Lens · missingEMERGENCY EXIT SIGN AT DOOR 2R MISSING. INSTALLED EXIT LENS COVER AT 2R.SDR CALA2017061901908Light · not seatedDOOR 1R WILL NOT DISARM. SLIDE LT ILLUMINATED RESEATED LIGHT CAP.SDR CALA2017061901904Light · pulledEMERGENCY EXIT ROW FLOOR STRIP LIGHT IS PULLED OUT OF FLOOR AND WIRES ARE EXPOSED. REINSTALLED LIGHT STRIP OPS CKS OK.SDR CALA2017061901901Circuit Breaker · trippedCIRCUIT BREAKER FOR EMERGENCY LIGHTS THE L3 DOOR TRIPPED. EXIT SIGN ABOVE 3L ON.EMERGENCY, EXIT LIGHTS FROM ROW 20 AFT AIRCRAFT LEFT & RIGHT ARE ON. RECEIVED A MESSAGE 33-19005.IAW FIM PMC 81205-A0706-00. CYCLED CE 2471841 AND CE2471861 CIRCUIT BREAKERS, MESSDR CALA2017061901900Ballast · faultyEMERGENCY AREA LIGHT DOES NOT TURN ON 21A. R&R BALLAST NOW OPS NORMAL REF 33-21-00-27-408 29-3321-3-0054.SDR MASA2017061912392Light · inoperativeROW 6 EMER CEILING FLOOD LIGHT INOP. MX REPLACED BULBS.SDR AALA201706209011Battery · failedAIRCRAFT WAS NOT GROUNDED. AIRPLANE HEALTH MONITORING ALERT RECEIVED FOR L1 DOOR PRIME WIRELESS EMERGENCY LIGHTS SYSTEM CONTROL UNIT BATTERY POWER FAILURE. **SUPPLEMENTAL - 06/23/17 - REMOVED AND REPLACED WELS CONTROL UNIT BATTERY IAW AMM 33-51-07. OPERATIOSDR AALA201706199071Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE R1 DOOR HAS A MISSING LENS COVER. **SUPPLEMENTAL - 06/22/17 - REMOVED AND REPLACED EXIT SIGN ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD. (CLOSED)SDR HALA2017062000193Sign · detachedL3 DOOR EXIT SIGN DETACHED FROM CEILING. REPLACED THE EXIT SIGN.SDR AALA201706209010Lens · looseEMERGENCY EXIT SIGN BETWEEN THE L2 & R2 DOORS HAS A LOOSE LENS. SECURED THE LENS. OPS CHECKED GOOD.SDR SWAA2017062014524Lamp · inoperativeOVERWING EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMP IAW MM.SDR R61A201706180414Battery Pack · inoperativeFIRST CEILING EMERGENCY LIGHT IN COACH IS INOPERATIVE. R & R THE NR 2 BATTERY PACK IAW AMM 33-50-01. OPS CHECKED NORMAL.SDR AALA201706199057Power Supply · failedFIVE SEAT MOUNTED AND TWO CEILING EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED EMERGENCY POWER SUPPLY BATTERIES AT 10WLSDR AALA201706209002Light · damagedEMERGENCY LIGHT CASING DAMAGED ON SEAT 15 LEFT. REPLACED THE EMERGENCY LIGHT CASING IAW CMM 25-22-52. OPS NORMAL.SDR AALA201706199055Power Supply · failedFIVE SEAT MOUNTED AND TWO CEILING EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY BATTERIES AT 15WL.SDR AALA201706199033Lens · damagedOVERWING EXIT LENS FROM 2L DAMAGED. INSTALLED NEW EXIT LENS.SDR AALA201706199032Lens · detachedEXIT LIGHT LENS NEAR FLOOR AT THE R2 DOOR FELL OFF. INSTALLED A NEW LENS.SDR AALA201706199073Battery Pack · faultyTHE AIRCRAFT WAS NOT GROUNDED. OVERWING EMER LIGHTS REMAIN ON W/ POWER OFF. REPLACED BATT PACK FOR SAME IAW AMM 33-50-00 CKS GOOD.SDR AALA201706199048Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN ABOVE THE L2 DOOR HAS A DETACHED LENS COVER. REPLACED SIGN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR DALA2017061904845Bracket · brokenOVERWING EXIT SIGN BRACKET IS BROKEN. INSTALLED A NEW SIGN.SDR SWAA2017061914465Light · inoperativeR2 DOOR AFT EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR AALA201706209001Battery · no testEMERGENCY LIGHT BATTERY FAILED TO TEST AT POWER SUPPLY 11 WL. REPLACED BATTERY IAW MM 33-51-11.SDR ASAA2017061821128Lens · detachedEXIT SIGN LENS FOUND DETACHED. ACFT GROUNDED. INSTALLED THE SIGN LENS.SDR ASAA2017061821127Lens · detachedEXIT SIGN LENS IN AFT GALLEY DETACHED. ACFT GROUNDED. INSTALLED THE LENS.SDR F3LA2017062000180Power Supply · no testEPSU 10WL, 12WL AND 13WL FAILED BATTERY CAPACITY TESTS IAW 33-51-00-710-003-A. REMOVED AND REPLACED EPSU. OPS TESTED GOOD IAW AMM 33-51-38 PB 401.SDR YENA201706180502Battery Pack · inoperativeTHE EXIT SIGNS AND EMERGENCY LIGHTS DID NOT COME ON WHEN THE GROUND POWER FAILED ON THE GROUND. THE COCKPIT SWITCHES WERE IN THE ARMED POSITION I, TRIED THE EMERGENCY BUTTON ON THE FAP AND STILL DIDNT WORK. R & R DEU-B 300 RH6 IAW 23-73-47, TESTS PASSED, BUSDR IPXA2017061918352Power Supply · inoperativeEMERGENCY LIGHT BATTERY POWER SUPPLY INOPERATIVE. R & R THE POWER SUPPLY REF 33 51 01SDR SIMA20170618001Lamp · inoperativeFOUND EXTERIOR RT OVERWING EMERGENCY LIGHT INOPERATIVE IAW PS-1 INSPECTION. R & R THE LAMPS IAW AMM 33-50-10, OPS CHECKED GOOD.SDR DALA2017061804798Battery · dischargedON SVC CK FOUND OVERHEAD EMERGENCY LIGHTS INOP ROW 17-21. REPLACED EMER LIGHT BATTERIES AT ROW 17 OPS CHECK GOOD.SDR CALA2017061801883Battery · dischargedEMERGENCY LIGHTS TEST FAILED. EPSU AFT LEFT. REPLACED AFT LEFT EMERGENCY LIGHTS BATTERY PER MM 33-51-38. OPS CK GOOD.SDR CALA2017061801881Cids · malfunctionedEMERGENCY EXIT LIGHTS FLICKERING ON AND OFF WITH SWICH IN ARM POSITION AGAIN. FOUND CIDS SYSTEM LOCKED UP AND WAS UNABLE TO GET EMERGENCY LIGHT TEST TO OPERATE. RESET CIDS SYSTEM. AFTER RESET, OPERATION RETURNED TO NORMAL.SDR CALA2017061801880Power Supply · malfunctionedEMER EXIT LIGHTS FLICKERING ON AND OFF WITH SWITCH IN ARM POSITION. RESET EMERGENCY POWER SUPPLY PER AMM 33-51-00, OPS CKS NORMAL AT THE GATE.SDR CALA2017061801878Lens · brokenROW 26ABC SEAT EMERGENCY LIGHT IS BROKEN. REPLACED BROKEN EMERGENCY LIGHT LENS AND SECURED IN SEAT. REF AMM 33-51-11. OPS NORMAL.SDR CALA2017061801877Sign · missing21F EMERGENCY EXIT SIGN MISSING. SEAT 21F AND BY AFT LAV REPLACED MISSING EXIT SIGN.SDR CALA2017061801876Lens · unsecureAT 21F SIDEWALL EMERG LIGHT LENS FELL OFF. RPL LIGHT ASSY REF AMM 33-51-01-960-802, OPS CK OK ACCOMPLISHED.SDR CALA2017061801875Lens · unsecureEMERGENCY EXIT LENS HAS FALLEN OFF. OVER WING EMERGENCY EXIT SECURED LENS.SDR CALA2017061801874Light · inoperativeEMERGENCY ISLE LIGHT INOP AT ROW 25. RELAMPED.SDR CALA2017061801873Battery Pack · failedMOST EMERGENCY LIGHTS FAIL CAPACITY CHECK PER W/C 29-3350-1-7100 . REPLACED BATTERY PACKS AT THE FOLLOWING EMERGENCY LIGHTS POWER SUPPLIES IAW AMM 33-51-06: M1674 M1676 M1694 M1695 M1670 M1671 M1673 M1672. CAPACITY AND FUNCTIONAL CHK GOOD IAW AMM 33-51-0SDR CALA2017061801872Battery Pack · dischargedFIRST CLASS SEAT EMERGENCY LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK, ALL LIGHTS OPS CHECK GOOD.SDR CALA2017061801871Unknown · malfunctionedEMERGENCY EXIT LIGHTS ON AT GATE. WITH SWITCH IN ARMED POSITION. WITH GROUND OR APU POWER. ONLY FWD LIGHTS ON IN CABIN. CYCLED CB FOR FWD LIGHTS. EMERGENCY LIGHTS NOW OPS CHECK NORMAL. REF AMM 33-51-00.SDR CALA2017061801870Sign · unsecureEMERGENCY EXIT SIGN ABOVE CENTER AISLE AT ROW 25 HAS FALLEN OFF. PART IN COCKPIT. REINSTALLED SIGN, OPS CKS GOOD.SDR CALA2017061801869Light · brokenEMERGENCY FLOOR PROXIMITY LIGHT DOES NOT TURN ON. 21C FLOOR PATH LIGHT BROKEN COMING OFF ROW. REMOVED AND REPLACED ENDBAY BUMPER, EPL LIGHT HOUSING, EMERGENCY LIGHTS OPS CHECKS NORMAL.SDR JJBA20170617001Inverter · inoperativeCENTER CEILING EMERGENCY LIGHT INOPERATIVE. R & R THE NR 4 EMERGENCY LIGHT INVERTER. OPS CHECKED GOOD.SDR SWAA2017062214572Fuse · failedRIGHT OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE FUSE IAW MM.SDR AALA201706199070Cover · missingTHE AIRCRAFT WAS NOT GROUNDED. EXIT SIGN COVER MISSING IN AFT GALLEY NEXT TO AFT ENTRY DOOR ON RIGHT SIDE BACK WALL. REMOVED AND REPLACED LIGHT ASSY IAW 33-51-01. OPS CHECK OK.SDR AALA201706199047Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE L1 DOOR HAS A DETACHED LENS COVER. REINSTALLED LENS COVER IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA201706199045Sign · unsecureAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE LOWER L1 DOOR IS NOT SECURED. REFITTED AND SECURED SIGN IAW AMM 33-51-10-402-047. OPERATIONAL CHECK GOOD.SDR AALA201706199042Lens · brokenEMERGENCY EXIT SIGN BY THE L2 DOOR HAS A BROKEN LENS. REPLACED THE LENS IAW AMM 33-24-00. OPS CHECKED GOOD.
Back to JASC 3350