N869AA, cancelled Aug 21, 2013
Service difficulty reports · 62
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 = 'N869AA' AND deregistration_id = 'N869AA-2013-08-21' 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 = 'N869AA' AND deregistration_id = 'N869AA-2013-08-21' 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 AALA971710Strap · corrodedTUL - CORROSION ON CIRCUMFERENTIAL STRAP AT FS 480 AFT SIDE FROM STATION 28L. REPAIRED CIRCUMFERENTIAL STRAP PER ESO 11697 DATED 8/14/97. (M)SDR AALA971709Skin · corrodedTUL - FOUND STATION 480-484 INBD STRINGER 27L CORROSION BETWEEN STRINGER AND INTERCOSTAL ON CIRCUMFERENTIAL STRAP ON BILGE SKIN. REPAIRED SKIN PER SRM 53-30-3. (M)SDR AALA971708Skin · corrodedTUL - FOUND STATION 480-484 CORRODED BETWEEN STRINGER 28L AND INTERCOSTAL, ON BILGE SKIN AND ON CIRCUMFERENTIAL STRAP. CUT OUT CORRODED SKIN AND INSTALLED REPAIR PER SRM 53-30-3. (M)SDR AALA971707Skin · corrodedTUL - SKIN CORRODED BETWEEN STA 480 AND STA 500 BETWEEN STR 27R AND STR 28R. REPAIRED SKIN PER SRM 53-30-3. TST: 55,973 HOURS. CYCLES: 34,656. (X)SDR AALA971706Stringer · corrodedTUL - CORROSION ON STR 29L, STA 950. TREATED AND PRIMED BLENDED AREA, INSTALLED REPAIR STRAP PER ESO 11697. TST: 55,973 HOURS. CYCLES: 34,656. (X)SDR AALA971071Connector · looseMIA - DURING OVERNIGHT CHECK, EMERGENCY FLOOR LIGHTS IN FORWARD PART OF MAIN CABIN INOPERATIVE. RESECURED LOOSE EMERGENCY FLOOR LIGHT STRIP CONNECTOR AT FRONT OF MAIN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA970494Pump · failedDFW - FLT 440 - AFTER TAKEOFF DFW, DURING INITIAL CLIMB-OUT, LOST HYDRAULIC SYSTEM B. ACCOMPLISHED ABNORMAL PROCEDURES FOR LOSS OF SYSTEM B-HYDRAULICS AND DUMPED FUEL. AIRCRAFT RETURNED TO DFW AND LANDED WITHOUT INCIDENT. REPLACED HYDRAULIC SYSTEM B NR 1 PUSDR AALA961737Light · defectiveJFK - DURING OVERNIGHT CHECK, EMERGENCY EXIT SIGN OVER AFT GALLEY DOOR INOPERATIVE. REPLACED EMERGENCY EXIT LIGHT ASSEMBLY OVER AFT GALLEY DOOR. SYSETM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA952091Actuator · defectiveTUL - FLT 1923 - AFTER TAKEOFF TUL DURING GEAR RETRACTION, THE GEAR DOOR LIGHT STAYED ON AS WELL AS THE RED NOSE GEAR LIGHT. RETURNED TO TUL AND LANDED WITHOUT INCIDENT. REPLACED NOSE GEAR RETRACT ACTUATOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (X)SDR AALA952083Skin · corrodedTUL - FOUND CORROSION ON LOWER SKIN OF CENTER WING SECTION ABOVE LEFT PRIMARY HEAT EXCHANGER FS 836 AND LBL 31. SMOOTH BLEND CORROSION, EDDY CURRENT THICKNESS CHECK, FLAP/SHOT PEN, ALODINE, LPS-3/AV8 PER ESO 11697 DATED 12/5/95. (M)SDR AALA952082Skin · corrodedTUL - FOUND 1 INCH CRACK IN LEFT SIDE OF VERTICAL STABILIZER SKIN EXTENDING FROM FASTENER HOLE, FS 1212. STOP DRILLED CRACK AND INSTALLED DOUBLER PER ESO11697 DATED 6-23-95. (M)SDR AALA952081Floor Beam · corrodedTULE - FOUND CORROSION ON UPPER FLANGE OF FLOOR BEAM STATION 380 RIGHT SIDE, APPROX 12 INCHES INBOARD OF INBOARD SEAT TRACK OUTBOARD TO THE DOOR CUTOUT. REPAIRED FLOOR BEAM PER SRM 53-10-8 AT STATION 380 RIGHT SIDE. (M)
Back to N869AA, cancelled Aug 21, 2013