N701CK
Service difficulty reports · 80
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 = 'N701CK' AND registry_match = 'registration' 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 = 'N701CK' AND registry_match = 'registration' 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 KCSA202303101016Shear Tie · brokenWHILE ACCOMPLISHING DVI OF STA 1000 FRONT SPAR SHEAR TIE FOUND 1 EA FROM SHEAR TIE BROKEN AT RBL 57.50 REPLACEMENT OF PART REQUIRED PER EO 5312-22-01 G2 CONDITION 13 STEP #95SDR KCSA202303101015Fitting · brokenWHILE ACCOMPLISHING DVI OF STA 1000 FRONT SPAR SHEAR TIE FOUND 1 EA INTERCOSTAL LUG FITTING BROKEN AT LBL 11.33 REPLACEMENT OF PART REQUIRED PER EO 5312-22-01 G2 CONDITION 6 STEP #27 FIG 4SDR ERKR0410032326416Seat Track · corrodedWHILE ACCOMPLISHING INTERCOSTAL LUG FITTING REPLACEMENT AT STA. 1000 LBL 11.33, FOUND A CRACK ON THE RADIUS OF BOTTOM FLANGE OF LBL 11.33 SEAT TRACK AT STA. 998.SDR KCSA202303101014Seat Track · corrodedAFTER REMOVAL OF FLOORBAORDS TO GAIN ACCESS FOR SEAT TRACK REPAIR AT STA 998 LBL 11.33 FOUND CORROSION ON SEAT TRACK IB FLANGE AT STA 980 APPROX RBL 11.33SDR KCSA202303101013Seat Track · crackedWHILE ACCOMPLISHING INTERCOSTAL LUG FITTING REPLACEMENT AT STA 1000 LBL 11.33 FOUND A CRACK ON THE RADIUS OF BOTTOM FLANGE OF LBL 11.33 SEAT TRACK STA 998SDR KCSA202303101012Shear Tie · crackedWHILE ACCOMPLISHING DVI OF STA 1000 FRONT SPAR SHEAR TIE FOUND 1 EA FRONT SHEAR TIE CRACKED AT RBL 75.9 REPLACEMENT OF PART REQUIRED PER EO 5312-22-01 G2 CONDITION 13 STEP # 101 AND # 102SDR KCSA202303101011Fitting · crackedWHILE ACCOMPLISHING SB 747-53A2427 FIG 2 AT STA 2598 RH SIDE FOUND 2 EA FASTENER HOLE WITH CRACK INDICATION COMMON TO FWD INNER CHORD AND UPPER SPLICE FITTING (3RD AND 4TH HOLES FROM TOP TO BOTTOM)SDR ERKR0310032326416None · noneEMER LT SYSTEM FAILED BURN DOWN TEST.SDR ERKR0210032326416None · noneEMER LT SYSTEM FAILS BURN DOWN TEST.SDR ERKR0110032326416None · noneEMER LT SYSTEM FAILS BURN DOWN TEST.SDR KCSA2021031907Fire Warning · false activationMAIN DECK FIRE WARNING SYSTEM GAVE FALSE INDICATION IN FLIGHT, NO FIRE ACTUALLY OCCURED. PERFORMED FIRE/OVERHEAT PROTECTION GROUND TEST IAW B747-400 AMM 26-11-00. TEST PASSED NO DEFECTS AT THIS TIME.SDR KCSA202102241012Skin · damagedEVIDENCE OF DAMAGE ON RIGHT EXTERNAL FUSELAGE SKIN AT APPROXIMATELY BS 2450 WL 280.SDR KCSA202102241011Skin · damagedEVIDENCE OF DAMAGE ON LEFT EXTERNAL FUSELAGE SKIN AT APPROXIMATELY BS 2450 WL 280.SDR KCSA202008281139Skin · crackedCRACK IN SKIN ON LT OF EMPENNAGE APPROXIMATELY STA 2656SDR KCSA20200708309Pseu · failedGEAR DISAGREE, RIGHT BODY GEAR NOT INDICATING DOWN AND LOCKED. EMERGENCY DECLARED. AUTOLAND PERFORMED. REMOVED AND REPLACED PSEU IAW B747-400 AMM 32-09-03. OPS CHECK GOOD. NO DEFECTS NOTED AT THIS TIME.SDR KCSA202001021002Light · inoperativeUPPER DECK CEILING EMERG LIGHT AT STA 550 INOPSDR KCSA202001021001Light · inoperativeMAIN DECK CEILING EMERG LIGHT AT STA 450 I/B OF L-1 DOOR INOPSDR KCSA202001021000Light · inoperativeL-1 DOOR FWD EMERG LIGHT INOPSDR KCSA201903051038Light · inoperativeEMERGENCY LIGHTS L5733 STA 550 WL 394 BL-0, L5767 STA587 WL391 BL-0, AND M4915 EXIT SIGN STA 410 WL 388 BL-0 INOP.SDR KCSA201902261036Seat Track · corrodedEVIDENCE OF CORROSION ON VERTICAL LEG OF MAIN DECK SEAT TRACK STA 1690 LBL 12SDR KCSA201901311021Intercostal · crackedOVERWING INTERCOSTAL WEB IS CRACKED (1 1/4") AT STATION 1180 RBL 112 WL 186.SDR KCSA201901311020Intercostal · crackedOVERWING INTERCOSTAL WEB IS CRACKED (1 1/2") AT STATION 1180 LBL 112 WL 186.SDR KCSA201901311019Intercostal · crackedOVERWING INTERCOSTAL WEB IS CRACKED (2") AT STATION 1220 RBL 112 WL 186.SDR KCSA201901311018Intercostal · crackedOVERWING INTERCOSTAL WEB IS CRACKED (2") AT STATION 1200 RBL 112 WL 186.SDR KCSA201901311017Intercostal · crackedOVERWING INTERCOSTAL WEB IS CRACKED (1.1/4") AT STATION 1200 LBL 112 WL 186.SDR KCSA201901301016Angle · corrodedEVIDENCE OF CORROSION ON ANGLE ATTACHED TO LOWER T CORD OF MAIN DECK FLOORBEAM STA 2020 LBL 58 TO 65.SDR KCSA201901301015Seat Track · corrodedEVIDENCE OF CORROSION ON BOTTOM OF MAIN DECK SEAT TRACK STA 2125 RBL 92.SDR KCSA201901301014Floorbeam · crackedSTA 420 RT UPPER DECK FLOOR BEAM HAS ONE FASTENER HOLE CRACKED.SDR KCSA201901301013Stiffener · crackedPOSSIBLE CRACK IN STIFFENER INSIDE AFT PIT DOOR LIGHTNING HOLE JUST BELOW FWD ACTUATOR ATTACH FITTING APPROX STA 1820 15" FROM TOP OF DOOR.SDR KCSA201712251092Light · inoperativeL1 DOOR EMERGENCY LIGHT INOPERATIVE.
Back to N701CK