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 CALA2018011200150Light · noneL4 DOOR INTERIOR EMERGENCY LIGHTS INOPERATIVE. ACCOMPLISHED AN OPS CHECK IAW AMM33-51-00, OPS CHECKED NORMAL.SDR CALA2018011200149Battery Pack · inoperativeOVERHEAD AISLE EMERGENCY LIGHTS INOPERATIVE AT SEAT ROW 3. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-07-02B, TESTED OK.SDR CALA2018011200148Light · malfunctionedEMERGENCY EXIT LIGHTS DID NOT COME ON AFTER POWER LOSS, EVEN WITH THE SWITCH ON. RESET THE EMERGENCY LIGHTS LOAD CONTROL, ACCOMPLISHED A BITE IAW MM 33- 51-00-06A, NO FAULTS, OPERATES NORMAL AT ALL LOCATIONS.SDR CALA2018011200164Lamp · inoperativeRIGHT FWD DOOR EXTERIOR EMERGENCY LIGHT FOUND INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51-00, AND TESTED NORMAL IAW AMM 33-51-00.SDR CALA2018011200163Bulb · malfunctionedSEAT 11 DEF OVERHEAD BIN EMERGENCY LIGHT FOUND ILLUMINATED. THE BULB WAS REPLACED AND LIGHT TESTED NORMAL IAW AMM 33-51-00SDR CALA2018011200162Battery Pack · inoperativeEMERGENCY LIGHTS 30 ABC AND 32 ABC INOPERATIVE. INSTALLED A NEW BATTERY CHARGER AND BATTERY PACK. CHECKED NORMAL.SDR CALA2018011200161Battery Pack · failedEMERGENCY LIGHTS AT SEAT ROWS 22 - 37 AND AT THE R2 DOOR INOPERATIVE. FOUND THE BATTERY PACK AND CHARGER BAD. REPLACED BOTH. OPS CHECKED OK.SDR CALA2018011200160Bulb · inoperativeLEFT EMERGENCY LIGHT OVER FLAP INOPERATIVE. REPLACED THE BULB IAW AMM 33-51-04-960-801. OPS CHECKED GOOD.SDR CALA2018011200159Bulb · inoperativeCOCKPIT EMERGENCY DOME LIGHT INOPERATIVE. REPLACED THE BULB IAW AMM 33-14-00-960-804. OPS CHECKED GOOD.SDR CALA2018011200156Power Supply · inoperativeROW 25, 26, & 27 EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY IAW WD 33-51-22.SDR CALA2018011200119Power Supply · inoperativeSEAT ROWS 1 - 5, MOUNTED EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY AND BATTERY PACK IAW MM 33-51-06.SDR AALA20180112012Battery Pack · failedAIRCRAFT WAS NOT GROUNDED. BATTERY PACK M1674 FAILED CAPACITANCE CHECK CARD 2908. REPLACED M1674 PER MM 33-51-06.SDR AALA20180112011Battery Pack · failedAIRCRAFT WAS NOT GROUNDED. BATTERY PACK M1670 FAILS CAPACITANCE CHECK CARD 2908. REPLACED M1670 PER MM 33-51-06.SDR SWAA2018011719139Lens · noneRIGHT LOWER EXTERNAL EMERGENCY EXIT LIGHT LENS DIRTY. CLEANED LENS IAW SOPM.SDR SIMA20180111005Light · inoperativeNR 5 EMERGENCY LIGHT STRIP INOPERATIVE. REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-120. OPS CHECKED GOOD.SDR SWAA2018011619121Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER DWG.SDR SWAA2018011619120Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R&R BATTERY PER DWG.SDR SWAA2018011619119Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER DWG.SDR SWAA2018011619118Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1668. R&R BATTERY PER DWG.SDR SWAA2018011619115Battery Pack · failedCABIN EMERGENCY LIGHT BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M01675. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2018011619114Battery Pack · failedCABIN EMERGENCY LIGHT BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M01669. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2018011619039Battery Pack · no testCABIN EMERGENCY LIGHT BATTERY PACKS FAILED CAPACITY TEST AT M01674. R & R THE BATTERY PACK IAW AMM AND DWG.SDR SWAA2018011619002Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R & R THE BATTERY IAW DWG.SDR ASOA201801114004Inverter · inoperativeDURING A PREFLIGHT INSPECTION, THE AISLE EMERGENCY LIGHT STRIPS 2 & 3 WERE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE NR 2 EMERGENCY LIGHT INVERTER. OPS TESTED WITH NO DEFECTS NOTED AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR AALA201801129038Lens · detachedL1 DOOR EXIT LIGHT LENS FELL OFF. MAINTENANCE REPLACED THE LENS IAW AMM 33-15-13 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201801129045Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED. FIRST CLASS EMERGENCY AISLE LIGHTS ON SEATS INOPERABLE. REPLACED POWER SUPPLY AND BATTERY IAW MM 33-51-07.SDR AALA201801129042Sign · missingAIRCRAFT WAS NOT GROUNDED. FORWARD ENTRY EMERGENCY EXIT SIGN MISSING. REMOVED AND REPLACED FORWARD ENTRY LIGHT EXIT SIGN PER AMM 33-51-01-960-802.SDR AALA201801129031Sign · detachedAIRCRAFT WAS NOT GROUNDED. EXIT SIGN OVER SEAT 5H HAS FALLEN DOWN. REPOSITIONED EXIT SIGN ABOVE SEAT 5H PER 33-51-01.SDR CALA2018011200118Battery Pack · failedEMERGENCY LIGHTS IN BOTH SECTIONS OF BUSSINESS CLASS ARE INOPERATIVE. FOUND BATTERY PACKS AT THE WCU 21.1, 23.2 AND 24.1 FAILED. REPLACED THE BATTERIES IAW AMM 33-51-07-02B. ALL SEAT MOUNTED EMERGENCY LIGHTS NOW OPERATE NORMAL.SDR HALA2018011100003Sign · detachedDURING LANDING, THE R3 DOOR SIGN FELL OFF. INSPECTED SERVICEABLE AND REFITTED.SDR SIMA20180111003Battery · inoperativeGALLEY AND FLOOR EMERGENCY LIGHTS FROM ROW 7 FORWARD, INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT BATTERY AND CHARGER IAW WC 33-700-19. OPS CHECKED GOOD.SDR SIMA20180111004Battery Pack · inoperativeNR 4 EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-50-04, AND PERFORMED AN OPS CHECK IAW AMM 33-50-00. NO DEFECTS FOUND.SDR DALA2018011200231Housing · damagedEMERGENCY LIGHT HOUSING DAMAGED AT SEAT 35DEF. REMOVED AND REPLACED HOUSING IAW CMM 25-21-52.SDR DALA2018011200228Bulb · inoperativeR3 DOOR, OUTSIDE EMERGENCY LIGHT ASSY FOR SLIDE ILLUMINATION, INOPERATIVE. REMOVED HOUSING ASSY APPEARS TO HAVE A SHORT IN THE WIRING OR FERRULE ASSY. REPLACED LENS & BULB IAW AMM 33-50-06.SDR IPXA2018011125377Bracket · damagedL1 DOOR INTERIOR EMERGENCY EXIT LIGHT DAMAGED. R & R THE SIGN IAW MM 33-51-01-962-028. REPAIRED THE MOUNTING BRACKET IAW EO 5210 67082 B, PARAGRAPH 6.SDR IPXA2018011225392Bulb · inoperativeEMERGENCY EXIT HAS THREE BULBS OUT. INSTALLED THE BULBS IAW AMM 33-51-01-2SDR AALA201801129006Lens · looseEMERGENCY LIGHT LENS NEAR SEAT 1C IS LOOSE. SECURED THE LENS. OPS CHECKED OK.SDR SWAA2018011218995Lens · missingLT OVER WING EMERGENCY EXIT LIGHT COVER MISSING. R&R LENS IAW SIP.SDR REXA2018011100015Light · inoperativeLT OVERWING EXTERIOR EMERGENCY CENTER LIGHT NR 3 INOP. R&R EXTERIOR EMERGENCY OVER WING CENTER LIGHT NR 3 IAW AMM 35-51-21. OPS CHECK GOOD.SDR DALA2018011200224Battery Pack · dischargedOVERWING EMERGENCY LIGHT INOP. T/S, R&R OVERWING EMERGENCY EVACUATION LIGHT BATTERY PACK PER MM 33-53. OPS CHK - GOOD. OK FOR SVC.SDR MASA2018011112906Bulb · inoperativeAFT EMERGENCY CEILING LIGHT INOPERATIVE. REPLACED THE BULBSSDR MASA2018011112905Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACK NR 1 INOPERATIVE. REPLACED THE BATTERY PACK AND CHARGER.SDR AALA20180111004Battery Pack · inoperativeEXIT SIGNS AT THE R1 DOOR INOPERATIVE. REPLACED THE BATTERY PACK M10798 IAW AMM 33-51-07. CHECKED GOOD.SDR AALA20180111003Battery Pack · inoperativeEXIT SIGNS AT THE L1 DOOR INOPERATIVE. REPLACED THE BATTERY PACK M10798 IAW AMM 33-51-07. CHECKED GOOD.SDR AALA20180111002Battery Pack · inoperativeSEAT MOUNTED EMERGENCY LIGHTS FROM 1E TO 4E INOPERATIVE. REPLACED THE BATTERY PACK M10798 IAW AMM 33-51-07. LIGHTS CHECKED GOOD.SDR SWAA2018011619113Charger · damagedBATTERY CHARGER BATTERY PACK HOLD DOWN CLIPS DAMAGED AT LOCATION M01669. R&R CHARGER PER AMM.SDR SWAA2018011619112Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01675. R&R BATTERY PACK PER AMM.SDR SWAA2018011619111Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01672. R&R BATTERY PACK PER AMM.SDR SWAA2018011619110Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01670. R&R BATTERY PACK PER AMM.SDR SWAA2018011619109Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01669. R&R BATTERY PACK PER AMM.
Back to JASC 3350