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 DALA2016111408747Battery Pack · dischargedDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY PATHWAY LIGHTING IN THE CABIN WAS INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACKS FOR THE NOTED LIGHTED AREAS AND THE OPERATIONAL CHECK WAS GOOD.SDR DALA2016111308745Power Supply · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY PATHWAY LIGHTING AT SEATS 1B & 1C IN THE CABIN WERE INOPERATIVE. MAINTENANCE REPLACED THE POWER SUPPLY AND THE LIGHTS RETURNED TO AN OPERATIONAL CONDITION.SDR JJBA20161113016Battery Pack · inoperativeOVERHEAD EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE NR 4 EMERGENCY LIGHT BATTERY PACK. OPS CHECKED GOOD. R & R OVERHEAD EMERGENCY EXIT SIGN OPS CHECK GOOD.SDR SWAA2016112209902Lamp · inoperativeL1 DOOR EVACUATION SLIDE ESCAPE LIGHT INOPERATIVE. REPLACED THE LAMP IAW MM.SDR REXA2016111202237Wire · pulledRIGHT EXTERIOR FWD OVERWING EMERGENCY LIGHT HAS A WIRE PULLED OUT OF A CONNECTOR. REPAIRED CONNECTOR IAW ESPM 20-16-00 AND AMM 33-51-15-400-801-A08. OPERATIONAL CHECKED GOOD IAW AMM 33-51-15-710-801-A01.SDR SWAA2016111709813Lens · crackedRT WING EMERGENCY EXIT SIDEWALL LIGHT LENS CRACKED. R&R LENS IAW AMM.SDR SWAA2016111409678Sign · unsecureOVERHEAD OVERWING EXIT SIGN FELL OUT. REINSTALLED SIGN PER SIP.SDR DALA2016111508802Power Supply · inoperativeMULTIPLE TAIL EMERGENCY LIGHTS INOPERATIVE. REPLACED EMERGENCY POWER SUPPLY IN AFT OVERHEAD PER MM.SDR CALA2016111400897Battery · dischargedR4 DOOR EMERGENCY LIGHT FOUND DIM. R4 DOOR EMERGENCY LIGHT BATTERY (M33408) REPLACED PER AMM 33-50-00.SDR CALA2016111400896Battery · dischargedL3 DOOR EXIT SIGN FOUND DIM. L3 DOOR EMERGENCY BATTERY (M33405) REPLACED PER AMM 33-50-00.SDR CALA2016111400895Battery · dischargedR2 DOOR EMERGENCY LIGHT FOUND DIM. R2 DOOR EMERGENCY LIGHT BATTERY (M33097) REPLACED PER AMM 33-50-00.SDR CALA2016111400894Battery · dischargedL2 DOOR EXIT SIGN FOUND DIM. L2 DOOR EMERGENCY LIGHT BATTERY (M33095) REPLACED PER AMM 33-50-00.SDR CALA2016111400893Charger · inoperativeL2 DOOR AFTER EMERGENCY LIGHT FOUND DIM. L2 DOOR EMERGENCY LIGHT (M33096) BATTERY AND CHARGER REPLACED AS PER AMM 33-50-00.SDR CALA2016111400892Battery · dischargedL3 DOOR EMERGENCY LIGHT FOUND DIM. L3 DOOR EMERGENCY LT BATTERY (M33400) REPLACED PER AMM 33-50-00.SDR CALA2016111400891Battery · dischargedL3 DOOR AND R3 DOOR CEILING EMERGENCY LIGHT FOUND DIM. L3 DOOR EMERGENCY LIGHT BATTERY (M33406) REPLACED PER AMM 33-50-00.SDR CALA2016111400890Battery · dischargedR3 DOOR EMERGENCY LIGHT FOUND INOP. R3 DOOR EMERGENCY LT BATT (M33404) REPLACED AS PER AMM 33-50-00.SDR CALA2016111400887Battery Pack · dischargedBATTERY PACK AT STA 952 RT IS BAD AND NEEDS TO BE REPLACED. REMOVED OLD BATTERY PACK AND INSTALLED SERVICEABLE BATTERY PACK AT STA 952 RT IAW AMM 33-51-06. OP CHK GOOD.SDR CALA2016111400886Battery Pack · dischargedEMERGENCY EXIT LIGHT BATTERY PACK AT STA 675 RT SIDE IS BAD. REMOVED AND INSTALLED AIR GRILL AT STA 675 RT SIDE IAW A MM 21-23-03. REMOVED OLD AND INSTALLED SERVICEABLE BATTERY PACK AT STA 675 RT OP CHK GOOD IAW AMM 33-51-06SDR AALA20161114019Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT AT ROW 25 MISSING LENS. REPLACED LENS IAW AMM 33-51-03. OPERATIONAL CHECK GOOD.SDR AALA20161114018Power Supply · failedAIRCRAFT NOT GROUNDED. L4 DOOR EMERGENCY POWER SUPPLY FAILED TEST. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20161114010Cover · damagedAIRCRAFT NOT GROUNDED. FORWARD ENTRY EMERGENCY EXIT LIGHT COVER DAMAGED. REPLACED COVER IAW AMM 25-63-00. OPERATIONAL CHECK GOOD.SDR SIMA20161112002Inverter · inoperativeFOUND AFT GALLEY EMERGENCY LIGHT INOPERATIVE DURING PS-2 INSPECTION. REMOVED AND REPLACED THE NR 3 INVERTER IAW AMM 33-50-11. OPS CHECKED GOOD.SDR SIMA20161112001Bulb · inoperativeNR 5 OVERHEAD EMERGENCY FLOOD LIGHT NOT WORKING. REMOVED AND REPLACED THE BULB IAW AMM 33-51-09. OPS CHECKED GOOD.SDR AALA201611149004Lens · brokenL1 DOOR EXIT SIGN BROKEN. INSTALLED NEW LENS COVER.SDR DALA2016111308751Light · inoperativeBOTH VENTRAL STAIR LIGHTS INOP. RELAMPED, OPS NORMAL.SDR MASA2016111212474Light · inoperativeEMER FLOOD LIGHT LT ROW 11 INOPERATIVE. R & R THE BULB IAW 33-51-09 OPS CHECKED GOOD IAW AMM 33-51-00.SDR DALA2016120509585Battery Pack · inoperativeEMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED BATTERY PACK B5-237 AND POWER SOURCE. OPS CHECKED GOOD.SDR AALA20161116018Lens · damagedAIRCRAFT WAS NOT GROUNDED. L1 DOOR EMERGENCY EXIT IDENTIFIER LENS DAMAGED. REMOVED AND REPLACED LENS IAW AMM 33-51-02-201. SYSTEM CHECKS NORMAL.SDR YENA20161111992Power Supply · failedDURING ROUTINE MAINTENANCE, COCKPIT EMERGENCY LIGHT FAILED OPS TEST. R & R THE POWER SUPPLY UNIT. OPS CHECK PASSED IAW AMM 33-50-01.SDR SWAA2016111409675Lens · brokenR1 DOOR EMERGENCY EXIT LIGHT COVER LENS BROKEN. R&R LENS PER AMM.SDR SWAA2016111409688Battery Pack · failedBATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01673. R&R BATTERY PACK PER MT.SDR SWAA2016111409687Battery Pack · failedBATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01672. R&R BATTERY PACK PER MT.SDR SWAA2016111409686Battery Pack · failedBATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01675. R&R BATTERY PACK PER MT.SDR SWAA2016111409677Battery Pack · failedBATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01669. R&R BATTERY PACK PER MT.SDR SWAA2016111409613Battery Pack · dischargedAFT GALLEY AREA ENTRY EMERGENCY LIGHT BATTERY PACK INOP. R&R BATTERY PACK ASSEMBLY IAW AMM.SDR SWAA2016111409602Battery Pack · failedCABIN EMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01668. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2016111409596Cover · looseAFT GALLEY EMERGENCY EXIT SIGN COVER LOOSE. R&R COVER IAW AMM.SDR DALA2016111308799Light · looseEMERGENCY LIGHT AT 26B IS LOOSE. SECURED EMERGENCY LIGHTS. SYSTEM OPERATION IS NORMAL.SDR AALA20161114009Lens · missingAIRCRAFT NOT GROUNDED. R2 DOOR EMERGENCY EXIT SIGN LENS MISSING. REPLACED LENS IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20161114007Sign · detachedAIRCRAFT WAS NOT GROUNDED. L3 DOOR EXIT SIGN MISSING. SIGN LOCATED IN OVERHEAD BIN. SIGN INSTALLED IAW AMM 33-51-01.SDR AALA20161111013Sign · crackedAIRCRAFT WAS NOT GROUNDED. 1R DOOR EMERGENCY EXIT MARKER IS CRACKED. REMOVED AND REPLACED MARKER 90WL2 IAW AMM 33-51-16 AND ASM 33-51-04. OPERATIONAL CHECK NORMAL.SDR DALA2016111408775Light · inoperativeDURING A SERVICE CHECK, FOUND THE L1 DOOR MOUNTED EMERGENCY LIGHT INOPERATIVE. REPLACED THE LIGHT ASSY IAW MM 33-51.SDR AALA201611129005Lens · missingMISSING LENS COVER ON FLOOR EMERGENCY LIGHT AT SEAT 13C. REPLACED LENS COVER.SDR AALA201611129004Lens · missingEMERGENCY LIGHT LENS MISSING AT 26C. MAINTENANCE INSTALLED THE LENS IAW AMM 33-51-19.SDR AALA201611129003Wire Harness · damagedSEAT 1A EMERGENCY LIGHT INOPERATIVE. REPINNED EMERGENCY LIGHT WIRE HARNESS CONNECTOR PER ESPM 20-33-11.SDR AALA201611129001Light · inoperativeRIGHT AFT EMERGENCY LIGHT INOPERATIVE. REPLACED LIGHT ASSEMBLY IAW AMM 33-50-25.SDR DALA2016111408746Battery Pack · dischargedDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY PATHWAY LIGHTING IN THE CABIN WAS INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACKS FOR THE NOTED LIGHTED AREAS AND THE OPERATIONAL CHECK WAS GOOD.SDR N6WA2016111101Light · inoperativeMID CABIN CEILING EMERGENCY FLOOD LIGHT INOPERATIVE.SDR YENA20161111977Epsu · failedFWD EXIT LIGHTS OVER BOTH PASSENGER DOORS WERE INOPERATIVE. R & R EPSU (10WL) IAW AMM 33-51-38. PERFORMED OPS CHECKS. OPS CHECKD PASSED.SDR CALA2016111100885Light · inoperativeEMERGENCY EXIT SIGN IN FLIGHT DECK INOP. REPLACED LIGHT ASSY REF MM 33-51-01 PG 201.
Back to JASC 3350