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 F3LA2017042400115Deu · no testEPSU TEST FAILED. REMOVED AND REPLACED FWD CABIN DEU. OPS CHECKED GOOD.SDR DALA2017042303301Light · inoperativeDURING SERVICE CK FOUND EXIT SIGNS AT ROW 19A NEED RELAMPED. RELAMPED EXIT SIGNALS AS REQUIRED. OK FOR SERVICE.SDR MASA2017042212754Light · missingEMER FLOOD LIGHT ROW 19 BULB MISSING. RELAMPED.SDR MASA2017042112753Light · inoperativeEMER FLOOD LT AT ROW 6 INOP. RELAMPED.SDR CALA2017042101106Lens · broken1EA EMERGENCY PATH WHITE LENSES BROKEN AT 5B, 12C, 21C. R&R WHITE EMERGENCY LIGHT ASSYS AT SEAT 5B, 12C, 21C. LIGHT CKS GOOD.SDR CALA2017042101105Cover · missingEMERGENCY EXIT LIGHT COVER ON WALL JUST AHEAD OF SEAT 1B IS MISSING/BROKEN. REPLACED MISSING EMERGENCY LIGHT COVER ON GALLEY FWD OF SEAT 1B AS REQUIRED. LIGHT CHECKS NORMAL.SDR CALA2017042101104Light · missingEMERGENCY PATH LIGHT MISSING AT ROW 24ABC. REPLACED MISSING EMERGENCY PATH LIGHT AT 24ABC. OPS CHECK GOOD.SDR CALA2017042101103Lens · brokenEMERGENCY EXIT SEAT LIGHT LENS AT 26C BROKEN. REPLACED EMERGENCY EXIT SEAT LIGHT LENS AT 26C. LIGHT OPS CHECK NORMAL.SDR CALA2017042101100Light · brokenAFT EMERGENCY EXIT SEAT LIGHT AT 15C BROKEN. REPLACED BOTH LIGHT BULBS AND LENS. EMERGENCY EXIT LIGHTS AT 15C OPS CHECK NORMAL.SDR CALA2017042101099Battery Pack · dischargedRIGHT SIDE AFT OF WING LOWER BODY EMERGENCY LIGHT OUT/INOP REPLACED FUSES AND BATTERY PACK M1670 PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR CALA2017042101097Battery Pack · dischargedSEVERAL EMERGENCY LIGHTS INOP. REPLACED BATTERY PACK ON M1670. EMERGENCY LIGHTS OPS CHECKS GOOD, NO OTHER DEFECTS NOTED.SDR CALA2017042101096Sign · missingDOOR 1R, SMALL EMERGENCY EXIT SIGN IS MISSING. REPLACED EMERGENCY EXIT LIGHT IAW AMM 33-51-01. OPS CHECK GOOD.SDR CALA2017042101094Battery Pack · dischargedOVERHEAD EMERGENCY LIGHTS ROW 4R,5R,7R, AND 8R INOP. REMOVED AND REPLACED BATTERY PACK AT M6756 PER AMM 33-51-07, ALL OPS NORMAL AT AFFECTED ROWS.SDR CALA2017042101093Fuse · inoperativeEMERGENCY LIGHT AT ROW 2LK INOP. REMOVED AND REPLACED POWER SUPPLY M730 FUSE AT PIN 15 IAW AMM 33-51-07-962-024-001. PERFORMED OPS CHECK OF EMERGENCY LIGHT AT 2LK IAW AMM 33-51-00. OPS CHK GOOD.SDR CALA2017042101101Lens · brokenEMERGENCY EXIT SEAT LIGHT AT 29C BROKEN. REPLACED SEAT EXIT LIGHT LENS, OPS NORMAL.SDR CALA2017042101098Lens · missingLENS COVER MISSING SEAT 21A EMERG EXIT LIGHT. REPLACED EXIT LIGHT LENS.SDR CALA2017042101095Light · inoperativeDOOR 2L SLIDE LIGHT DOES NOT ILLUMINATE RELAMPED, OPS CHKS GOOD. OK TO CONTINUE.SDR CALA2017042101092Lens · brokenEMERGENCY EXIT LIGHT LENS IS BROKEN AT SEAT 20J. INSTALLED NEW EMERGENCY EXIT LIGHT LENS.SDR CALA2017042101091Cover · missingEMERGENCY EXIT LIGHTS DAMAGED 121-22B DR-2L FWD LAV 121 2L EXIT LIGHT COVER MISSING. REPLACED EXIT INDICATOR ASSY.SDR CALA2017042101090Light · brokenPARTITION 4EA EMERGENCY LIGHT FOUND BROKEN. PARTITION 4EA EMERGENCY LIGHT REPLACED & FUNCTIONAL TEST C/O FOUND NORMAL REF AMM 33-51-00-710-801 REV 79.SDR CALA2017042101089Light · brokenM/D GALLEY 2EA EMERGENCY LIGHT FOUND BROKEN. M/D GALLEY 2EA EMERGENCY LIGHT REPLACED & FUNCTIONAL TEST C/O FOUND NORMAL REF AMM 33-51-00-710-801 REV 79.SDR CALA2017042101088Battery · dischargedTEST FOUND L33531 AND L33552 EMERGENCY LT INOP. REPLACED LOW CAPACITY BATTERY M33097 AND M33406 AND TEST FOUND NORMAL REF SSM 33-51-13, SSM33-51-14 REV 69 AND AMM 33-51-06-960 -802 REV 79.SDR CALA2017042101087Battery Pack · dischargedDURING EMERGENCY BATTERY PACK CAPACITY CHECK, FOUND BATTERY PACK AT DOOR 1R (M33094) AND DOOR 4L (M33407) LOWER CAPACITY. REPLACED M33094 AND M33407 BATTERY PACK AND TEST OF NEW BATTERY PACK FOUND NORMAL REF AMM 33-51-06-960-802 REV 79.SDR CALA2017042101086Battery · faultyLT CENTER OVERWING EMERG PWR SUPPLY UNIT FAULTY BATTERY, REMOVED AND REPLACED LT CENTER OVERWING EMERGENCY PWR UNIT BATTERY TO CLEAR FAULT. REF AMM 33-51-38-400-002-A VERIFIED INSTALLATION AND OPERATIONAL TEST OF LT CENTER OVERWING EMERGENCY PWR UNIT BATTERY PSDR CALA2017042101084Power Supply · inoperativeEEL TEST FAILS UNIT FWD L. REPLACED FWD L EPSU, POWER SUPPLY AND BATTERY, REF AMM 33-51-38- 401, OPS. TEST GOOD MSG CLEARED.SDR CALA2017042101083Battery · dischargedEEL TEST FAILS BATTERY L. REPLACED BATT. LEFT OVERWING POSITION, REF AMM 33-51-38-401, OPS TEST GOOD, MSG CLEARED.SDR CALA2017042101082Power Supply · inoperativeAFT CABIN EMERGENCY LIGHTS INOP. REPLACED EPSU REF AMM 33-51-38-000-001-A AND IPC 33-51-38-01B. OPS CHECK GOOD.SDR CALA2017042101081Battery Pack · faultedFOUND ON RON CHECK. FWD AND AFT LEFT EEL BATTERY PACK FAULTS. REPLACED FWD AND AFT EEL BATTERY PACKS. OPS CHECKED NORMAL.SDR CALA2017042101080Cover · brokenPLASTIC COVER FOR EMERGENCY EXIT LIGHTS IN AFT CABIN MISSING. REPLACED THE COVER.SDR CALA2017042101079Light · no testCABIN EMERGENCY LIGHT OPS CHECK IS FAILING PER 2 SVC RESET AFT L CENTER EPSU BATTERY. GROUND TESTED GOOD IAW 33-00-00.SDR CALA2017042101102Lamp · inoperativeEXTERIOR EMERGENCY LIGHT AFT OF THE R2 DOOR FOUND INOPERATIVE. REPLACED THE LAMPS, OPS NORMAL.SDR CALA2017042101048Lamp · inoperativeROW 8ABC EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS AND OP CHECKED GOOD IAW 33-51-05-002-001.SDR CALA2017042101047Lamp · inoperativeROW 30ABC OVERHEAD EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS AND OP CHECKED GOOD IAW 33-51-05-002-001.SDR AALA201704259029Light · missingEMERGENCY LIGHT MISSING AT 13D. INSTALLED MISSING EPM LIGHT ASSY AT SEAT 13D AND OPS CHECKED IAW AMM 33-60-98.SDR AALA201704259028Lens · missingAFT RIGHT CABIN DOOR EXIT LIGHT COVER MISSING. INSTALLED NEW AFT RIGHT CABIN DOOR EXIT LIGHT COVER IAW AMM 33-51-01.SDR SWAA2017042513378Battery · no testLEFT AFT BATTERY FAILED A TIME TEST. R & R THE BATTERY IAW AMM.SDR SWAA2017042513367Lens · detachedFORWARD ENTRY EXIT EMERGENCY EXIT LIGHT LENS CAME OFF. INSTALLED THE LENS IAW SIP.SDR SWAA2017042513366Cover · detachedRIGHT OVERWING EXIT LIGHT COVER FELL OFF. R & R THE COVER IAW AMM.SDR SWAA2017042513364Battery Pack · failedFORWARD ENTRY OVERHEAD LIGHT SMOKING, FOUND EMERGENCY EXIT LIGHTING BATTERY PACKS IN FORWARD GALLEY TO BE THE SOURCE OF SMOKE. R & R BATTERY PACK IAW AMM.SDR SWAA2017042513359Battery · no testRIGHT FORWARD BATTERY FAILED A TIME TEST. R & R THE BATTERY IAW AMM.SDR SWAA2017042513354Lens · missingR2 DOOR EXIT LIGHT LENS COVER MISSING. INSTALLED THE LENS IAW AMM.SDR SWAA2017042513347Lens · missingAFT ENTRY EXIT SIGN LENS MISSING. REPLACED THE LENS IAW AMM.SDR SWAA2017042513311Lamp · inoperativeLEFT OVERWING EXTERNAL EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR SWAA2017042513300Lamp · inoperativeL2 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR SWAA2017042513297Lens · dirtyLEFT WING TO BODY FAIRINGS AFT EMERGENCY EXIT LIGHT LENS DIRTY. CLEANED THE LENS IAW SOPM.SDR SWAA2017042513296Lens · looseL1 DOOR EMERGENCY EXIT LENS LOOSE. R & R THE LENS IAW MM.SDR SWAA2017042513292Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY TEST AT LOCATION M1673. R & R THE BATTERY PACK IAW AMM.SDR AALA201704249028Lamp · looseEXTERIOR EMERGENCY EVACUATION SLIDE LIGHT AT L4 DOOR IS INOPERATIVE. SECURED THE LAMP IN THE LIGHT ASSEMBLY IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR AALA20170421002Lens · missingEMERGENCY EXIT SIGN AT R2 DOOR HAS A MISSING LENS. REPLACED THE LENS IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA20170421001Lens · missingEMERGENCY EXIT SIGN OUTSIDE FORWARD GALLEY LOWER AISLE HAS A MISSING LENS. REPLACED THE LENS IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.
Back to JASC 3350