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 AALA201808229014Housing · brokenEMERGENCY LIGHT PLASTIC HOUSING BROKEN ON SEATS 9C. REPLACED THE HOUSING.SDR DALA2018082205198Lens · unsecureEMERGENCY EXIT COVER DIFFUSER LENS UNSECURE. SECURED THE LENS.SDR DALA2018082205195Battery Pack · inoperativeROWS 1 - 12 AND FWD ENTRANCE DOORS EMERGENCY LIGHTS WERE INOPERATIVE. TROUBLESHOT IAW SRM 33-51. REPLACED THE BATTERY PACK B5-211 IAW AMM 33-53. OPS CHECKED GOOD.SDR 29GA2018082200001Light · unsecureFLIGHT 0122, FLOOR PROXIMITY LIGHT STRIP AT ROW 5A LOOSE. SECURED THE LIGHT STRIP IAW AMM 20-10-00.SDR MASA2018082113503Bulb · inoperativeTHREE OVERHEAD EMERGENCY LIGHTS INOPERATIVE. REPLACED THE BULBS.SDR MASA2018082113502Lamp · inoperativeROW 21 OVERHEAD EMERGENCY FLOOD LIGHT WAS INOPERATIVE. REPLACED THE LAMPS.SDR MASA2018082113501Light · inoperativeROW 15 OVERHEAD EMERGENCY FLOOD LIGHT WAS INOPERATIVE.SDR DALA2018082105160Battery Pack · inoperativeALL F/C EMERGENCY LIGHTS INOPERATIVE. REPLACED THE BATTERY PACK, OPS CHECKED GOOD IAW AMM 33-50.SDR CALA2018082601836Charger · inoperativeCEILING EMERGENCY LIGHT POWER SUPPLY M33098 CHARGER WAS INOPERATIVE. THE CHARGER WAS REPLACED, OPS CHECKED NORMAL IAW AMM 33-51-06.SDR CALA2018082761835Battery · dischargedL3 DOOR AREA CEILING EMERGENCY LIGHT POWER SUPPLY M33406 BATTERY CAPACITY WAS LOW. THE POWER SUPPLY BATTERY PACK WAS REPLACED AND CHECKED NORMAL IAW AMM 33-51-06.SDR DALA2018082545245Sign · inoperativeEMERGENCY EXIT SIGN DAMAGED. REPLACED THE SIGN ASSEMBLY.SDR R61A2018082400904Light · inoperativeCOCKPIT EMERGENCY LIGHT NOT WORKING. R&R COCKPIT EMERGENCY LIGHT ASSEMBLY.SDR AALA201808239017Battery · no testDURING A CIDS 1 TEST, A MESSAGE FOR THE BATTERY & EPSU 12WL. REPLACED THE BATTERY 12WL FOR EMERGENCY POWER SUPPLY IAW AMM 33-51-38. OPS CHECKED GOOD.SDR ASOA2018082305180Light · inoperativeDURING MX INSPECTION, THE FLOOR EMERGENCY EXIT LIGHT STRIP AT SEATS 8A AND 9A WAS FOUND INOPERATIVE. MX REMOVED AND REPLACED THE EMERGENCY LIGHT AND OPS CHECKED GOOD. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA2018082305179Charger · inoperativeDURING A MX INSPECTION, THE AFT OVERHEAD EMERGENCY EXIT LIGHT WAS INOPERATIVE. MX REMOVED AND REPLACED THE NR 3 EMERGENCY LIGHT CHARGER AND BATTERY, OPS CHECKED GOOD. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA2018082224511Sign · inoperativeCENTER OVERWING EMERGENCY EXIT LIGHT INOP. R&R SIGN ASSEMBLY PER AMM.SDR SWAA2018082224510Sign · unsecureL1 DOOR EMERGENCY EXIT SIGN CAME OFF. REINSTALLED SIGN PER AMM.SDR AALA201808229028Battery Pack · inoperativeONE OVERHEAD EMERGENCY LIGHT ABOVE SEAT ROW 16ABC WAS INOPERATIVE. TROUBLESHOT IAW FRM 33-50-00-810-801. REPLACED BATTERY PACK M1670 IAW AMM 33-51-06. OPS CHECKED GOOD.SDR SWAA2018082124477Light · inoperativeR2 DOOR OVERHEAD EMERGENCY EXIT SIGN BULB INOP. R&R BULB IAW AMM.SDR SWAA2018082124476Light · inoperativeL2 DOOR EGRESS LIGHT INOP. R&R LIGHT IAW AMM.SDR ASAA2018082105862Battery Pack · inoperativeINTERIOR EMERGENCY EXIT LIGHTS, ROWS 6, 9, AND 11 WILL NOT ILLUMINATE. ACFT GROUNDED. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-06-960-805-4D, AND OPS CHECKED GOOD IAW AMM 33-51-00-960-805.SDR AALA201808219016Power Supply · inoperativeFUNCTIONAL CHECK OF THE EMERGENCY POWER SUPPLY UNIT 10WL FOUND TO BE IN OPERATIVE. REPLACED EPSU IAW AMM 33-51-38-400-001-A, AND PERFORMED A BITE TEST OF THE EPSU. TESTED OK.SDR AALA201808219015Cids · malfunctionedEMERGENCY LIGHTS IN THE CABIN WILL NOT TURN OFF. RESET THE CIDS IAW TSM 23-73-00.SDR AALA201808219014Lens · looseEMERGENCY LIGHT INOPERATIVE. SECURED THE LENS. OPS CHECKED GOOD, OK FOR SERVICE.SDR DALA2018082105164Battery Pack · inoperativeCEILING EMERGENCY LIGHTS FROM ROWS 1 - 4 INOPERATIVE. REPLACED THE BATTERY PACK B5-100. OPS CHECKED GOOD. OK FOR SERVICE IAW AMM 33-53.SDR DALA2018082005159Battery Pack · inoperativeCEILING EMERGENCY LIGHTS FROM ROW 22-25 WERE INOPERATIVE. R & R THE BATTERIES IAW AMM 33-53. OPS CHECKED GOOD. OK FOR SERVICE.SDR IPXA2018082032997Lamp · inoperativeEMERGENCY LIGHT CEILING MCD INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-00, OPS.SDR SWAA2018083024698Lens · crackedRT OVERHEAD BIN EMERGENCY LIGHT LENSES CRACKED. R&R LENS IAW AMM.SDR SWAA2018083024697Lens · crackedLT OVERHEAD BIN EMERGENCY LIGHT LENSES CRACKED. R&R LENS IAW AMM.SDR SIMA2018082019005Light · inoperativeSECOND EMERGENCY PROXIMITY STRIP FROM MAIN ENTRANCE TO SEAT 3A INOPERATIVE. REMOVED AND REPLACED EMERGERCY LIGHT IAW AMM 33-57-12. OPS CHECKED GOOD.SDR DALA2018082315214Sign · brokenEMERGENCY LIGHT AND LENS BROKEN AT THE R4 DOOR BOTTOM. R & R TH EMERGENCY EXIT SIGNSDR SWAA2018082324525Lens · missingLT EMERGENCY LIGHT LENS MISSING ON OVERHEAD BIN AT ROW 9. INSTALLED LENS IAW MM.SDR SWAA2018082124500Cover · missingR1 DOOR LOWER EMERGENCY EXIT SIGN MISSING DIRECTIONAL ARROW. R&R SIGN PER AMM.SDR DALA2018082105184Light · inoperativeFOUND AFT RT LAV RED EMERGENCY LIGHT INOPERATIVE. INSTALLED A NEW LIGHT ASSY, OPS CHECKED NORMAL. OK FOR SERVICE.SDR DALA2018082105177Lens · crushedDURING A SERVICE CHECK, FOUND THE RED EMERGENCY LIGHT LENS SMASHED. INSTALLED A NEW RED EMERGENCY LIGHT ASSY IAW AMM 33-51.SDR DALA2018082105163Battery Pack · inoperativeEMERGENCY CEILING LIGHTS AT 11A,13A/B,14A,22A,24 A/D, & 25A INOPERATIVE. REMOVED & REPLACED THE BATTERY PACKS ROW 12 & 24 IAW AMM 33-55. OPS CHECKED GOOD.SDR DALA2018082105162Fuse · failedDURING A SERVICE CHECK, FOUND SEAT EMERGENCY LIGHTS, ROWS 30 TO AFT INOPERATIVE. TROUBLESHOT IAW WDM 33-51-14. FOUND TWO BAD FUSES ON CHARGER B5-212, AND LOOSE CONNECTOR AT PAX SEAT 33E. REPLACED FUSES IAW CMM 25-60-03, AND RECONNECTED THE PLUG, IAW AMM 3SDR AALA201808219002Connector · unsecureL1 DOOR EMERGENCY LIGHTS WERE INOPERATIVE DURING A TEST, EXTERIOR, 1D CEILING, 4D CEILING, 4H CEILING. SECURED THE BATTERY PACK CONNECTOR, LIGHTS OK IAW AMM 33-51-00.SDR ASAA201808205842Sign · detachedEXIT SIGN NEAR L1 DOOR DETACHED. ACFT GROUNDED. INSTALLED A SERVICEABLE SIGN, OPS CHECKED GOOD, OK FOR SERVICE.SDR HALA208082000387Sign · detachedEMERGENCY EXIT SIGN OVER THE L1 DOOR DETACHED. SECURED THE EXIT SIGN. OK FOR SERVICE.SDR SIMA2018082019003Inverter · malfunctionedEMERGENCY EXIT SIGN AT SEAT 3B INOPERATIVE. TROUBLESHOT THE EMERGENCY EXIT SIGN IAW WIRING MANUAL 33-50-50-005. FOUND THE NR 3 INVERTER TO BE AT FAULT. REMOVED AND REPLACED THE INVERTER IAW AMM 33-50-11-000-801-A, AND 33-50-11-400-801-A, OPS CHECKED GOODSDR SIMA2018082019004Light · inoperativeCEILING LIGHTS AT SEAT 1A INOPERATIVE. REMOVED AND REPLACED THE LIGHTS IAW AMM 33-21-06. OPS CHECKED GOOD.SDR HNAA2018082000203Sign · inoperativeEMERGENCY EXIT SIGN BY THE MAIN DOOR WAS INOPERATIVE. R & R THE EMERGENCY EXIT SIGN, OPS CHECKED GOOD. COVER SECURED.SDR DALA2018082005153Light · inoperativeDURING INSPECTION, FOUND THE R2 DOOR LOWER EMERGENCY LIGHT WAS INOPERATIVE. REPLACED THE EMERGENCY LIGHT ASSY IAW MM 33-51, OPS CHECKED GOOD.SDR IPXA2018082093987Sign · looseL1 DOOR EXIT SIGN WAS LOOSE. SECURED THE SIGN IAW AMM 28-11-00.SDR N6WA201808201901Connector · unsecureOVERWING EMERGENCY LIGHTS STAY ON. TROUBLESHOT THE EMERGENCY LIGHTS, AND FOUND THE CONNECTOR OVER THE EMERGGENCY EXIT WAS LOOSE. TIGHTENED THE CONNECTOR IAW AMM 33-51-17, OPS CHECKED GOOD.SDR AALA2018082319010Battery Pack · no testCEILING EMERGENCY LIGHTS ABOVE THE R2 DOOR FAILED A TIME LOAD AND R2 EMERGENCY EXIT SIGN FOWARD OF DOOR FAILED TIME LOAD. MAINTENANCE REPLACED THE M33097 BATTERY PACK IAW AMM 33-51-06, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR DALA2018082305220Fuse · failedONE CEILING EMERGENCY LIGHT WAS INOPERATIVE AT ROW 16. REPLACED THE FUSE ON THE POWER SUPPLY M731 AND INSTALLED CORRECT BULBS IN THE EMERGENCY LIGHTS L9073HT AND L32 IAW WDM 33-51.SDR SWAA2018082024448Lens · unsecureMID CABIN OVERHEAD EMERGENCY EXIT SIGN LENS FELL OFF. REINSTALLED LENS PER AMM.SDR AALA2018082209044Power Supply · no testFORWARD GALLEY RIGHT EMERGENCY LIGHT POWER SUPPLY FAILED A FUNCTIONAL CHECK. REPLACED THE POWER SUPPLY IAW AMM 33-51-06. OPS CHECKED GOOD.
Back to JASC 3350