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 SWAA2020020641180Bulb · inoperativeR/H EMERGENCY LIGHT BULB INOPERATIVE AT SEAT 21. / R&R BULB PER AMM.SDR SWAA2020020641179Bulb · inoperativeR/H EMERGENCY LIGHT BULB INOPERATIVE AT SEAT 10. / R&R BULB PER AMM.SDR SWAA2020020641178Bulb · inoperativeR/H EMERGENCY LIGHT BULB INOPERATIVE AT SEAT 9. / R&R BULB PER AMM.SDR SWAA2020020641177Bulb · inoperativeR/H EMERGENCY LIGHT BULB INOPERATIVE AT SEAT 7. / R&R BULB PER AMM.SDR SWAA2020020641176Bulb · inoperativeR/H EMERGENCY LIGHT BULB INOPERATIVE AT SEAT 5. / R&R BULB PER AMM.SDR SWAA2020020641175Bulb · inoperativeR/H EMERGENCY LIGHT BULB INOPERATIVE AT SEAT 4. / R&R BULB PER AMM.SDR SWAA2020020641174Bulb · inoperativeR/H EMERGENCY LIGHT BULB INOPERATIVE AT SEAT 3. / R&R BULB PER AMM.SDR SWAA2020020641173Bulb · inoperativeL/H EMERGENCY LIGHT BULB INOP AT SEAT 11. / R&R BULB PER AMM.SDR SWAA2020020641172Bulb · inoperativeL/H EMERGENCY LIGHT BULB INOP AT SEAT 9. / R&R BULB PER AMM.SDR SWAA2020020641171Bulb · inoperativeL/H EMERGENCY LIGHT BULB INOP AT SEAT 8. / R&R BULB PER AMM.SDR SWAA2020020641170Bulb · inoperativeL/H EMERGENCY LIGHT BULB INOP AT SEAT 5. / R&R BULB PER AMM.SDR SWAA2020020641169Bulb · inoperativeL/H EMERGENCY LIGHT BULB INOP AT SEAT 3. / R&R BULB PER AMM.SDR SWAA2020020641168Bulb · inoperativeL/H EMERGENCY LIGHT BULB INOP AT SEAT 20. / R&R BULB PER AMM.SDR SWAA2020020641166Sign · brokenFORWARD ENTRY DOOR EMERGENCY EXIT SIGN BROKEN. / RESECURED SIGN PER SIP.SDR SWAA2020020641145Bulb · inoperativeR/H EMERGENCY LIGHT BULB INOPERATIVE AT SEAT 23. / R&R BULB PER AMM.SDR SWAA2020020641144Bulb · inoperativeL/H EMERGENCY LIGHT BULB INOP AT SEAT 2. / R&R BULB PER AMM.SDR SWAA2020020641143Cover · looseL/H EMERGENCY EXIT ROW EMERGENCY ROPE COVER LOOSE AT ROW 11. / SECURED COVER PER AMM.SDR SWAA2020020641136Light · inoperativeAFT ENTRY EXTERIOR EMERGENCY LIGHT INOPERATIVE. / R&R LIGHT PER AMM.SDR SIMA202002065007Inverter · inoperativeUPPER EXIT MARKER ON RH CABIN EMERGENCY DOOR SHROUD FAILS TO ILLUMINATE.-C/A-T/S IAW WM 33-50-50. REMOVED AND REPLACED #5 INVERTER IAW AMM 33-50-11. OPC GOOD.SDR SIMA202002065006Light · wornFWD PHOTOLUMINESCENT PATHWAY LIGHT WORN-C/A-REMOVED AND REPLACED PHOTOLUMINESCENT STRIP IN FRONT OF FWD WARDROBE ASSY IAW AMM 33-50-21. OPC GOOD. NO FURTHER DEFECT NOTED.SDR DALA2020020600939Power Supply · inoperativeEMERGENCY LIGHTS INOP AT ROWS 28, 29, 33, 34, 35, 38 AND 39A, REPLACED EPSU (13WL) AFT LSDR 2DYA20200206001Battery Pack · failedDURING 28-DAY CHECK THE L/H AFT EMERGENCY LIGHT WAS FOUND INOP. REMOVED AND REPLACED THE L/H AFT BATTERY PACK IAW B767 AMM 33-51-07. PERFORMED OPS CHECK IAW B767 AMM 33-51-07, CHECK NORMAL.SDR DALA2020020500893Switch · intermittentCABIN EMERGENCY LIGHTS ILLUMINATED WITH SWITCH IN ARM POSITION. FOUND FLIGHT DECK EMERGENCY LIGHT SWITCH INTERMITTENT, REPLACED SWITCH. LP6530780SDR DALA2020020500891Light · malfunctionedFIRST CLASS EMERG LIGHTING FLASHING ON AND OFF / INTERIOR. PERF EMR LIGHTS TEST, ALL LIGHT TEST NML AT THIS TIME. NO FLASHING LIGHTS NOTED. (LP1476076)SDR DALA2020020500890Battery Pack · inoperativeEMERGENCY LIGHTS ROWS 10,11, AND 12 INOP. CHANGED BATTERIES IN PACK. CKS GOOD PER MD88 AMM 33-53. (LP6483407)SDR SIMA2020031204008Battery · dischargedEMERGENCY LIGHT ON MAIN ENTRY WAY INOP-C/A-COMPLETE:REMOVED AND REPLACED BATTERY SUPPLY #1 IAW EMB 145 AMM 33-50-04. OPC GOOD.SDR SIMA2020031204012Holder · cracked4EA PROX LIGHT HOLDER AND 4EA RH SIDEWALLS ARE CRACKED-C/A-COMPLETE:REMOVED AND REPLACED 4EA PROX LIGHT HOLDER AND 4EA RH SIDEWALLS IAW EMB 145 AMM 33-50-12 SEE NRTC BOW340146 FOR FINAL INSTALLSDR SWAA2020022741763Light · brokenBROKEN LAVATORY A EMERGENCY LIGHT ASSEMBLY AT FORWARD GALLEY AREA. / R&R LIGHT ASSEMBLY IAW AMM.SDR R61A2020022530270Sign · inoperativeR2 SERVICE DOOR LOWER EMERGENCY EXIT SIGN INOP. REPLACED IAW AMM 38-50-15. AIRCRAFT WILL REMAIN OUT OF SERVICE UNTIL HEAVY CHECK COMPLETION.SDR AALA2020020759011Battery · faultyAIRCRAFT WAS NOT GROUNDED: DOOR 2R FLASHLIGHT INOPERATIVE. MAINTENANCE REPLACED FLASHLIGHT BATTERY PER STANDARD PRACTICES.SDR AALA2020020759009Power Supply · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT POWER SUPPLY UNIT FAILED AT RIGHT EMERGENCY EXIT. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT PER AMM 33-51-38.SDR AALA2020020759019Bulb · inoperativeAIRCRAFT IN BASE MAINTENANCE: DURING FUNCTIONAL CHECK OF EMERGENCY LIGHTS, FOUND DOOR R2 EXTERIOR LIGHT INOPERATIVE. REPLACED BULB AT R2 AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-04-960-801.SDR AALA2020020759004Sign · missingAIRCRAFT WAS NOT GROUNDED: OVERWING EXIT SIGN COVER MISSING AT 16A. MAINTENANCE REPLACED EXIT SIGN PER AMM 33-51-01.SDR SWAA2020020641184Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1668. / R&R BATTERY PER MM.SDR SWAA2020020641182Battery Pack · no testCABIN EMERGENCY BATTERY PACK FAILED CAPACITY TEST AT LOCATION M1674. / R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2020020641181Battery Pack · no testCABIN EMERGENCY BATTERY PACK FAILED CAPACITY TEST AT LOCATION M1675. / R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2020020641135Light · inoperativeL/H SIDE ROW #1 PHOTO ILLUMINE SCENT STRIP WAS NOT WORKING. / R&R STRIP PER SIP.SDR SWAA2020020641111Battery Pack · no testCABIN EMERGENCY BATTERY PACK FAILED CAPACITY TEST AT LOCATION M1668. / R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2020020641110Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. / R&R BATTERY PER MM.SDR SWAA2020020641103Light · brokenAFT GALLEY EXIT SIGN OVER R2 DOOR BROKEN. / R&R LIGHT ASSEMBLY PER MM.SDR SWAA2020020641100Battery Pack · inoperativeR/H AFT EXTERIOR SLIDE EMERGENCY LIGHT INOPERATIVE. / R&R BATTERY PACK M1672 PER AMM.SDR SWAA2020020651069Battery Pack · inoperativeEMERGENCY EXIT SIGNS LIGHTS AROUND FORWARD SERVICE DOOR INOPERATIVE. / R&R EMERGENCY LIGHTS BATTERY PACK M281 PER AMM.SDR DALA2020020640948Light · inoperative(LOG 6938953) DURING INSPECTION FOUND ROW 13 ISLE EMERGENCY LIGHT INOPERATIVE. R/R ISLE EMERGENCY LIGHT FIXTURE AT ROW 13 IAW B737 AMM 33-51.SDR DALA2020020650936Switch · intermittentCREW REPORTS INTERMITTENT EMERGENCY LIGHT OPERATION. FOUND EMERGENCY LIGHT SWITCH IN COCKPIT OVHD PANEL INTERMITTENT OPERATION. REPLACED SAME PER A319 SP-AWM. OPS CK GOOD. OK FOR SERVICE.SDR SIMA202002054003Lamp · inoperativeCALLEY CEILING EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED GALLEY CEILING EMERGENCY LIGHT LAMP IAW EMB 33-50-09-000-801-A AND 33-50-09-400-801-A. OPC GOOD. END.SDR AALA202002059025Battery Pack · inoperativeAIRCRAFT IN BASE SPECIAL VISIT: POSITION 4 FLASHLIGHT INOPERATIVE. REPLACED BATTERY PACK IAW AMM 25-64-00-900-806.SDR WX0A0202002057465Light · inoperativeL1 DOOR EMERGENCY LIGHT INOP / REPLACED EMERGENCY LIGHT ASSY"SDR SWAA2020020641137Light · inoperativeFIRST FORWARD SECTION OF THE PHOTOLUMENESCENT FLOOR LIGHTING ON FIRST OFFICERS SIDE WOULD NOT ILLUMINATE. / R&R PHOTO ILLUMINESCENT LIGHT STRIP IAW AMM.SDR SWAA2020021214278Battery Pack · inoperativeALL EMERGENCY EXIT LIGHTS ASSOCIATED WITH BATTERY PACK M1670 INOP. / R&R BATTERY PACK PER AMM.SDR REXA2020021030187Battery Pack · inoperativeDURING MORNING WAKE UP FOUND EMERGENCY EXIT SIGN IN MID CABIN FACING FORWARD INOP
R&R EMRGENCY LIGH BATTERY PACK #2 IAW AMM 33-51-04. OPS CHECK GOOD. NO FURTHER DEFECTS NOTED AT THIS TIME.
Back to JASC 3350