N915CK, cancelled Jan 25, 2022
Service difficulty reports · 153
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 = 'N915CK' AND deregistration_id = 'N915CK-2022-01-25' 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 = 'N915CK' AND deregistration_id = 'N915CK-2022-01-25' 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 K11A2019072301Battery Pack · dischargedEMERGENCY EXIT LIGHTS INOP.SDR K11A2019063091502Unknown · malfunctionedAFTER TAKEOFF FLIGHT CONTROLS REQUIRED ABNORMAL AND EXCESSIVE AMOUNT OF RIGHT AILERON INPUT "UP" POSITION TO CONTROL AIRCRAFT.SDR K11A2019063091501Unknown · malfunctionedIMMEDIATELY FOLLOWING TAKEOFF, I NOTICED THAT PILOT WAS USING GREATER THAN NORMAL AILERON INPUT TO CONTROL AIRCRAFT. HE APPEARED TO BE FIGHTING THE PLANE. I ASKED HIM "IS THE PLANE FLYING OKAY"? HE RESPONDED "SHE'S FLYING FUNNY". THE DEPARTURE CLEARANCE WAS RUSDR K11A2019040219501Check Valve · stuckIN FLIGHT THE CENTER TANK GAINS FUEL FROM THE LEFT TANK. REMOVED AND REPLACED CENTER TANK PUMP DISCHARGE CHECK VALVE IAW DC9 AMM 28-20-11, LEAK AND OPS CHECK GOOD IAW AMM 28-20-00 NO DEFECTS NOTEDSDR K11A2017122191501Warning Light · multiple indSPOILER DEPLOYED ANNUNCIATOR LIGHT CAME ON, SPOILERS WERE DEPLOYED. CABIN PRESSURIZATION INOPERATIVE. WINDSHEAR FAIL ANNUNCIATOR LIGHT CAME ON. FLIGHT CONTROLS, SPOILER MALFUNCTION, SECURED AIRCRAFT FOR LANDING IAW COM AND A/C CHECKLIST. RETURNED TO DEPARTURSDR K11A2017121591501Button · out of adjustLANDING GEAR HANDLE DID NOT GO UP INTO THE UP POSITION AFTER TAKEOFF. ADJUSTED ANTIRETRACTION BUTTON IAW DC-9 AMM 32-31-1, OPS CHECK GOOD, NO FURTHER DEFECTS NOTED.SDR K11A2017081891501Frame · corrodedFRAME BS 786, RBL 0 - 30 CORRODED.SDR K11A2017080991501Skin · corrodedAFT CARGO BAY SKIN CORRODED AT BS 642, RBL 14SDR K11A2016092291501Cable · out of adjustON TAKEOFF, LANDING GEAR WOULD NOT RETRACT, FOLLOWED COM PROCEDURE, CHAPTER 32, PAGE 8.SDR K11A2016110291504Window Frame · crackedCOCKPIT ENCLOSURE WINDOW SILL INTERNAL FRAME HAS A CRACK 1.3 INCHES AT BS 83 LBL 12SDR K11A201611091514Frame · crackedL/W WINDOW SILL INTERNAL FRAME CRACKED (INTERNAL FRAME) LT END CRACK LENGTH 2.0, RT END CRACK LENGTH 1.375.SDR K11A2016110291528Pressure Panel · corrodedRT WW PRESSURE WEB CORROSION.SDR K11A2016110291521Cusp Web · corrodedCUSP WEB CORROSION.SDR K11A2016110291520Frame · crackedFRAME CRACK.SDR K11A2016110291515Floorbeam · corrodedFWD PIT FLOORBEAM CORROSION.SDR K11A2016110291527Vane · corrodedRT O/B FLAP VANE HAS CORROSION.SDR K11A2016110291526Vane · corrodedRT CENTER FLAP VANE HAS CORROSION.SDR K11A2016110291525Vane · corrodedRT I/B FLAP VANE HAS CORROSION.SDR K11A2016110291519Frame · crackedFRAME CRACK.SDR K11A2016110291523Web · corrodedFLOOR WEB CORROSION.SDR K11A2016110291522Seat Track · corrodedSEAT TRACK CORROSION.SDR K11A2016110291518Bulkhead · corrodedBULKHEAD BETWEEN 19R & 20R IN AFT CARGO COMPARTMENT CORROSION.SDR K11A2016110291513Angle · crackedLT WINDSCREEN COCKPIT ENCLOSURE ZEE CORRODED.SDR K11A2016110291506Seat Track · corrodedSEAT TRACK CORRODED BS 323-394 RBL 45.SDR K11A2016110291505Cusp Web · corrodedCUSP WEB CORRODED BS 624 - 642.SDR K11A2016110291516Skin · corrodedFWD FUSELAGE EXTERIOR BELOW CUSP LINE CORROSION.SDR K11A2016110291509Floorboard · corrodedFWD OF RT OVERWING DOOR, FLOORBOARD CORROSION.SDR K11A2016090891505Cusp Web · corrodedMAIN DECK CUSP WEB CORRODED STA 216, LBL 55.SDR K11A2016110291503Frame · crackedBS 624 FRAME CRACKED LOWER FLANGE.SDR K11A2016110291512Floor Support · brokenRT STA 566-642 FLOORBOARD SUPPORT BROKEN.SDR K11A2016110291511Floorboard · corrodedRT STA 566-642 FLOORBOARD CORROSION.SDR K11A2016110291502Intercostal · crackedBS 604 - 623, STRINGER 1 INTERCOSTAL, CRACKED.SDR K11A2016090891504Intercostal · corrodedSTA 756-762, STR 1, INTERCOSTAL CORROSION.SDR K11A2016110291501Gusset · crackedFRAME GUSSET CRACKED BS 332, RBL 60.SDR K11A2016090891507Web · corrodedNOSE WW CORROSION, STA 69, RBL 12.SDR K11A2016090891506Web · corrodedNOSE WW CORROSION, STA 69, LBL 12.SDR K11A2016090891513Windscreen · crackedCORROSION AND CRACKED WINDSCREEN ENCLOSURE, PN 5912350-68, REF AD 2002-21-09.SDR K11A2016090891511Seat Track · corrodedCORROSION ON AND UNDER SEAT TRACK AT CUSPLINE, STA 642.SDR K11A2016090891510Floor Support · damagedFLOOR SUPPORTS ARE DAMAGED, STA 300-389 RT, FWD OF RT OVERWING DOOR.SDR K11A2016090891509Window Frame · crackedCOCKPIT WINDOW INTERNAL FRAME 1" CRACK, PN 9911505-5, REF AD 2002-21-09 AND SB 53-290.SDR K11A2016090891512Cusp Web · corrodedCORROSION ON CUSP WEB, STA 535-585, RT SIDE.SDR K11A2016090891508Fitting · crackedFITTING CRACKED STA 535, RBL 55, PN 3921947-503.SDR K11A2016090891501Cusp Web · corrodedAFT CARGO COMPARTMENT CEILING STA 661, RBL 60.SDR K11A2016090891503Skin · corrodedCORROSION ON LT SIDE OF FUSELAGE EXTERIOR, STA 218, BELOW CUSP LINE.SDR K11A2016090891502Thrust Reverser · crackedRIGHT ENGINE LOWER THRUST REVERSER HALF OTBD T/E CRACKED.SDR K11A2015032991501Unknown · unknownFUEL MIGRATION.SDR K11A2014092291503Door Frame · crackedRT UPPER DOOR FRAME IS CRACKED.SDR K11A2014092291506Structure · crackedFWD SIDE OF AIRSTAIR DOOR SURROUND CRACK.SDR K11A2014092291505Door Frame · crackedLEFT UPPER DOOR SURROUND FRAME IS CRACKED.SDR K11A2014120400007Spar · corrodedBS 491, FRONT SPAR RT BEHIND WING ATTACH FITTING CORROSION, 1 X 1.
Back to N915CK, cancelled Jan 25, 2022