N251AA, cancelled Sep 4, 2014
Service difficulty reports · 38
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. 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 n_number = 'N251AA' AND deregistration_id = 'N251AA-2014-09-04' 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 n_number = 'N251AA' AND deregistration_id = 'N251AA-2014-09-04' 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 AALA20100428TUL05Longeron · crackedAFT ACCESSORY LONGERON 2 LEFT CRACKED AFT OF STATION 1418. INSTALLED NEW LONGERON SECTION AND SPLICE PER AARD 53-30-00-2.SDR AALA2009052000003Gearbox · crackedMEM - INFLIGHT DFW-LGA. LEFT ENGINE HAD INFLIGHT SHUTDOWN WHILE IN CRUISE. SINGLE ENGINE TIME 25 MINUTES. EMERGENCY DECLARED, LANDED MEM WITHOUT INCIDENT. INSPECTED AND FOUND LEFT ENGINE GEARBOX ASSEMBLY CRACKED. REPLACED NUMBER ONE ENGINE ON MAY 22,2009 SDR AALA2009032000001Pump · inoperativeDFW - CAPTAIN REPORTED, COULD NOT USE FUEL IN CENTER TANK. RETURNED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED CENTER TANK AFT TRANSFER BOOST PUMP. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA200810115Stringer · crackedNR 20 LEFT STRINGER CRACKED AT STATION 995. INSTALLED DOUBLER PER AARD 53-10-00-18.SDR AALA200810114Casting · crackedGROUND SPOILER WING MOUNTED CASTING CRACKED AT INBOARD FORWARD END. REPLACED GROUND SPOILER CASTING.SDR AALA200810113Frame · wornDOUBLER ON FORWARD SIDE OF FRAME STATION 1380 HAS HOLE WORN IN IT. REPLACED DOUBLER PER AARD 53-10-00-28.SDR AALA200810112Shear Tie · crackedSHEAR TIE CRACKED AT STATION 1437 AFT SIDE. REPLACED SHEAR TIE AT STATION 1437 PER SRM 53-01.SDR AALA200800468Pump · inoperativeLGA INFLIGHT T333/02MAR - AFT CENTER FUEL BOOST PUMPS POPPED CIRCUIT BREAKERS. RETURNED TO LGA AND LANDED WITHOUT INCIDENT. REPLACED AFT CENTER FUEL TANK BOOST PUMP. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800250Battery Pack · inoperativeLGA - EMERGENCY LIGHTS AT OVERHEAD SEAT ROWS 5 AND 6 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT OVERHEAD SEAT ROWS 5 AND 6. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050778Battery Pack · inoperativeSFO - CEILING EMERGENCY LIGHTS IN FIRST CLASS INOPERATIVE. REPLACED BATTERY PACK FOR CEILING EMERGENCY LIGHTS IN FIRST CLASS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050690Indicator · malfunctionedBDL - ORD - DURING CRUISE HAD FUEL QUANTITY INDICATION FAULT. DIVERTED AND LANDED SAFELY AT GRR. INSPECTED ENGINES. NO DISCREPANCIES NOTED. TANKS CHECKED, DRAINED AND RE-FUELED. VERIFIED LOAD BY STICKING TANKS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050078Socket · inoperativeLAX - SEAT MOUNTED EMERGENCY LIGHT AT SEAT 7D FORWARD INOPERATIVE. REPLACED SOCKET FOR SEAT MOUNTED EMERGENCY LIGHT AT SEAT 7D FORWARD. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040684Shimmy Dampener · failedORD - IMMEDIATELY AFTER TOUCHDOWN AIRCRAFT BEGAN SHAKING VIOLENTLY. DURING TAXI SHAKING CONTINUED AT ALL SPEEDS ABOVE A WALK. FOUND RIGHT HAND MAIN LANDING GEAR SHIMMY DAMPENER FAILED WITH DAMAGE TO TIRES AND MAIN LANDING GEAR. REPLACED UPPER AND LOWER TORQSDR AALA20040331Wire · looseSTL - EMERGENCY EGRESS LIGHT AT OVERHEAD AFT STAIRWELL INOPERATIVE. FOUND LOOSE WIRING. SECURED WIRING CONNECTION FOR EMERGENCY EGRESS LIGHT AT OVERHEAD AFT STAIRWELL. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20031382Battery Pack · looseMIA CEILING EMERGENCY LIGHTS AT ROWS 18-21 INOPERATIVE. RESEATED BATTERY PACK IN S3-334 FOR CEILING EMERGENCY LIGHTS AT ROWS 18-21. SYSTEM GROUND CHECKED NORMAL OPERATION. CLOSEDSDR AALA20030836Bungee Cylinder · failedREPLACED NOSE GEAR BUNGEE CYLINDER. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20030831Bungee Cylinder · damagedEN ROUTE, AFTER LANDING GEAR RETRACTION THE RED NOSE GEAR LIGHT REMAINED ILLUMINATED FOR 15-20 SECONDS. AIRCRAFT LANDED WITHOUT INCIDENT. REPLACED THE BUNGEE CYLINDER. JACKED NOSE OF AIRCRAFT AND SWUNG NOSE GEAR SEVERAL TIMES. SYSTEM LEAK AND GROUND CHECKESDR AALA20030338Skin · dentedTUL - FOUND DENT IN FUSELAGE SKIN, REF ADL0008. INSTALLED DOUBLER PER SRM 53-04-00 PAGE 60G FIG 12B SHEETS 35. (M)SDR AALA20030340Skin · damagedFOUND DEEP STATIC DISCHARGE STATION 615 L21R. INSTALLED LONGERON SPLICE AND EXTERNAL PATCH TO DAMAGED AREA PER SRM 53-02-00- FIG 8. (M)SDR AALA20030339Frame · bentTUL - FOUND FRAME IN FORWARD CARGO LOWER LEG BENT, SIDE OF FRAME DEFORMED AND RADIUS FROM DENT IN FUSELAGE. REMOVED AND REPLACED FRAME IN FWD CARGO PER SRM 51-10-04. (M)SDR AALA20030341Door Frame · corrodedTUL - FOUND MID CARGO DOOR BEAM CORRODED BEYOND LIMITS. REMOVED AND REPLACED BEAM PER SRM 51-01-00. (M)SDR AALA20030337Angle · corrodedTUL - FOUND LEFT AND RIGHT VERTICAL STABILIZER L/E FAIRING TO FUSELAGE ATTACH ANGLES CRACKED BEYOND STOP DRILLS. REMOVED CRACKED ANGLES AND INSTALLED NEW ANGLES PER AARD 55-30-00-7. (M)SDR AALA20030344Skin · bulgedTUL - FOUND MINOR BULGE APPROX .25 INCH DIAMETER 2 FEET FORWARD OF GROUND ELECT PANEL, FS 82. DYE CHECKED REPAIRED BULGE WITH DOUBLER PER SRM 53-04-00 FIG 38 SHEET 20. (M)SDR AALA20030332Frame · crackedTUL - FOUND FRAME CRACKED AT STATION 1174 AND LONGERON 6L AT BIN ATTACH POINTS TWO EACH. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-30. (M)SDR AALA20030336Sill · damagedTUL - FOUND MID CARGO LOWER SILL PLATE HAS SKIN DAMAGE, FS 674. REPAIRED FUSELAGE PER ESO 80559 DATED 2/28/2003. (M)SDR AALA20030343Shear Tie · crackedTUL - FOUND STATION 1437 FRAME, AFT SHEAR TIE CRACKED AT FASTENER. REMOVED AND REPLACED SHEAR TIE AT STATION 1473 PER SRM 51-10-01. (M)SDR AALA20030333Web · crackedTUL - FOUND STATION 218 INBOARD OF FORWARD LAVATORY TRACK NR 2. SUBFLOOR WEB CRACKED AT NUTPLATE HOLE. INSTALLED DOUBLER TO SUBFLOOR WEB AT STATION 218 INBOARD OF SEAT TRACK NR 2 PER SRM 53-01-00. (M)SDR AALA20030335Skin · damagedTUL - FOUND DEEPLY BLENDED AREA AT STATION 1429 BETWEEN LONGERONS 3R AND 2R. INSTALLED DOUBLER PER SRM 53-01. (M)SDR AALA20030334Skin · damagedFOUND FOUR DEEPLY BLENDED AREAS BETWEEN STATION 918 AND 930 BETWEEN LONGERONS 3R AND 4R. INSTALLED DOUBLER USING RIVETS AND HI-LOCKS PER SRM 53-04-00 FIG 38. (M)SDR AALA20030342Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK NR 1. BLENDED AND ROUTED OUT CORROSION AND TREATED AND PRIMED INSTALLED PLUG REPAIR PER 53-05-00 AND AARD 53-20-00-10 AND POINTED. (M)SDR AALA20030331Seat Track · corrodedFOUND CORROSION NR 3 SEAT TRACK. BLENDED AND ROUTED OUT CORROSION ALODINE AND PRIMED INSTALLED PLUG REPAIR PER 53-05-00 AND AARD 53-20-00-10 51-10-3 AND PAINTED. (M)SDR AALA20021249Wire · disconnectedDFW - DURING OVERNIGHT MAINTENANCE, AFT EMERGENCY EXIT LIGHTS OVER CATWALK INOPERATIVE. RECONNECTED EMERGENCY EXIT LIGHTS WIRE. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20010949Light · defectiveDFW - DURING OVERNIGHT MAINTENANCE, SEAT MOUNTED EMERGENCY EXIT LIGHT DIM. REPLACED SEAT MOUNTED EMERGENCY EXIT LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20010883Battery · dischargedDFW - DURING OVERNIGHT MAINTENANCE, TAIL CONE EMERGENCY EXIT LIGHT DIM. REPLACED EMERGENCY EXIT LIGHT BATTERY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20002014Connector · looseDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT LIGHT INOPERATIVE. RE-SEATED EMERGENCY EXIT LIGHT CONNECTOR. SYSTME GROUND CHECKED NORMAL OPERATION. (M)SDR AALA981472O-Ring · failedLAX - FLT 1576 - AFTER TAKEOFF COCKPIT AND CABIN BEGAN FILLING WITH SMOKE. DECLARED EMERGENCY AND RETURNED TO LAX AND LANDED OVERWEIGHT WITHOUT INCIDENT. APU CHIP DETECTOR LEAKING OIL TO APU INLET. SHUT DOWN APU AND ACCOMPLISHED PACK BURN OUT. REPLACED THE SDR AALA972300Lens · missingDFW - DURING OVERNIGHT CHECK, CEILING EMERGENCY EXIT SIGN LENS COVER FOUND MISSING. REPLACED CEILING EMERGENCY EXIT SIGN LENS COVER. SYSTEM GROUND CHECKED, NORMAL OPERATION. (X)SDR AALA961449Door Mechanism · shearedEWR - DURING OVERNIGHT CHECK, PIN SHEARED IN AFT GALLEY DOOR HANDLE. REPLACED AFT GALLEY DOOR MECHANISM PIN. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
Back to N251AA, cancelled Sep 4, 2014