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 AALA201705099008Cover · detachedEXIT SIGN COVER FELL OFF NEAR SEAT 23C. REINSTALLED COVER.SDR AALA201705099005Light · brokenR1 DOOR EMERGENCY EXIT LIGHT BROKEN OFF AT LOWER FASTNER. REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-13.SDR AALA201705099004Light · brokenL1 DOOR EMERGENCY EXIT LIGHT BROKEN OFF AT LOWER FASTNER. REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-13.SDR DALA2017050903674Cover · damagedEMERGENCY EXIT COVER DIFFUSER LENS DAMAGED. R & R THE COVER. OK FOR SERVICE.SDR CALA2017050801316Battery · looseLEFT OVERWING EMERGENCY LIGHT AND EMERGENCY SEAT LIGHTS FROM ROW 22 TO ROW 27 FOUND INOPERATIVE. BATTERY LOOSE, SECURED THE BATTERY. OPS CHECKED GOOD IAW 33-51-13.SDR CALA2017050801315Sign · missingAISLE EMERGENCY EXIT SIGN ABEAM OF ROW 25 MISSING. INSTALLED THE EXIT SIGN IAW AMM 33-51-01.SDR CALA2017050801314Lamp · inoperativeEMERGENCY EXIT LIGHT OVER SEAT 14D INOPERATIVE. REPLACED THE LAMP, CHECKED GOODSDR CALA2017050801313Cover · unsecureEMERGENCY EXIT SIGN COVER NEEDS TO BE REATTACHED. SECURED THE COVER.SDR CALA2017050801312Cover · missingEMERGENCY EXIT SIGN MISSING IT`S COVER. SECURED A NEW COVER. OPS CHECKED NORMAL.SDR CALA2017050801311Bulb · inoperativeR1 DOOR SLIDE EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BULB IAW AMM 33-51-06. OPS CHECKED GOOD.SDR CALA2017050801309Lens · detachedOVERWING EMERGENCY EXIT SIGN LENS FACING FWD, FELL OFF. REINSTALLED THE LENS IAW AMM 3 3-51-01-402-012-002.SDR CALA2017050801306Battery Pack · faultedEMERGENCY LIGHTS COME ON INTERM AT L4 AND R4 DOORS. REPLACED BATTERY PACK AND TESTED OK IAW AMM TASK 33-51 -06-960-802.SDR CALA2017050801301Battery Pack · no testEMERGENCY LIGHT TEST WILL NOT PASS, RIGHT OVERWING BATTERY PACK FAILED. REMOVED AND REPLACED THE RIGHT OVERWING BATTERY PACK. EMERGENCY TEST PASSED. TESTED OK.SDR CALA2017050801300Battery Pack · no testEMERGENCY LIGHT CHECK FAILED EPSU BATTERY FWD AND AFT POSITIONS. REPLACED BATTERY 10WL, 12WL (FWD & AFT) IAW AMM33-51-38-40 0. TESTED OK ON FAP. ACP IDT INSPECTION TEST AND LIGHT OPS CHECKED GOOD.SDR CALA2017050801290Battery Pack · dischargedEMERGENCY LIGHT NOT ILLUMINATED. POWER PACK M9429 AND M33404 WERE REPLACED AND TEST CARRIED OUT NORMAL IAW AMM 33-51-06SDR CALA2017050801304Lamp · inoperativeEMERGENCY LIGHT INOPERATIVE AT STOW BIN 2FE. REPLACED THE LAMP, CHECKED OK.SDR CALA2017050801299Lens · missingEMERGENCY EXIT LIGHT COVER MISSING...OVERWING EXIT 21A FOUND AND INSTALLED LENS COVERSDR QXEA2017050800346Light · looseEMERGENCY LIGHT STRIP LOOSE. SECURED THE EMERGENCY LIGHT STRIP.SDR SWAA2017052614004Light · brokenEMERGENCY LIGHT STRIP BROKEN. R & R THE EMERGENCY LIGHT IAW MM.SDR AALA201705109031Light · damagedEXIT LIGHT DAMAGED AFT LEFT DOOR. R&R EXIT LIGHT ASSEMBLY AT AFT LEFT DOOR , OPS OK. ALL DONE PER MM 33-51-02. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201705109030Cover · missingRT F/C GALLEY EMERG EXIT SIGN MISSING PLASTIC COVER. REPLACED LIGHT ASSY AT RT DOOR IAW AMM 33-51-11.SDR DALA2017051003787Lens · damagedDURING INSPECTION, FOUND EMERGENCY EXIT SIGN LENS DAMAGED SEAT 2L. MAINTENANCE R & R THE SIGN ASSY IAW AMM 33-51-01. OPS CHECKED GOOD.SDR IPXA2017050816884Lamp · inoperativeEXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-06-962-001-003.SDR RAIA201705070001Lens · crackedPAX DOOR SWING EMERGENCY LIGHT NR 1 LENS CRACKED. R&R PAX DOOR SWING EMERGENCY LIGHT NR 1 LENS OPS CHECK GOOD.SDR AALA201705089026Light · looseAIRCRAFT WAS NOT GROUNDED. EMERGENCY STRIP LIGHTING ON FLOOR BY ROW 17 IS LOOSE. RE-INSTALLED EMERGENCY STRIP LIGHTING AND CARPET. OPERATIONAL CHECK GOOD.SDR DALA2017050903710Cover · damagedR2 DOOR EMER LIGHT COVER DAMAGED. REPLACED COVER. OK FOR SVC.SDR SWAA2017050913630Module · inoperativeLT AFT OVERWING EMERGENCY EXIT LIGHT INOP AT LOCATION M1670. R&R MODULE PER MM.SDR YENA201705070353Battery Pack · dischargedFLT 6469, JFK-LCQ. DURING HEAVY MAINTENANCE, EPSU BATTERY PACK EMERGENCY R FAULT IS DISPLAYED ON THE PTP EMERGENCY LIGHTS TEST. REMOVED AND REPLACED RT EPSU BATTERY PACK (12WL) IAW AMM 33-51-38-000-002-A AND 33-51-38-400-002-A. OPS CKC GOOD IAW 33-51-38-710-05SDR QXEA2017050800350Lens · looseEMERGENCY DOOR EMERGENCY LIGHT LENS WILL NOT STAY AFFIXED. R & R THE BRACKET AND LENS FWD OF OF THE EMERGENCY DOOR LENS IS NOW SECURE. OPS CHECK OF LIGHT GOOD.SDR AALA201705089019Cover · detachedEXIT SIGN AT THE L3 DOOR DETACHED. ATTACHED THE EXIT SIGN COVER.SDR DALA2017050803655Connector · unsecureEMERGENCY LIGHTS AT SEAT 36G ARE INOPERATIVE. SECURED OTBD CONNECTOR. SYSTEM OPS NORMAL.SDR AALA201705089017Power Supply · no testWHILE PERFORMING EPSU TEST, A FAIL FAULT MESSAGE FOR THE EPSU (11WL) ILLUMINATED. REMOVED AND REPLACED EPSU.SDR AALA201705089010Lens · brokenAFT CABIN DOOR WALL MOUNTED EMERGENCY EXIT LIGHT LENS FOUND BROKEN. REPLACED THE LENS.SDR AALA201705089009Lens · brokenSEAT MOUNTED EMERGENCY LIGHT, HAS A BROKEN LENS. REPLACED THE EMERGENCY LIGHT.SDR AALA201705089008Lens · missingR2 DOOR EXIT LIGHT COVER MISSING. REPLACED THE EMERGENCY LIGHT LENS.SDR AALA201705089007Lens · missingROW 9D RED ISLE MARKER LIGHT LENS MISSING. REPLACED THE LENS.SDR AALA201705089006Lens · damagedEMERGENCY LIGHT HOUSING DAMAGED AT ROW 12 LEFT. REPLACED THE EMERGENCY LIGHT HOUSING.SDR HNAA2017050700155Bulb · inoperativeSOME SMALL BULBS ON EMERGENCY EXIT LIGHT INOPERATIVE. R & R BROKEN BULBS.SDR MASA2017050712774Light · inoperativeROW 12F LOWER EMERG EXIT SIGN ONE BULB INOP. PLACED ON MEL.SDR MASA2017050712773Sign · inoperativeEMER EXIT SIGN ROW 8 INOP.SDR MASA2017050712772Sign · inoperative3 EMER EXIT SIGNS INOP.SDR SWAA2017052213855Light · inoperativeLEFT EMERGENCY EXIT LIGHT ASSEMBLY INOPERATIVE. R & R THE LIGHT ASSEMBLY IAW AMM.SDR DALA2017051003782Lens · crackedDURING INSPECTION, FOUND FORWARD EMERGENCY LIGHT LENS CRACKED AT ROW 3CD. MAINTENANCE REPLACED THE LENS IAW AMM 33-51. OPS CHECKED GOOD.SDR AALA201705099042Light · damagedEMERGENCY LIGHT ASSY ON DOOR SERVICE AFTER DAMAGED. EMERGENCY LIGHT ASSY ON DOOR SERVICE AFTER WAS REPLACED IAW AMM 33-51-00 GOOD FOR SERVICE. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201705089034Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT ON CEILING IN AISLE BY SEAT 7A HAS A MISSING LENS COVER. INSTALLED LENS COVER. OPERATIONAL CHECK GOOD.SDR SWAA2017050913657Light · inoperativeL2 DOOR AFT SIDE EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2017050913637Light · inoperativeLT OVERWING EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2017050913632Light · brokenRT OVERWING EXIT SIGN LIGHT LENS & BASE BROKEN. R&R LIGHT ASSEMBLY PER SIP.SDR DALA2017050803695Lens · unknownDURING INSPECTION FOUND EMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING. MAINTENANCE REINSTALLED LENS.SDR AALA201705089016Lens · brokenAIRCRAFT NOT GROUNDED. AFT CABIN RT DOOR WALL MOUNTED EMERGENCY EXIT LIGHT LENS FOUND BROKEN. REPLACED CABIN AFT RT DOOR WALL MOUNTED EMERGENCY EXIT LIGHT LENS.
Back to JASC 3350