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 AALA201704189025Cover · looseLEFT AFT ENTRY DOOR EMERGENCY LIGHT COVER LOOSE. REPLACED LIGHT ASSY AND PERFORMED LITE EMERG TEST PER AMM 33-51-00. THE AIRCRAFT WAS NOT GROUNDED.SDR SWAA2017041813164Sign · brokenL2 DOOR LOWER EXIT SIGN BROKEN. R & R THE SIGN IAW AMM.SDR AALA201704179020Light · detachedSEAT 16C EMERGENCY LIGHT HANGING OFF BOTTOM OF THE SEAT. SECURED THE EMERGENCY LIGHT.SDR AALA201704179002Battery Pack · faultedEMERGENCY POWER SUPPY BATTERY AT THE L1 DOOR FAULTED DURING EMERGENCY LIGHTING TEST. REPLACED THE BATTERY PACK.SDR QXEA2017041700269Light · unsecureSEVERAL SECTIONS OF EMERGENCY LIGHTS IN MCD ENTRY AREA ARE LOOSE AND REQUIRE SECURING. SECURED THE LIGHT STRIPS.SDR HALA2017041700157Lens · missingLENS MISSING FROM OVERHEAD AISLE EMERGENCY LIGHT ROW 16 RIGHT. INSTALLED NEW LENS.SDR HNAA2017041700123Battery · failedBOTH LT AND RT AFT EMERGENCY LIGHTS ARE INOPERATIVE. R & R THE BATTERY, FOUND THE LT AFT NEW EMERG BATTERY FAILED OPS. R & R THE BATTERY WITH ANOTHER NEW BATTERY.SDR HNAA2017041700122Battery · dischargedFWD EMERGENCY LIGHT SIGN AND EMERGENCY CEILING LIGHT INOPERATIVE. REMOVED ALL BATTERY ELECTRICAL CONNECTORS TO ISOLATE PROBLEM. NO SUCCESS. REMOVED AFT BATTERY IN THE WARDROBE. THAT FIXED THE PROBLEM. OPS CHECKED GOOD. INSTALLED THE ELECTRICAL CONNECTORSSDR YENA201704150286Battery · failedDURING EMERGENCY LIGHT TEST, FWD EPSU FAULTED. REPLACED FWD EPSU BATTERY IAW AMM 33-51-38. OPS CHECKED GOOD.SDR UIEA2017042000610Lamp · inoperativeEXTERIOR EMERGENCY LIGHT ON AFT RT SIDE BEHIND FLAP INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51-01, OPS CHECKED GOOD.SDR ASOA201704145036Sign · brokenCREW REPORTED EMERGENCY EXIT SIGN OVER THE SERVICE DOOR IS UNSECURED AT ONE END ATTACHMENT POINT. CONTRACT MX REMOVED AND REPLACED EMERGENCY EXIT SIGN OVER SERVICE DOOR WITH OPS CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR AALA20170414003Lens · brokenON THE LAV A EPL ASSY THE LENS COVER TABS ARE BROKEN. R&R EPL LIGHT ASSY AT LAV A, OPS CHECKED GOOD IAW AMM 33-51-14. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704179074Sign · brokenAFT RT GALLEY EXIT SIGN IS BROKEN. REPLACED AFT RT GALLEY EXIT SIGN ASSY AND OPS CK IS NORMAL IAW AMM 33-51-01. THE AIRCRAFT WAS NOT GROUNDED.SDR SWAA2017041813194Lamp · inoperativeRIGHT EXTERNAL EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR SWAA2017041813184Lens · brokenLEFT OVERWING EMERGENCY EXIT LIGHT LENS BROKEN. R & R THE LENS IAW AMM.SDR SWAA2017041813175Lens · looseRIGHT OVERWING EXIT SIGN LENS LOOSE. R & R THE LENS IAW MM.SDR SWAA2017041813171Sign · inoperativeL2 DOOR EMERGENCY EXIT SIGN ASSEMBLY INOPERATIVE. R & R THE SIGN ASSEMBLY IAW MM.SDR AALA201704189017Battery Pack · dischargedEMERGENCY EXIT SIGNS AT THE L1, L2, R1, R2 DOORS AND SEAT MOUNTED EMERGENCY LIGHTS ON SEATS 1E-4E AND 9D-15D ARE ALL DIM. ACCOMPLISHED BATTERY PACK CHARGE IAW AMM 33-51-07-610-801. OPERATIONAL CHECKED GOOD.SDR AALA20170415002Power Supply · failedEMERGENCY LIGHTS POWER SUPPLY FAILED 15 MIN CAPACITY TEST (MCM2908). REPLACED RT AFT EMERGENCY LIGHTS POWER SUPPLY IAW AMM 33-51-06. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA20170415001Sign · brokenAFT RT GALLEY EXIT SIGN IS BROKEN. REPLACED AFT RT GALLEY EXIT SIGN ASSY AND OPS CK IS NORMAL IAW AMM 33-51-01. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA20170414008Fuse · failedDURING PS CHECK HAS BEEN FOUND EMERGENCY LIGHTS EXIT SIGNS DOOR 3 LT INOP. IT WAS REMOVED AND REPLACED POWER SUPPLY FUSE OF THE EMERGENCY LIGHTS EXIT SIGNS AT DOOR 3LH IAW AMM 33-51-06. TEST OK. GOOD FOR SERVICE. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA20170414007Battery Pack · dischargedDURING CARD 2735 TEST EMERGENCY LIGHTS NEAR DOOR 2R DID NOT SUPPORT 15 MINUTES ON AS REQUIRED PER CARD 2735. BATTERY PACK AT DOOR 2R (M33098) WAS REPLACED IAW AMM 33-51-06. TEST OK. THE AIRCRAFT WAS NOT GROUNDED. (SEE ALSO SDR'S AALA201704179078 AND AALA201704SDR AALA20170414005Lens · brokenON THE RT SIDE OF THE G4B GALLEY. THE LENS COVER TABS ARE BROKEN OFF FROM THE EPL ASSY. R&R EPL LIGHT ASSY ON THE RT SIDE OF THE G4B GALLEY, OPS CHECKED GOOD IAW AMM 33-51-14. AIRCRAFT IN BASE MAINTENANCE.SDR AALA20170414004Lens · brokenON THE LT SIDE OF THE G4B GALLEY. THE LENS COVER TABS ARE BROKEN OFF FROM THE EPL ASSY. R&R EPL LIGHT ASSY ON THE LT SIDE OF THE G4B GALLEY, OPS CHECKED GOOD IAW AMM 33-51-14. AIRCRAFT IN BASE MAINTENANCE.SDR AALA201704179080Battery Pack · dischargedDURING CARD 2735 TEST EMERGENCY LIGHTS NEAR DOOR 3L DID NOT SUPPORT 15 MINUTES ON AS REQUIRED PER CARD 2735. BATTERY PACK AT DOOR 3L (M33400) WAS REPLACED IAW AMM 33-51-06. TEST OK. THE AIRCRAFT WAS NOT GROUNDED. (SEE ALSO SDR'S AALA20170414007 AND AALA2017041SDR AALA201704179079Fuse · blownDURING PS CHECK HAS BEEN FOUND EMERGENCY LIGHTS EXIT SIGNS DOOR 3 LT INOP. REMOVED AND REPLACED POWER SUPPLY FUSE OF THE EMERGENCY LIGHTS EXIT SIGNS AT DOOR 3 LT IAW AMM 33-51-06. TEST OK. GOOD FOR SERVICE. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704179078Battery Pack · dischargedDURING CARD 2735 TEST EMERGENCY LIGHTS NEAR DOOR 3R DID NOT SUPPORT 15 MINUTES ON AS REQUIRED PER CARD 2735. BATTERY PACK AT DOOR 3R (M33401) WAS REPLACED IAW AMM 33-51-06. TEST OK. THE AIRCRAFT WAS NOT GROUNDED. (SEE ALSO SDR'S AALA20170414007 AND AALA2017041SDR AALA20170414002Battery · dischargedAIRCRAFT WAS IN BASE MAINTENANCE. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHTS AT SEATS 20HJ AND 21HJ AND OVERWING EXIT SIGNS FAILED TEST. REMOVED AND REPLACED BATTERY ASSEMBLY AT M1209 IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170414001Battery · dischargedAIRCRAFT WAS IN BASE MAINTENANCE. LEFT EXTERIOR EMERGENCY LIGHT FAILED TEST. REMOVED AND REPLACED BATTERY ASSEMBLY AT M736 IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA201704179037Lens · missingAIRCRAFT NOT GROUNDED. SEAT 1L EMERGENCY LIGHT LENS MISSING. REPLACED EMERGENCY LIGHT LENS.SDR AALA201704179026Light · unsecureAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT AT SEAT 9D FELL OFF. RE-INSTALLED EMERGENCY EXIT LIGHT AT SEAT 9D.SDR HALA2017041700156Light · unsecureEMERGENCY LIGHT LOOSE ADJACENT TO 45HJ. EMERGENCY LIGHT SECURED.SDR SWAA2017041713152Light · crackedLEFT EMERGENCY LIGHT STRIP CRACKED AT ROW 12. R & R THE LIGHT IAW AMM.SDR SWAA2017041713151Light · crackedRIGHT EMERGENCY LIGHT STRIP CRACKED AT ROW 12. R & R THE LIGHT IAW AMM.SDR SWAA2017041713150Light · crackedLEFT EMERGENCY LIGHT STRIP CRACKED AT ROW 2. R & R THE LIGHT IAW AMM.SDR SWAA2017041713142Light · crackedRIGHT EMERGENCY LIGHT STRIP CRACKED AT ROW 1. R & R THE LIGHT IAW AMM.SDR ASAA2017041420466Battery Pack · no testWHILE ACCOMPLISHING T/C # 78233001, LT & RT AFT OVERWING EXIT EMERGENCY LIGHT (EXTERIOR). LIGHT WENT OUT BEFORE TIME LIMIT. ACFT GROUNDED. REPLACED THE POWER SUPPLY BATTERY PACKS M1670 AND M1671 IAW AMM 33-51-06-960-805, OPS CHECKED GOOD.SDR R61A201704140285Battery Pack · inoperativeFOUND R1 DOOR EXIT LIGHT INOP DURING TWO DAY CHECK. R&R EMERGENCY BATTERY NR 1 IAW AMM 33-50-01. OPS CHECKED GOOD.SDR DALA2017041703131Lens · unsecureEMERGENCY LIGHT LENS LOOSE. SECURED THE LENS.SDR DALA2017041703130Lens · looseEMERGENCY LIGHT LENS LOOSE. SECURED THE LENS.SDR SIMA20170414003Light · unknownMAIN DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. PERFORMED AN OPS CHECK, CHECKED GOOD IAW AMM TASK 33-50-00-700-801-ASDR N6WA20170414Guard · brokenEMERGENCY LIGHT SWITCH GUARD BROKEN.SDR CALA2017041400999Light · inoperativeEMERGENCY EXIT LIGHTING ON END CAP AT SEAT 33C DOES NOT ILLUMINATE. REPLACED LIGHT STRIP OP CK OK REF AMM33-51-00SDR CALA2017041401014Lens · missingEMERGENCY EXIT LIGHT FWD PARTITION LENS MISSING REPLACED LENS CAP ONLY, LIGHT OPS CHECKED NORMAL.SDR CALA2017041401013Battery Pack · dischargedEMERGENCY LIGHTS FROM ROWS 22-28 INOPERATIVE. REMOVED AND INSTALLED A SERVICEABLE EMERGENCY LIGHT BATTERY PACK FOR ROWS 22-28 REF AMM 33-51-06. OPS CHECK NORMALSDR CALA2017041401011Light · inoperativeEMERGENCY LIGHTS AT SEAT ROW 20ABC AND BETWEEN SEAT ROWS 28DEF AND 29DEF IN BULLNOSE INOP. RELAMPED EMERGENCY LIGHTS AT SEAT ROW 20ABC AND BETWEEN SEAT ROWS 28DEF REF 33-42-02-960-801. OPS CHECK NORMAL.SDR CALA2017041401008Lens · unsecure2B EMERG LENS COVER CAME OFF. SECURED LIGHT LENS.SDR CALA2017041401007Light · inoperativeL1 EXTERIOR EMERGENCY LIGHT INOP. RELAMPED L-1 EXTERIOR DOOR EMERGENCY LIGHT PER AMM 33-51-06. OPS CHECK GOOD.SDR CALA2017041401004Light · intermittentDOOR 1R SLIDE LIGHT INTERMITTENT. R&R FAULTY LIGHT ASSY, REF AMM 33-51-06 OPS CK GOOD.SDR CALA2017041401003Light · inoperativeL3 EMERGENCY EXTERIOR LIGHT INOP. RELAMPED L3 EXTERIOR EMERGENCY LIGHT. OPS CHECK GOOD. REF AMM 33-51-00-715-039.
Back to JASC 3350