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 SIMA20170727002Light · inoperativeLT EXTERNAL WING EMERG LIGHT FOUND BURNT ON INSPECTION. REMOVED AND REPLACED BULB ON LT WING EMERGENCY LIGHT REF AMM 33-50-10. OPS CHECK GOOD.SDR REXA2017072700819Battery Pack · inoperativeOUTSIDE EMERGENCY LIGHTS BY PAX DOOR AND SERVICE DOOR FOUND INOPERATIVE. REMOVED AND REPLACED BATTERY PACK AT POSITION PS1LF IAW CARD 33-900-701, OPS CHECKED GOOD.SDR REXA2017072700818Lamp · inoperativePASSENGER CABIN HAS TWO EMERGENCY LIGHTS INOPERATIVE. REPLACED EMERGENCY CEILING LIGHT LAMPS WITH SERVICEABLE LAMPS IAW AMM 33-51-16, OPS CHECKED GOOD.SDR REXA2017072700815Battery Pack · inoperativeEMERGENCY LIGHT ON FWD LEFT FUSELAGE BY THE PAX DOOR FOUND INOPERATIVE. TROUBLESHOT AND FOUND EMERGENCY BATTERY PACK AT POSITION PS35 TO NOT BE SUPPLYING POWER TO EMERGENCY LIGHTS. REMOVED & REPLACED THE BATTERY PACK IAW AMM 33-51-17. OPS CHECKED GOOD.SDR DALA2017072805729Fuse · inoperativeEMERGENCY LIGHTS IN AFT SECTION OF CABIN ARE INOPERATIVE. REPLACED THE FUSES IN THE AFT BATTERY PACK. CHECKED GOOD IAW AMM 33-53.SDR MASA2017072712495Bulb · inoperativeROW 13A EXIT SIGN ONE BULB INOPERATIVE.SDR SWAA2017072715309Sign · looseOVERWING EMERGENCY EXIT SIGN ON CEILING LOOSE. R & R THE SIGN IAW AMM.SDR JJBA20170727026Power Supply · abnormalBOTH OVER WING EMERGENCY EXIT LIGHTS ARE INOPERATIVE. R & R THE POWER SUPPLY. OPS CHECKED GOOD.SDR SWAA2017080715519Lens · crackedRT EMERGENCY EXIT LIGHT LENS COVER CRACKED. R&R COVER PER AMM.SDR SWAA2017080115464Battery · dischargedFORWARD LT EMERGENCY LIGHTS FAULTY. R&R BATTERY PER MM.SDR SWAA2017080115463Battery Pack · dischargedAFT EMERGENCY LIGHTS FAULTY. R&R BATTERY PACK PER AMM.SDR SWAA2017080115449Sign · missingR1 DOOR EXIT SIGN MISSING RED ARROW. R&R SIGN ASSEMBLY PER AMM.SDR SWAA2017080115448Sign · inoperativeLT OVERWING DOOR EMERGENCY SIGN OVERHEAD SIDEWALL LIGHT INOP AT ROW 11. R&R SIGN ASSEMBLY PER SIP.SDR SWAA2017080115447Lens · fadedLT OVERWING EMERGENCY DOOR LIGHT LENS FADED. R&R LENS PER SIP.SDR SWAA2017080115410Battery Pack · failedEMERGENCY EXIT LIGHT BATTERY PACK M1673 FAILED CAPACITY CHECK. R&R BATTERY PACK PER MM.SDR SWAA2017080115407Light · inoperativeRT EXTERIOR OVERWING EMERGENCY LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2017080115406Battery · failedFORWARD RT BATTERY FAILED TIME TEST. R&R BATTERY PER AMM.SDR SWAA2017080115405Battery · failedAFT LT BATTERY FAILED TIME TEST. R&R BATTERY PER AMM.SDR SWAA2017080115404Battery · failedAFT RT BATTERY FAILED TIME TEST. R&R BATTERY PER AMM.SDR SWAA2017080115382Light · inoperativeLT EXTERNAL EMERGENCY LIGHT AFT OF WING INOP. RELAMPED PER MM.SDR SWAA2017080115372Light · brokenRT OVERWING EMERGENCY EXIT LIGHT BROKEN. R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2017080115348Battery Pack · failedEMERGENCY EXIT LIGHT BATTERY PACK M1672 FAILED CAPACITY CHECK. R&R BATTERY PACK PER MM.SDR SWAA2017080115345Charger · faultyAFT EMERGENCY LIGHTS FAULTY. R&R CHARGER PER AMM.SDR SWAA2017080115344Powerpack · faultyFORWARD RT EMERGENCY LIGHTS FAULTY. R&R POWER PACK PER MM.SDR SWAA2017080115343Lens · brokenLT SIDEWALL EXIT LIGHT LENS BROKEN. R&R LENS PER MM.SDR SWAA2017080115341Lens · looseL1 DOOR EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR I5EA2017080200305Battery Pack · no testEMERGENCY LIGHTS AT ROW 7 AND 10 WOULD NOT TEST. REMOVED AND REPLACED THE BATTERIES.SDR DALA2017072705813Lens · missingCEILING EMERGENCY LIGHT LENS ASSEMBLY MISSING. REPLACED IAW MM. OPERATION CHECKS GOOD.SDR AALA201707319016Connector · not seatedROW 31 AND 32 EMERGENCY LIGHT DOESNT WORK. RESET EMERGENCY LIGHTS CONNECTOR IAW AMM 20-00-00, AND AMM 33-51-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201707319012Lens · missingL2 DOOR SLIDE LENS MISSING. REPLACED SLIDE LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201707319010Lens · missingL1 DOOR EMERGENCY EXIT LIGHT MISSING THE LENS. REPLACED THE LENS IAW AMM 33-50-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201707319009Light · damagedSEAT MOUNTED EMERGENCY LIGHT DAMAGED. REMOVED AT ROW 9D. REPLACED THE EMERGENCY LIGHT IAW CMM 25-22-50. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201707319008Lens · missingLENS MISSING FROM SEAT MOUNTED EMERGENCY LIGHT AT 9D. REPLACED THE LENS IAW CMM 25-22-50. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK. AIRCRAFT WAS NOT GROUNDED.SDR CALA2017072802386Lamp · inoperativeRIGHT FWD OVERWING EXIT LIGHT FWD LAMP INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-51-15. OPS CHECKED GOOD.SDR AALA201707289022Sign · brokenAFT GALLEY EXIT LIGHT COVER IS BROKEN AT THE LT SIDE OF L2 DOOR. REPLACED THE LOWER EMERGENCY EXIT SIGN ASSY ON AFT GALLEY LT SIDE IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA201707289021Light · damagedEMERGENCY LIGHT ASSY IN SERVICE DOOR AFT DAMAGED. THE EMERGENCY LIGHT WAS REPLACED IAW AMM 25-63-00, GOOD FOR SERVICE.SDR AALA201707279030Cap · missingEXIT SIGN LIGHT CAP AT R4 DOOR MISSING. REPLACED MISSING EXIT SIGN CAP IAW 33-51-01.SDR AALA201707279029Light · defectiveEXIT LIGHT COVER MISSING LOCATION NEXT TO RIGHT GALLEY DOOR FWD GALLEY. R & R THE R1 DOOR EXIT LIGHT ASSEMBLY & LENS IAW AMM 33-51-01 OPS CHECKED GOOD.SDR IPXA2017072719816Lamp · inoperativeCOCKPIT LEFT OVERHEAD EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS AND OPS CHECKED NORMAL IAW MM 33-51-00-715-227.SDR AALA201707289002Battery Pack · no testEMERGENCY LIGHTS AT SEATS 10 TO 17 ARE INOPERATIVE. REMOVED AND REPLACED THE CHARGER CONTROL MODULE AND BATTERY PACK IAW AMM 33-51-11. OPERATIONAL CHECKED GOOD.SDR AALA20170727002Charger · no testEMERGENCY LIGHTS AT SEATS 10 TO 17 ARE INOPERATIVE. REMOVED AND REPLACED THE CHARGER CONTROL MODULE AND BATTERY PACK IAW AMM 33-51-11. OPS CHECKED GOOD.SDR REXA2017072600814Light · missingFOUND THE RIGHT GALLEY EMERGANCY LIGHT MISSING. REPLACED THE LIGHT IAW AMM 33-51-01.SDR SWAA2017072715337Cover · inoperativeFORWARD GALLEY EMERGENCY EXIT LIGHT COVER INOP. REPAIRED THE COVER PER EA.SDR QXEA2017072600495Battery Pack · inoperativeLT & RT REAR EMERGENCY LIGHTS & BOTH EXIT SIGNS ON AFT PAX DOOR & RT SERVICE DOOR INOPERATIVE. REMOVED & REPLACED THE NR 4 BATTERY PACKS IAW AMM 33-51-0-000/400-801, ALL EXIT AND EGRESS SIGNS AND LIGHTS POWER ON. OPERATIONAL TESTED GOOD.SDR QXEA2017072600494Light · inoperativeCEILING EMERGENCY LIGHTS AT X083.90 & X211.67 INOP. RELAMPED CEILING EMERGENCY LIGHTS OPS CHECK GOOD IAW 33-51-00-710-803.SDR MASA2017072612494Light · inoperativeROW 21 CEILING EMERGENCY FLOOD LIGHT INOPERATIVE. OPENSDR MASA2017072612493Bulb · inoperativeRIGHT LOWER EMERGENCY EXIT SIGN HAD TWO BULBS INOPERATIVE.SDR VNAA2017072699908Battery Pack · inoperativeEMERGENCY CEILING FLOODLIGHTS NR 1, 5 AND 6 AND RT PROXIMITY FLOOR EXIT LIGHT AT RT OVERWING EXIT DO NOT WORK FOUND BATTERY PACK TO BE UNSERVICEABLE. REMOVED AND REPLACED THE BATTERY PACK IAW AMM TASK 33-51-17-000-801 (A01), AND 33-51-17-400-801 (A01).SDR SIMA20170725007Light · damagedRIGHT EMERGENCY LIGHT STRIP NR 8 IS DAMAGED. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-01.SDR YENA201707250612Battery · dischargedDURING HEAVY MAINTENANCE, EMERGENCY LIGHT CHECK FROM CIDS FAILS TEST, ATA-51-38, EPSU INT LOAD EMER L, MSG. REMOVED AND REPLACED BATTERY IAW AMM 33-51-38-420. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-64-12. OPS CHECKS GOOD.
Back to JASC 3350