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 DALA2018091405599Battery Pack · dischargedO/H EMERGENCY LIGHT FROM DR2L TO SEAT 33C INOP. DEEP CYCLED BATTERY PACK PER AMM 33-51-06 AND OK. CONFIRMED ALL LIGHTS WORKS NORMAL.SDR DALA2018091405598Battery · dischargedO/H EMERGENCY LIGHTS FROM 50F TO 55F INOP. DEEP CYCLED BATTERY PACK PER AMM 33-51-06 AND OK. CONFIRMED ALL LIGHTS WORKS NORMAL.SDR AALA2018091439030Bulb · inoperativeLEFT AFT PAX DOOR, EXTERIOR EMERGENCY LIGHT WAS INOPERATIVE. MAINTENANCEINSTALLED A BULB IAW AMM 33-51-06, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2018091439027Power Supply · no testTHE POWER SUPPLY DID NOT TEST AT THE R4 DOOR. MAINTENANCE REPLACED THE POWER SUPPLY IAW AMM 33-51-06-960-803.SDR AALA2018091439026Power Supply · no testTHE POWER SUPPLY WILL NOT TEST AT THE R4 DOOR. MAINTENANCE REPLACED THE POWER SUPPLY IAW AMM 33-51-06-960-803.SDR AALA2018091439025Power Supply · no indicationTHE POWER SUPPLY DID NOT TEST AT THE R1 DOOR . MAINTENANCE REPLACED THE POWER SUPPLY IAW AMM 33-51-06-960-803.SDR AALA2018091439024Power Supply · no testPOWER SUPPLY DID NOT TEST. MAINTENANCE REPLACED THE POWER SUPPLY IAW AMM 33-51-06-960-803 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR YENA2018091310339Epsu · faultedFLT 1730, RSW-JFK. WHILE PREFORMING TASK CARD A320-33-51-00-710-003 FOUND ROW II ABC EMERGENCY BATTERY FAULTED. REPLACED EMERGENCY BATTERY AND EPSU.SDR SWAA2018091225076Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1973. R&R BATTERY PER MM.SDR SWAA2018091225075Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1974. R&R BATTERY PER MM.SDR SWAA2018091225074Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1968. R&R BATTERY PER MM.SDR SWAA2018091225070Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1969. R&R BATTERY PER MM.SDR YENA2018091310328Battery · faultedFLT 1730, RSW-JFK. WHILE PREFORMING TASK CARD A320-33-51-00-710-003 FOUND ROW II ABC EMERGENCY BATTERY FAULTED. REPLACED EMERGENCY BATTERY AND EPSU. SUPPLEMENTAL INFORMATION TO FOLLOW.SDR AALA201809129040Sign · brokenEMERGENCY EXIT SIGN ON THE COACH PARTITION WAS BROKEN. REPLACED THE SIGN ASSEMBLY. OPS CHECKED SATISFACTORY IAW 33-51-09.SDR AALA201809129023Battery Pack · inoperativeWHILE PERFORMING WORK CARD 221N, DISCOVERED THAT THE R2 DOOR BATTERY PACK M33098 WAS INOPERATIVE. REPLACED THE BATTERY PACK IAW AMM 33-51-06, CHECKED OK FOR SERVICE.SDR AALA201809129021Light · malfunctionedWHILE AT THE GATE, ALL OF THE OVERHEAD EXIT LIGHTS AND THE BLUE LIGHTS NEXT TO THE EXIT LIGHTS ARE ALL ILLUMINATED. CYCLED EMERGENCY EXIT LIGHTS, OPERATIONS CHECKED NORMAL IAW 33-5-00.SDR AALA201809129017Light · detachedSEAT 25C EMERGENCY LIGHT WAS DETACHED. SECURED THE EMERGENCY LIGHT. OPS CHECKED GOOD.SDR REXA2018091200822Light · degradedROWS 13 DC FWD ILLUMINESCENT TRACK DEGRADED. INSTALLED FILTER FILM ON EXIT ROW 13 CD ILLUMINESCENT TRACK IAW CMM 33-57-07.SDR N6WA20180912101Light · inoperativeOVERHEAD EMERGENCY FLOODLIGHT INOP. R&R OVERHEAD EMERGENCY FLOOD LIGHT LAMP IAW AMM 33-51-09.SDR MASA2018091113561Light · inoperativeROW 20 CEILING EMERGENCY FLOOD LIGHT INOPERATIVE. PLACED ON MEL.SDR HALA2018091100216Lens · detachedTHE L3 DOOR EXIT SIGN LENS DETACHED FROM THE WALL. REPLACED THE EXIT SIGN LENS.SDR DALA2018091105561Light · missingROW 11 AND 18 AISLE ILLUMINATION EMERGENCY LIGHTS BROKEN/MISSING (BELOW SEATS). REPLACED.SDR FDEA201809112442Battery Pack · dischargedLEFT HAND SIDE EMERGENCY LIGHTS ARE INOP. R&R LT BATT PACK REF MM 33-51-06-2. TEST PASS.SDR SIMA2018100510009Light · crackedLT NR 8 EMERGENCY LIGHT STRIP CRACKED-C/A-COMPLETE: REMOVED AND REPLACED LT NR 8 EMERGENCY LIGHT STRIP IAW AMM 33-50-12. SEE BOW304301 FOR OCKSDR SIMA2018100510004Charger · defectiveNR 1 EPSU BATTERY AND CHARGER DEFECTIVE.-C/A-COMPLETE: R&R NR 1 EPSU BATTERY AND CHARGER IAW AMM 33-50-04. EASI 6488. OHM CHECK GOOD. OPERATIONAL CHECK GOOD.SDR SIMA2018100510011Charger · inoperativeNR 4 EPSU BATTERY AND CHARGER DEFECTIVE.-C/A-COMPLETE: REMOVED AND REPLACED NR 4 EPSU BATTERY AND CHARGER IAW AMM 33-50-04. EASI 6488. OHM CHECK GOOD. OPERATIONAL CHECK GOOD.SDR SIMA2018100510008Housing · defectiveMAIN DOOR EMERGENCY LIGHT WORKS INTERMITTENTLY.-C/A-COMPLETE: R&R MAIN DOOR EMERGENCY LIGHT HOUSING ASSEMBLY IAW AMM 33-26-04. OPS CHECK GOOD.SDR SIMA2018100510010Fitting · crackedLT EMERGENCY LIGHT STRIP EXTRUSIONS NR 1, 3, 4, 6, 7 AND 8 ARE CRACKED-C/A-COMPLETE: REMOVED AND REPLACED LT EMERGENCY LIGHT STRIP EXTRUSIONS NR 1, 3, 4, 6, 7 AND 8 IAW AMM 33-50-12. SEE BOW304301 FOR OCKSDR UIEA2018092402050Light · damagedCABIN CC17 LT AFT EMER LT FOUND DAMAGED. CABIN CC17 LT AFT EMER LT REPLACED AS PER AMM 33-51-12.SDR UIEA2018092402051Light · damagedCABIN CC12 RT FWD EMER LT FOUND DAMAGED. CC12 RT FWD EMER LT REPLACED AS PER AMM 33-51-12.SDR UIEA2018092402052Light · dimU/D LT EMER DOOR EXIT INDICATOR SIGN FOUND DIM. U/D LT EMER DOOR EXIT INDICATOR SIGN LAMP REPLACED AS PER AMM 33-51-12.SDR UIEA2018092502057Light · damagedM/D LT NR 2 DOOR PARTITION EMER LT FOUND DAMAGED. M/D LT NR 2 DOOR PARTITION EMER LT REPLACED AS PER AMM 33-51-12.SDR UIEA2018092302039Light · missingG8 GALLEY LT PARTITION FWD EMER LT FOUND MISSING WHEN AIRCRAFT INPUT. G8 GALLEY LT PARTITION FWD EMER LT INSTALLED AS PER AMM 33-51-12.SDR UIEA2018092302040Light · missingCABIN SEAT 17ABC SEAT EMERGENCY LIGHT FOUND MISSING WHEN AIRCRAFT INPUT. CABIN SEAT 17ABC EMERGENCY LIGHT INSTALLED AS PER AMM 33-51-12.SDR UIEA2018092302041Light · damagedCABIN G8 GALLEY LT PARTITION AFT EMERGENCY LIGHT FOUND DAMAGED. G8 GALLEY LT PARTITION AFT EMERGENCY LIGHT REPLACED AS PER AMM 33-51-12.SDR UIEA2018092302042Light · dimM/D LT D4 EXIT INDICATOR SIGN FOUND DIM. M/D L4 DOOR EXIT INDICATOR SIGN LAMP REPLACED AS PER AMM 33-51-12.SDR CALA2018091701931Battery Pack · dischargedCABIN LAV 3F-RC 4EA FLOOR PROXIMITY LIGHT FOUND DIM M33404. BATTERY PACK REPLACED AND LAV 3F-RC 4EA FLOOR PROXIMITY LT TESTED NORMAL AS PER AMM 33-51-00.SDR IPXA2018091233858Battery Pack · dischargedINSPECTION TYPE:PD, CEMER EXIT LIGTHTS FAILED TO TEST DURING PDC. REPLACED BATTERY PACK PER MM 33-51-07.SDR UIEA2018091101948Battery Pack · dischargedRT UPPER DECK DOOR EMERGENCY BATTERY TEST FAILED. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-51-04.SDR AALA201809121008Power Supply · inoperativeEMERGENCY EXIT SIGN, ADJACENT TO THE L4 DOOR WAS INOPERATIVE. REPLACEDTHE POWER SUPPLY. OPS CHECKED GOOD IAW AMM 33-51-06-960-803.SDR AALA201809129036Lens · faultyEMERGENCY EXIT LIGHT LENS AT THE R1 DOOR WAS FAULTY. MAINTENANCE REPLACED THE LENS.SDR DALA2018091205569Light · inoperative29 ABC AND 2L LAV EMERGENCY LIGHTS INOP. REPLACED 29ABC SEAT AND 2L LAV EMERGENCY PATH LIGHTS.SDR DALA2018091005568Lens · unsecureEMERGENCY SEAT 1L MOUNTED LIGHTING DAMAGED. RESECURED LENS.SDR IPXA2018091233819Epsu · failedREPLACED ENG PWR SUPPLY UNIT (EPSU) BATTERY SYSTEM FAILS TEST PER AMM 33-51-14-0401 F. RELAMPED SW 25WL OP CKS NORMAL PER AMM 33-51-14-0401.SDR REXA2018091100821Light · brokenEMER FLOOR LIGHTING STRIP BROKEN ADJACENT SEAT 1A. R&R BROKEN EMER FLOOR LIGHTING STRIP AT SEAT 1A IAW AMM 33-51-01. OPS TEST NORMAL.SDR HALA2018091100215Light · detachedEMERGENCY LIGHT TRACK CAME LOOSE FROM FLOOR. SECURED THE LIGHT.SDR SWAA2018091124941Light · inoperativeL2 DOOR EXTERIOR EGRESS LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2018091124929Lens · unsecureLT EMERGENCY EXIT SIGN LENS COVER FELL OFF. R&R COVER ASSEMBLY IAW AMM.SDR SWAA2018091124927Battery Pack · dischargedRT EMERGENCY EXIT AISLE LIGHT INOP AT ROW 6. R&R BATTERY PACK PER AMM.SDR SIMA2018091110001Sign · unsecureEMERGENCY EXIT SIGN OVER SERVICE DOOR FALLING DOWN. REMOVED AND REPLACED EXIT SIGN ASSY OVER SERVICE DOOR IAW AMM 33-51-05.
Back to JASC 3350