N916CK, cancelled Jan 19, 2022
Service difficulty reports · 93
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 = 'N916CK' AND deregistration_id = 'N916CK-2022-01-19' 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 = 'N916CK' AND deregistration_id = 'N916CK-2022-01-19' 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 K11A2018011691650Warning Light · illuminatedDESCENDING TO FL 290, THE MASTER WARNING LIGHT ILLUMINATED, SIGNALING A CABIN PRESS ABOVE 10K, USED OXYGEN MASK AND DESCENDED TO FL 240, DECLARED AN EMERGENCY, FOLLOWED REMAINING CHECK LIST PROCEDURE UPON REACH 10000, AND LANDED .SDR K11A2018011591606Web · crackedMAIN DECK FLOOR WEBBING CRACKED STA 832 LBL 48. REPAIRED WEBBING AT APPROX STA 832 LBL 48 IAW SRM 53-01 FIG 4 THIS IS A CAT A REPAIR AND NO FURTHER INSPECTION REQUIRED.SDR K11A2018011591605Intercostal · crackedLOWER FWD VHF SUPPORT INTERCOSTAL CRACKED. R&R DAMAGED INTERCOSTAL IAW DWG PL5911412, SRM 51-30-5 PAR 7 PG 12 AND SRM 51-30-2.SDR K11A2018011591604Floorbeam · corrodedMAIN DECK FLOOR SUPPORT CORROSION AT STA 916 LBL 36, REPAIRED MAIN DECK FLOORBEAM SUPPORT AT STA 916 LBL 36 IAW KA DWG 53301712-1 REV OR. THIS IS A CAT A REPAIR NO FURTHER INSPECTION REQUIREDSDR K11A2018011591603Skin · crackedFUSELAGE SKIN CRACKED AT STA 1143 ABOUT 3 INCHES ABOVE SKIN LAP ON RT SIDE CRACKED IS ABOUT 1.5 INCHES LONG. REPAIRED CRACK IAW SRM 53-01 FIG 2 PG 12. THIS IS A CAT A REPAIR NO FURTHER INSPECTION REQUIREDSDR K11A2018011591602Strap · corrodedCORROSION AT STA 1089 STR 13-16, INSTALLED REPAIR IAW DWG 53301715-1, CAT A REPAIR NO FURTHER INSPECTIONS REQUIRED.SDR K11A2018011591601Floorbeam · corrodedMAIN DECK FLOORBEAM BS 897, RBL 6 CORRODED. REPAIRED IAW DWG 53301713-1, REV OR.SDR K11A2017091291603Web · crackedMAIN DECK FLOOR WEB UNDER FLOORBOARD FOUND CRACKEDSDR K11A2017091291602Floor Support · corrodedMAIN DECK FLOOR SUPPORT HAS EVIDENCE OF CORROSION AROUND FASTENER.SDR K11A2017091291601Floor Support · corrodedMAIN DECK FLOOR SUPPORT HAS EVIDENCE OF CORROSION.SDR K11A2016110416001Bulkhead Web · corrodedLEFT WHEEL WELL HAS CORROSION, UPPER PRESSURE BULKHEAD.SDR K11A2016110416005Skin · corrodedEXTERNAL SKIN FWD LOWER CARGO DOOR CUTOUT CORROSION, LONGERON 25SDR K11A2016110416006Pan · corrodedLEFT MLG WW UPPER RETAINER PAN CORRODED.SDR K11A2016110416004Longeron · corrodedLONGERON CORRODED.SDR K11A2016110700002Skin · corrodedLEFT WING FLAP LOWER SKIN CORRODED, XFLS 326.SDR K11A20161416001Skin · crackedFUSELAGE SKIN BS 266 LONGERON 5L HAS EVIDENCE OF A CRACKSDR K11A2016110416008Skin · crackedTAILCONE EXTERNAL SKIN RT SIDE CRACKED.SDR K11A2016110416003Floor Support · corrodedMAIN DECK FLOOR SUPPORT BRACKET CORRODED.SDR K11A2016110416007Skin · crackedFUSELAGE SKIN CRACKED.SDR K11A2016080391601Warning Light · illuminatedPERFORMED PRECAUTIONARY SHUTDOWN OF LEFT ENGINE DUE TO OIL PRESSURE LOW LIGHT, LOW OIL PRESSURE & ZERO ON OIL QUANTITYSDR K11A2016110291508Floorboard · corrodedAFT OF R1 DOOR FLOORBOARD CORROSION.SDR K11A2016062616001Fuel Tank · corrodedCORROSION ON THE FORWARD SIDE OF THE FUEL TANK AT STA 598, RBL 34.SDR K11A2016032291601Battery · damagedWITH AIRCRAFT ON GROUND, ATTEMPTED TO START APU TO REPOSITION, FOUND SHIP BATTERIES WEAK, INVESTIGATED AND DISCOVERED ONE OF THE SHIP BATTERY CASES DAMAGED. REPLACED BATTERIES AND CHARGER.SDR K11A2015121516001Stringer · corrodedCORROSION AT STRINGER 23, RT BS 225 FWD CARGO.SDR K11A2015041416001Skin · corrodedCORROSION ON FUSELAGE BELL JUST AFT OF NR 1 DME INTERROGATOR ANTENNA, FS 330.SDR K11A2013060616001Fuel Cap · missingFUEL REPORTED AS VENTING FROM RT WING, NOTED FUEL IMBALANCE AND RETURNED TO DEPARTURE. UPON INVESTIGATION, FOUND RT OVERWING FUEL CAP MISSING, REPLACED CAP AND FUELED TO VTO, NO LEAKS NOTED.SDR K11A2012070516005Intercostal · crackedINTERCOSTAL CRACKED AT LIGHTNING HOLE, 1 INCH (NR47561).SDR K11A2012060816010Seat Track · corrodedPILOTS AFT OUTBOARD SEAT TRACK CORRODED (1 INCH).SDR K11A2012060816009Door Frame · corrodedAFT EMERGENCY DOOR CUTOUT LT LOWER CORNER STRUCTURE CORRODED (1 INCH).SDR K11A2012032116002Skin · canningFWD LOWER CARGO DOOR SKIN OIL CANNED (NR 46742).SDR K11A2012060816004Longeron · crackedLONGERON CRACK (1 INCH).SDR K11A2012060816006Floor Support · corrodedCOCKPIT FLOOR SUPPORT UNDER FWD SIDE OF AVIONICS RACK HAS CORROSION (1X1).SDR K11A2012060816005Frame · damagedSTA 69 RIGHT SIDE HAS DAMAGE AREA ON FRAME (1 INCH).SDR K11A2012060816008Seat Track · damagedSEAT TRACK DAMAGED ON END OF VERTICAL LEG INSIDE TRACK SECTION (1 INCH).SDR K11A2012031216005Splice · corrodedSPLICE CORRODED 1 IN X 1 IN CORROSION (N/R 21860).SDR K11A2012031216003Floorbeam · corrodedUPPER FLOORBEAM CAP, TOP SIDE HAS SEVERAL AREAS OF CORROSION 1 IN X 1 IN CORROSION (N/R 21713).SDR K11A2012030816004Attach Angle · corrodedPRESSURE PANEL ATTACH ANGLE CORRODED 1 X 2 INCHES.SDR K11A2012060816007Cusp Web · crackedCUSP WEB CRACKED (1 INCH).SDR K11A2012032116001Floor Support · corrodedFRAME TO FLOOR TIE CORRODED 1 X 1 INCH (NR 21870).SDR K11A2012031216004Frame · corrodedLIGHT CORROSION ON FRAME (1 IN X 1 IN) CORROSION (N/R 21783).SDR K11A2012031216002Frame · corrodedFRAME CORRODED MAIN CARGO DECK 1 IN X 1 IN (N/R 21634).SDR K11A2012031216001Attach Fitting · corrodedCORRODED BOLT THROUGH FRAME ATTACHMENT FITTING 1 IN X 1 IN (N/R 21639).SDR K11A2012030916005Angle · corrodedL-ANGLE ALONG INTERIOR UPPER AREA OF TRAPEZOID PANEL CORROSION 1 IN X 1 IN CORROSION (N/R 22592).SDR K11A2012030916003Fitting · corrodedAFT HALF OF TIE FITTING CORROSION 1 IN X 1 IN CORROSION (N/R 22828).SDR K11A2012030916002Tee Fitting · corrodedAFT WALL LOWER TEE CHORD CORRODED 1 IN X 1 IN CORROSION (N/R 22893).SDR K11A2012030916001Tee Fitting · corrodedAFT WALL UPPER TEE CHORD CORRODED 1 IN X 1 IN CORROSION (N/R 22892).SDR K11A2012030916004Intercostal · corrodedINTERCOSTAL WEB HAS AREA OF CORROSION 2 IN X 2 IN CORROSION (N/R 21880).SDR K11A2012030816005Intercostal · crackedINTERCOSTAL CRACKED 5 INCHES (NR 22889).SDR K11A2012030816003Web · corrodedHORIZONTAL WEB HAS SEVERAL AREAS CORROSION 2 X 2, 1 X 4, 2 X 2 (NR21976).SDR K11A2012030716001Attach Angle · corrodedINTERCOSTAL VERTICAL L-ANGLE LOWER FASTENER HOLES CORROSION, 5 X 1 INCHES (REF NR 21740).
Back to N916CK, cancelled Jan 19, 2022