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 DALA2017073005940Battery · dischargedEMERGENCY EXIT LIGHTS BOTH SIDES INOPERATIVE. REMOVE AND REPLACE BALLAST AND BATTERY FOR AFT EXIT LIGHTS. OPERATION CHECKS GOOD.3344683)SDR SWAA2017080315478Lens · brokenL1 DOOR EMERGENCY LIGHT LENS MOUNT BROKEN. R & R THE LENS ASSY IAW MM.SDR AALA201708029013Panel · missingFORWARD GALLEY EXIT PANEL BY THE R1 DOOR IS MISSING. REPLACED EMERGENCY EXIT COVER AS REQUIRED.SDR AALA201708029012Lens · missingAFT GALLEY EMERGENCY EXIT LIGHT COVER MISSING, REPLACED AFT GALLEY EMERGENCY LIGHT COVER IAW AMM 33-50-00.SDR AALA201708029011Power Supply · faultyRIGHT EMERGENCY EXIT EMERGENCY POWER SUPPLY UNIT FAULTED. REMOVED AND REPLACED THE EMERGENCY EXIT EPSU IAW AMM 33-51-38.SDR DALA2017073105925Lens · missingEMERGENCY EXIT LENS COVER MISSING ABOVE R1 DOOR. INSTALLED EXIT SIGN COVER. LP#3350712SDR SWAA2017080115408Lens · looseLT OVERWING EMERGENCY EXIT SIGN LENS LOOSE. SECURED LENS PER MM.SDR AALA201708019031Sign · unsecureTHE AIRCRAFT WAS NOT GROUNDED. LENS FELL OFF OF EXIT IDENTIFIER LIGHT AT LEFT AFT GALLEY DOOR. REPLACED LIGHT L01190 PER AMM 33-51-02.SDR DALA2017073105856Lens · detachedEXIT SIGN AT THE L2 DOOR FELL OFF. SECURED THE EXIT SIGN LENS.SDR AALA201708019021Light · brokenR4 DOOR EMERGENCY EXIT LIGHT BROKEN AT BOTTOM OF LENS. REPLACED LIGHT ASSEMBLY IAW AMM 33-51-13.SDR AALA201707319021Lens · missingMISSING EMERGENCY LIGHT LENS OVER THE L4 DOOR. INSTALLED A NEW LENS.SDR AALA201707319020Battery · dischargedEMERGENCY.EXIT BATTERY AFT LEFT INOPERATIVE. REMOVED AND REPLACED EMERGENCY EXIT BATTTERY .AFT L REF IAW AMM 33-51-38.SDR SIMA20170730001Light · intermittentEMERGENCY LIGHTS ON STATUS INTERMITTENT, EVEN WITH EMERGENCY LIGHTS SWITCH OFF. PERFORMED AND OPERATIONAL TEST OF THE EMERGENCY LIGHTS IAW AMM 33-51-00, OPS CHECKED GOOD.SDR JJBA20170730029Inverter · inoperativeEMERGENCY EXIT LIGHTS AT ROW 18 ARE INOPERATIVE. R & R THE NR 5 INVERTER.SDR HNAA2017073100253Light · inoperativeEMERGENCY AISLE LIGHT INOPERATIVE AT ROW 7SDR MASA2017073012505Light · inoperativeROW 21 OVERHEAD EMER FLOOD LIGHT INOP. PLACED ON MEL.SDR CALA2017073002452Light · intermittentEXIT PATH LIGHTING IS FLICKERING PERFORMED CIDS EMERGENCY SYS LIGHT TEST, NO FAULTS, RESET CIDS A S A PRECAUTION. OK FOR SERVICE.SDR CALA2017073002449Fuse · blownEMERGENCY LIGHTS AT SEAT AREA 25 & 28DEF BULLNOSE ARE INOP. RELAMPED NO HELP. REPLACED FUSE AND OPS CK GOOD. REF AMM 33-51-03-960-801 AND IPC 33-51-06-02 C/W IDT INSPECTION REF 09-10-05.SDR CALA2017073002448Light · looseEMERGENCY EXIT FLOOR LIGHT STRIP OVER CENTER LOOSE NEEDS SECURING FLOOR PROXIMITY LIGHT INSTALLED PER AMM 33-51-10, OK FOR SERVICE .SDR CALA2017073002446Light · inoperativeDOOR 4L SLIDE/OVERWING LIGHT INOP, REF AMM 33-51-04. EMERGENCY LIGHT 4L RELAMP AND OPS CHECK GOOD. REF AMM 33-51-04.SDR MASA2017073012503Light · inoperativeEMER FLOOD LIGHT ROW 18 INOP. PLACED ON MEL.SDR DALA2017080906102Fuse · inoperativeL2 EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE FUSE IN THE BATTERY PACK SUPPLY IAW WDM 33-51.SDR DALA2017080305957Light · inoperativeEMERGENCY LIGHT INOPERATIVE IN BULLNOSE OVER SEAT 32ABC. REPAIRED IAW AMM 33-51.SDR SWAA2017080115443Light · inoperativeRT WING TRAILING EDGE EMERGENCY LIGHT INOP. RELAMPED LIGHT IAW MM.SDR AALA201707319077Cover · detachedTHE AIRCRAFT WAS NOT GROUNDED. ON PREFLIGHT FOUND AFT SERVICE DOOR EMERGENCY EXIT LIGHT COVER DETACHED. REPLACED EMERGENCY LIGHT ASSEMBLY IAW AMM 33-50-00.SDR AALA20170729002Light · brokenTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT PATHWAY LIGHT BY L1 DOOR BROKEN OFF. REPLACED EMER LIGHT ASSY BY FIRST CLASS CLOSET, OPS CHECKS GOOD REF AMM 33-51-00.SDR DALA2017073105880Lens · missingRT OVERWING EXIT HATCH EMERGENCY LIGHT LENS MISSING. INSTALLED EMERGENCY LIGHT LENS AT RT OVERWING EXIT.SDR DALA2017080205877Lens · missingFOUND EMERGENCY LIGHT LENS MISSING IN BULLNOSE OVER SEAT 32ABC. INSTALLED LIGHT BULB & INSTALLED LENS IAW AMM 33-50, OPS CHECKED GOOD.SDR AALA201708019009Light · damagedEMERGENCY LIGHTS AT SEAT 13C INOPERATIVE. REPLACED EMERGENCY LIGHT ASSEMBLY AT 13C IAW AMM 33-51-19. ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201708019008Lens · missingOVERHEAD EMERGENCY LIGHT AT ROW 9 MISSING THE LENS. REPLACED EMERGENCY LIGHT LENS IAW AMM 33-51-00.SDR AALA201708019006Light · brokenBROKEN EMERGENCY AISLE LIGHT AT 3C. REPLACED EMERGENCY LIGHT AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR R61A201708010546Light · inoperativePHOTOLUMINESCENT STRIP AT 1D AND F NOT WORKING. R&R PHOTOLUMINESCENT STRIP AT 1D AND F AND INSTALLED DOUBLE DOT PLACARD IAW AMM 33-50-21. OPS CHECK GOOD.SDR AALA201708019027Light · damagedEMERGENCY LIGHTS AT SEAT 22C ARE INOPERATIVE. REPLACED EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-19. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR ASAA2017072921506Housing · detachedR2 EXIT SIGN ABOVE DOOR LENS BROKEN OFF. ACFT GROUNDED. REMOVED AND REPLACED THE R2 DOOR EMERGENCY EXIT SIGN IAW AMM 33-51-01. OPS CHECKED NORMAL.SDR 29GA2017073100002Bulb · inoperativeEMERGECNY LIGHT SWITCH ARM AND ON INDICATORS DO NOT ILLUMINATE. REPLACED EMERGENCY LIGHT SWITCH BULBS, OPERATIONAL CHECKED NORMAL.SDR HNAA2017073100254Light · inoperativeTHE THIRD RED AFT EMERGENCY AISLE LIGHT IS INOPERATIVE.SDR MASA2017072912500Light · inoperativeLT OVER WING LWR EMERG EXIT SIGN 1 BULB INOP. MX REPLACED BULB.SDR CALA2017072902433Battery · dischargedEMERGENCY LIGHT TEST FAULTS DOOR 1 LEFT. REPLACED DOOR 1 LEFT BATTERY AND TEST PER MM 33-51-38. CHECKS NORMAL.SDR CALA2017072902430Light · faultyON NR 2 SERVICE CHECK, FOUND EMERGENCY AISLE PATH LIGHTING INOP FROM ROW 25 TO ROW 30. FOUND EMERGENCY LIGHT ASSY ON ROW 30 ABC BLOWING OUT THE FUSE ON EMERGENCY POWER PACK. REMOVED AND REPLACED FUSE AND LIGHT ASSY. EMERGENCY LIGHTS OPS NORMAL.SDR CALA2017072902434Light · inoperativeEMERGENCY LIGHT ON SEAT 7B INOP. RELAMPED EMERGENCY LIGHT AT 7B, OPS CHECK GOOD.SDR CALA2017072902432Lens · looseEMER EXIT SIGN AT EXIT. SECURED LENS.SDR CALA2017072902431Light · missingEMERGENCY EXIT ROW PATH LIGHTING MISSING BULB. REPLACED LIGHT ASSEMBLY.SDR DALA2018030801530Bracket · damagedFOUND EMERGENCY LIGHT AT ESCAPE RAMP PANEL IN POOR CONDITION. REPLACED THE BRACKETS IAW SRM 51-40-02.SDR SWAA2017080315477Lamp · inoperativeR1 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMPS IAW MM.SDR SWAA2017080115461Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PACK PER AMM.SDR SWAA2017080115460Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PACK PER AMM.SDR SWAA2017080115459Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PACK PER AMM.SDR SWAA2017080115442Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R&R BATTERY PACK PER AMM.SDR SWAA2017080115428Lens · looseR2 DOOR EMERGENCY EXIT SIGN LENS COVER LOOSE. R&R SIGN ASSEMBLY IAW AMM.SDR AALA201707319073Cover · missingTHE AIRCRAFT WAS NOT GROUNDED. 4R DOOR EMERGENCY EXIT LIGHT COVER MISSING. REPLACED 4R EMERG LIGHT COVER. OPS CHECK NORMAL PER MM 33-50-00.
Back to JASC 3350