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 UIEA2018022800294Charger · inoperativeEMERGENCY OVERHEAD ISLE LIGHTS AT SEAT 3A AND 25A ARE INOP LEFT SIDE. REMOVED AND REPLACED BATTERY PACK CHARGER IAW AMM 33-51-07.SDR UIEA2018022800296Power Supply · inoperativeEXTERIOR LEFT OVERWING EMERGENCY LIGHT EGRESS L389, L395 INOP. REMOVED AND REPLACED POWER SUPPLY M736 IAW AMM 33-51-07.SDR UIEA2018022800298Charger · inoperativeL1 AND R1 EMERGENCY DOOR SLIDE LIGHTS INOP. REMOVED AND REPLACED BATTERY ASSY CHARGER AMM 33-51-07.SDR UIEA2018022800299Charger · inoperativeRIGHT OVERWING EMERGENCY EGRESS LIGHTS INOP. REMOVED AND REPLACED BATTERY CHARGER, OPS CHECK NORMAL IAW AMM 33-51-07.SDR UIEA2018022800300Light · inoperativeL4 AFT DOOR SLIDE EMERGENCY LIGHT INOP. CLEANED CONTRACT AND RELAMPED OPS CHECK NORMAL AS PER AMM 33-51-06.SDR AALA201802279082Lens · missingTHE AIRCRAFT WAS NOT GROUNDED. EEL LENS ON ROW 15ABC IS MISSING. INSTALLED EEL LENS PER AMM 33-51-03. GOOD FOR SERVICE.SDR AALA201802279019Cover · missingL2 DOOR EXIT LIGHT COVER MISSING. MAINTENANCE INSTALLED EXIT LIGHT COVER AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201802269083Cover · missingEMERGENCY EXIT LIGHT AT L1 DOOR MISSING COVER. MAINTENANCE INSTALLED NEW COVER AT EXIT LIGHT PER AMM 33-51-01 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201802269079Light · looseCEILING EMERGENCY EXIT LIGHT AFT GALLEY LOOSE. MAINTENANCE SECURED CEILING PANEL IAW AMM 25-21145 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201802269074Sign · looseOVERHEAD EXIT SIGN AT THE L3 DOOR WAS FOUND LOOSE. MAINTENANCE REPLACED THE SIGN IAW AMM 33-51-01, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2018022720138Battery Pack · no testEMERGENCY LIGHT BATTERY PACKS FAILED CAPACITY CHECK AT LOCATION M01673. R & R THE BATTERY PACK IAW MM.SDR SWAA2018022720137Battery Pack · no testEMERGENCY LIGHT BATTERY PACKS FAILED A CAPACITY CHECK AT LOCATION M01669. R & R THE BATTERY PACK IAW MM.SDR SWAA2018022720122Battery Pack · no testEMERGENCY LIGHT BATTERY PACKS FAILED CAPACITY CHECK AT LOCATION M01672. R & R THE BATTERY PACK IAW MM.SDR SWAA2018022720121Light · looseLEFT CABIN EMERGENCY LIGHT FOUND LOOSE AT ROW 12. SECURED THE LIGHT STRIP IAW MM.SDR SWAA2018022720114Fuse · failedAFT AISLE EMERGENCY EXIT SIGN INOPERATIVE. R & R THE FUSE IAW AMM.SDR SWAA2018022720094Battery · no testAFT GALLEY CABIN EMERGENCY LIGHT FAILED CAPACITY TEST. R & R THE BATTERY IAW AMM.SDR AALA201802269049Panel · looseL1 DOOR FRAME, LOWER PANEL THAT HOLDS EMERGENCY EXIT SIGN, PANEL IS LOOSE. REINSTALLED PANEL IAW AMM 25-23-45. OK FOR SERVICE.SDR AALA201802269048Lens · missingLENS COVERS FOR EMERGENCY LIGHTS AT 1C AND 22C ARE MISSING. REPLACED EMERGENCY LIGHT ASSEMBLY. OPS CHECKED GOOD.SDR AALA201802269047Lens · missingTHE AIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY LIGHT LENS MISSING AT 4L. REPLACED LIGHT ASSEMBLY IAW AMM 33-51-19. OPERATIONS CHECK NORMAL.SDR AALA201802269066Light · inoperativeAISLE EMERGENCY LIGHTS INOPERATIVE AT ROW 13L. REPLACED SEAT MOUNTED EMERGENCY LIGHTS IAW AMM 33-51-19-400-003-A.SDR AALA201802269055Light · inoperativeAISLE EMERGENCY LIGHTS INOPERATIVE AT ROW 9R. REPLACED THE EMERGENCY LIGHTS IAW AMM 33-51-19-400-003-A.SDR AALA201802269080Battery Pack · no testMID RIGHT EMERGENCY LIGHT BATTERY PACK M1695 FAILED A FUNCTIONAL CHECK. REPLACED THE BATTERY PACK IAW AMM 33-51-06.SDR AALA201802269028Lens · missingRED EMERGENCY LIGHT LENS MISSING AT AISLE 9D. REPLACED THE LENS IAW AMM 33-51-18.SDR DALA2018022601188Battery Pack · inoperativeSEATS ROW 6 - 8 EMERGENCY LIGHTS INOPERATIVE. R & R THE BATTERY PACK ABOVE L2 DOOR IAW AMM 33-51-07.SDR DALA2018022601187Battery Pack · failedEMERGENCY LIGHTS OUT AT SEATS 41 DEF - 45 DEF. FOUND THE BATTERY PACK M736 BAD. REPLACED THE BATTERY PACK IAW AMM 33-51-07.SDR SWAA2018022620017Sign · unsecureLT OVERWING EXIT SIGN FELL OFF. R&R SIGN PER SIP.SDR FDEA201802230475Lamp · inoperativePOST FLIGHT INSPECTION, ONE OVERHEAD EMERGENCY LIGHT INOPERATIVE, DURING LIGHT TEST. REPLACED THE LAMP, IAW AMM 33-50-00-2. EMERGENCY LIGHTS TESTED SATISFACTORY. OK FOR SERVICE.SDR CALA2018022300763Fuse · inoperativeEXTERIOR EMERGENCY LIGHT LEFT SIDE OF AIRCRAFT INOPERATIVE. REPLACED THE FUSES IN M738 CHARGER. OPS CHECKED NORMALSDR CALA2018022300765Lamp · inoperativeOVERHEAD EMERGENCY LIGHT AT SEAT ROW 19K INOPERATIVE. REPLACED THE LAMPS. OK FOR SERVICE.SDR CALA2018022300764Lamp · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 4K INOPERATIVE. REPLACED THE LAMPS, OK FOR SERVICE.SDR CALA2018022300759Fuse · inoperativeEXTERIOR EMERGENCY LIGHT AFT OF L2 DOOR INOP. REPLACED FUSES IN M738 CHARGER OPERATIONAL CHECK NORMAL.SDR SIMA20180222005Bulb · inoperativeTHE EMERGENCY CEILING LIGHT IN PANEL 243DLC IS INOPERATIVE. REMOVED AND REPLACED THE BULB IAW AMM 33-50-08.SDR BJNA20180227001Not Reported · malfunctionedEMERGENCY LIGHTS REMAINED ON WITH SWITCH OFF.SDR SWAA2018022720128Light · inoperativeLOWER EMERGENCY EXIT LIGHTS JUST FORWARD OF LEFT AND RIGHT OVERWING EXITS INOPERATIVE. R & R THE LIGHT IAW AMM.SDR SWAA2018022720127Battery Pack · inoperativeFORWARD ENTRY EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR AALA201802269069Lens · damagedLIGHT LENS BEZEL IS DAMAGED. EMERGENCY EXIT LIGHT IN FORWARD GALLEY 1R PLASTIC COVER CAME OFF. R1 DOOR EMERGECY LIGHT LENS DAMAGED, EMERGECY LIGHT OPERATIVE, LENS SECURED WITH CLEAR TAPE AS REQUIRED. REMOVED AND REPLACED EMERGENCY EXIT LIGHT IN FORWARD GALLEY SDR AALA201802269064Light · inoperativeSEAT 33C EMERGENCY LIGHT IS OUT. REPLACED SEAT 33C EMERGENCY LIGHT IAW AMM 33-51-19.SDR AALA201802269044Light · brokenEMERGENCY EXIT LIGHT ASSY IN FORWARD SERVICE DOOR IS BROKEN. REPLACED LIGHT ASSEMBLY IAW AMM 25-63-00.SDR AALA201802269068Lens · damagedL4 ENTRY DOOR EXIT LIGHT LENS COVER IS DAMAGED. REPLACED LIGHT ASSEMBLY IAW AMM 33-50-00.SDR AALA201802269046Charger · inoperativeTHE AIRCRAFT WAS NOT GROUNDED. TAILCONE SLIDE EMERGENCY LIGHTS 2 UPPER LAMPS ARE INOPERATIVE. REPLACED BATTERY & CHARGER ASSEMBLY IAW AMM 33-53-00. OPS CHECKED OK.SDR SWAA2018022620090Battery Pack · no testEMERGENCY BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01673. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018022620081Sign · looseMID CABIN CEILING EMERGENCY EXIT SIGN LOOSE. SECURED SIGN PER SIP.SDR SWAA2018022620079Lens · unsecureLT OVERHEAD BIN EMERGENCY LIGHT LENS CAME OFF AT ROW 19. REINSTALLED LENS PER MM.SDR SWAA2018022620076Sign · brokenCENTER AISLE EMERGENCY EXIT SIGN BROKEN FROM CEILING MOUNT. R&R SIGN PER MM.SDR SWAA2018022620060Lens · looseRT WING OVERWING EXIT EMERGENCY EXIT SIGN LIGHT COVER LOOSE. R&R LENS ASSEMBLY PER MM.SDR SWAA2018022620059Light · inoperativeRT FORWARD OVERWING EXT EMERGENCY LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA2018022620058Light · inoperativeRT OFF-WING HATCH EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018022620029Battery Pack · failedEMERGENCY BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01672. R&R BATTERY PACK PER AMM.SDR AALA201802269065Lens · missingROW 12C LENS MISSING. MAINTENANCE SECURED THE LENS IAW AMM 33-23-00, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201802269045Lens · missingSEAT 29D CEILING EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS IAW AMM 33-53-00.
Back to JASC 3350