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 AALA20161122018Control Module · faultyEMERGENCY LIGHTING INOPERATIVE BETWEEN ROW 26C AND DOOR R4. REMOVED AND REPLACED TWO CONTROL MODULES AND TWO BATTERY PACKS.SDR AALA20161122015Control Module · faultyEMERGENCY LIGHTING INOPERATIVE BETWEEN ROW 26C AND DOOR R4. REMOVED AND REPLACED TWO CONTROL MODULES AND TWO BATTERY PACKS.SDR SIMA20161121010Battery Pack · inoperativeNR 4 EMERGENCY LIGHT BATTERY IS DEAD. R & R THE BATTERY IAW AMM 33-50-04.SDR SWAA2016112809937Lens · missingFORWARD EMERGENCY EXIT LENS MISSING. INSTALLED LENS IAW SIP.SDR SWAA2016112809935Sign · brokenFORWARD ENTRY EMERGENCY EXIT SIGN BROKEN. R&R SIGN ASSEMBLY IAW MM.SDR REXA2016112102299Sign · inoperativeFLOOR LEVEL EXIT SIGN AT PAX DOOR DOES NOT OPERATE WHEN TESTING EMER BATTERY PACKS 1 AND 3. PERFORMED OPS TEST OF EMERGENCY LIGHT BATTERY PACKS 1 AND 3. NO DEFECTS NOTED IAW AMM 33-51-04-740-801.SDR AALA201611239025Power Supply · faultyFINAL CHECK, EMERGENCY LIGHT TEST FAULTING FOR FWD LT EPSU. R & R THE EPSU IAW AMM 33-51-38. THE AIRCRAFT WAS GROUNDED.SDR DALA2016112200212Light · missingSEAT 39H EMERGENCY LIGHT ASSEMBLY MISSING. REPLACED HOUSING AND THE LIGHT ASSEMBLY IAW AMM 33-51.SDR AALA20161123017Sign · looseEMERGENCY EXIT SIGN OVER SEATS 24AB LOOSE. SECURED THE SIGN. OPERATIONAL CHECKED GOOD.SDR AALA20161123016Sign · detachedEMERGENCY EXIT SIGN AT SEATS 24ABC IS DETACHED. REPLACED BROKEN DOWEL PINS. OPERATIONAL CHECK GOOD.SDR DALA2016112309156Lens · damagedEMERGENCY EXIT COVER DIFFUSER LENS DAMAGED. INSTALLED EXIT SIGN COVER.SDR SIMA20161121003Power Supply · inoperativeCABIN FWD AISLE EXIT LIGHTS AND RT OVERWING FWD EMERGENCY EXIT LIGHTS INOPERATIVE. NR 2 POWER SUPPY BATTERY PACK AND BATTERY POWER SUPPLY R & R IAW WORKCARD 33-70-19. OPS CHECKED GOOD.SDR SWAA2016112209917Lens · looseL1 DOOR EMERGENCY EXIT LIGHT LENS LOOSE. R & R THE LIGHT ASSY IAW MM.SDR SWAA2016112209916Sign · brokenFWD GALLEY EMERGENCY EXIT SIGN BROKEN. R & R SIGN IAW MM.SDR SWAA2016112209915Control Panel · faultyEMERGENCY EXIT LIGHTS WOULD NOT TURN OFF. R & R THE CONTROL PANEL IAW MM.SDR SWAA2016112209914Lens · brokenFWD ENTRY EXIT LIGHT LENS BROKEN. R & R THE LENS IAW MM.SDR JJBA20161121026Light · malfunctionedCENTER AISLE EMERGENCY LIGHT INOPERATIVE. RESET ACFT POWER. EMERGENCY LIGHTS OPS CHECKED GOOD.SDR CALA2016112100957Battery Pack · dischargedALL EMERGENCY PATH LIGHT ARE INOP, SEATS 7-12. REMOVED AND REPLACED EMERGENCY LIGHTS BATTERY CHARGER AND BATTERY PACK, M1676. OPERATES NORMAL. REF WDM 33-51-12 AMM 33-51-06.SDR CALA2016112100956Battery Pack · dischargedLT AFT (L2) DOOR OVER DOOR EMERGENCY LIGHT INOP. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-51-06. OPS CK GOOD.SDR CALA2016112100955Light · inoperativeR FWD EMEG EXIT DOOR LIGHT INOP. RELAMPED R FWD EMERG EXIT DOOR WINDOW LIGHT. OPS CHECK GOOD.SDR CALA2016112100953Battery Pack · dischargedEMERGENCY LIGHT INOP AT SEATS 29 TO 32. REPLACED BATTERY PACK EMERGENCY POWER. OPS CHK OK.SDR CALA2016112100952Light · inoperativeSLIDE LIGHT BURNED OUT DURING CRUISE AT DOOR 1R. RELAMPED, CKS OKAY.SDR CALA2016112100950Light · intermittentEMERGENCY LIGHTS TURNED ON AND OFF FOR 3 SECONDS BY THEMSELVES. PERFORMED OPERATIONAL TEST EMERGENCY LIGHT IAW AMM 33-51-00-715- 001-001. OK FOR SERVICE.SDR CALA2016112100949Light · inoperativeCABIN EEL CEILING LIGHT AT 23GFE FAILED OPS CHECK. RELAMPED, OPS CKD GOOD PER AMM 33-51-00 PG 501. ACPD IDT OF EEL LIGHT INSTLN. OPS CHECK NORMAL.SDR CALA2016112100948Sign · malfunctioned3L, 4L & 4R MED EEL EXIT SIGN FAILED OPS CHECK. OPS CHECKED GOOD PER AMM 33-51-00 PG501. ACPD IDT OF EEL. OPS CHECK GOOD.SDR CALA2016112100947Battery Pack · discharged2L MED AND 2R MED EEL EXIT SIGN FAILED OP CHECK. OPS CHECKED GOOD PER AMM 33-51-00 PG501. ACO INSP OPS CHECK GOOD REPLACED BATTERY PACK M6003 ABOVE DR 2L, REF SSM 33-51-04 PAGE 1 03 SHEET 1. LIGHTS OP GOOD.SDR CALA2016112100945Battery Pack · dischargedEMERGENCY EXIT LIGHTS FAIL OPERATIONAL TEST. REMOVED AND REPLACED BATTERY PACK AT STA 500C RT AND STA 665 RT IAW AMM 33-51-06. OPS CHECK GOOD IAW AMM 33-51- 00-720-801.SDR CALA2016112100944Battery Pack · defectiveEMERGENCY EXIT LIGHTS BATTERY PACK AT STA 332 L WON’T HOLD A CHARGE. REMOVED AND REPLACED EMERGENCY EXIT LIGHT BATTERY PACK AT STA 3 32 LT IAW AMM 33-51-06. OPS CHECK GOOD.SDR HNAA2016112100353Bulb · inoperativeDIM EMERGENCY LIGHT ON RIGHT AFT SIDE OF FUSELAGE. REMOVED AND REPLACED THE BULB. OPS CHECKED GOOD.SDR HNAA2016112100352Battery Pack · inoperativeEMERGENCY LIGHTS AT RIGHT AFT SIDE OF FUSELAGE, CENTER AISLE EXIT SIGN AT ROW 11, AND CENTER OVERHEAD LIGHTS AT ROW 9 AND 13 ARE INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY IAW 33-50-05. OPS CHECKED GOOD.SDR HNAA2016112100351Battery Pack · dischargedEMERGENCY LIGHTS ARE DIM AND MULTIPLE LIGHTS ARE INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACKS IAW 33-50-05R AND 33-50-03Q. OPS CHECKED GOOD.SDR A6WA2016112144598Sign · inoperativeLOWER EMERGENCY EXIT SIGN (GREEN) INOPERATIVE SEAT 8A.SDR SWAA2016120510207Light · brokenLT OVERHEAD STOWAGE BIN BULLNOSE AISLE LIGHT BROKEN BETWEEN ROW 3 TO ROW 5. R&R LIGHT IAW AMM.SDR DALA2016113009417Shroud · looseFLOOR PROXIMITY LIGHTS AT 32D, 35D, 42D, 47D, 52D, 54D, 55D, 51F HAVE LOOSE HOUSINGS BUT OPERATE NORMALLY. REPLACED SHROUDS.SDR AALA20161123012Lens · detachedSEAT MOUNTED EMERGENCY EXIT IDENTIFIER LENS COVER AT SEAT 15A IS DETACHED. REINSTALLED LENS COVER. OPERATIONAL CHECKED GOOD.SDR AALA20161123010Lens · detachedEMERGENCY EXIT SIGN LENS COVER IN FORWARD GALLEY IS DETACHED. REPLACED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA20161123009Lens · missingEMERGENCY LIGHT BETWEEN FORWARD GALLEY AND FIRST CLASS IS MISSING LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR HALA2016112000210Light · looseEMERGENCY FLOOR LIGHT TRIM LOOSE AT SEAT 24C AND FORWARD LAV AREA, ADJUSTED FLOOR LIGHT TRIM AT 24C.SDR AALA20161122023Lens · missingEMERGENCY LIGHT LENS COVER MISSING AT L1 DOOR. REPLACED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20161122022Mount · brokenOVERHEAD EMERGENCY EXIT SIGN AT SEAT 21ABC HAS A BROKEN MOUNTING RAIL. REMOVED AND REPLACED MOUNTING RAIL IAW 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20161120007Light · brokenG2 GALLEY EMERGENCY PROXIMITY LIGHT IS BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-14. OPERATIONAL CHECK NORMAL.SDR SWAA2016112209918Lens · looseEMERGENCY EXIT LIGHT LENS LOOSE AT MID CABIN. R & R THE LIGHT ASSY IAW MM.SDR SWAA2016112209912Lens · brokenRIGHT OVERWING EMERGENCY LIGHT LENS BROKEN. R & R THE LENS IAW MM.SDR SWAA2016112209889Lamp · inoperativeL2 DOOR SLIDE EXTERNAL EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW MM.SDR SWAA2016112209886Lens · missingRIGHT CABIN EXIT LIGHT LENS MISSING BETWEEN ROWS 5 & 6. INSTALLED LENS IAW MM.SDR DALA2016112209070Sign · inoperativeONE EXIT DESIGNATOR AT THE L1 DOOR & ONE EXIT DESIGNATOR AT THE L4 DOOR FOUND INOPERATIVE. INSTALLED MISSING EMERGENCY LIGHTS.SDR AALA201611219016Lens · brokenEMERGENCY LIGHT PATH LIGHT LENS COVER AT SEAT 5C IS BROKEN. REMOVED/REPLACED LENS COVER AT 5C IAW GPM NO TECH REF SEE TEXT FOR MAINT OR REPAIR DONE. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201611219013Lens · missingEMERGENCY FLOOR LIGHT RED LIGHT MISSING AT 9D. REPLACED RED FLOOR LIGHT LENS COVER AT 9D IAW AMM 33-50-00. OK FOR SERVICE. THE AIRCRAFT WAS NOT GROUNDED,SDR AALA201611219012Battery · failedEPSU BATTERY ABOVE 1L DOOR FAILS BITE. R&R EPSU (10WL) BATTERY IAW AMM 33-51-38 OPS CK'D GOOD. THE AIRCRAFT WAS NOT GROUNDED.SDR DALA2016112109047Light · shortedEMERG ESCAPE PATH LIGHTS INOP ON LEFT SIDE, LOC SEAT 32-37. TROUBLESHOOT AND FOUND SHORTED BULB/LIGHT ASSY AT 33 AB AND BLOWN FUSE AT BATT POWER SUPPLY. R&R BOTH ITEMS, OPS CK GOOD REF AMM 33-51.
Back to JASC 3350