N563PC, cancelled Oct 16, 2017
Service difficulty reports · 96
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 = 'N563PC' AND deregistration_id = 'N563PC-2017-10-16' 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 = 'N563PC' AND deregistration_id = 'N563PC-2017-10-16' 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 GAIA99147Skin · dentedDURING C-CHECK INSPECTION, FOUND NUMEROUS DENTS ON THE LEFT FLAP REMOVABLE PANEL TRAILING EDGE SKIN AT XFLS 65.5 TO XFLS 127.4. THE SKIN WAS REPLACED IAW KITTY HAWK EA D9-57-008, THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA98109Control Cable · looseKHA - FLT 1211 - YIP-MMLO - AFTER TAKEOFF FROM YIP THE FLIGHT CREW FOUND THE LANDING GEAR DID NOT RETRACT WITH THE GEAR HANDLE UP. THE CREW ELECTED TO RETURN TO YIP AND MADE AN UNEVENTFUL LANDING. INVESTIGATION FOUND THE LANDING GEAR BY-PASS HANDLE CABLE OFFSDR GAIA9822Control Cable · iced upKHA - FLT 805 - SFO-SEA - ON APPROACH TO SEA THE FLIGHT CREW FOUND THE LANDING GEAR HANDLE STUCK IN THE UP POSITION. THE CREW ELECTED TO USE ALTERNATE GEAR EXTENSION PROCEDURES AND MADE AN UNEVENTFUL LANDING. INSPECTION FOUND A BLOCK OF ICE HANGING ON THE LASDR GAIA9817Beam · crackedDURING INSPECTION FOR AD 81-10-10 A 1 INCH CRACK WAS FOUND ON THE NR 1 BEAM IN THE UPPER FORWARD CORNER OF THE FORWARD GALLEY SERVICE DOOR. THE BEAM WAS REPAIRED IAW THE DOUGLAS SRM CHAPTER 52 FIG 25. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA9816Channel · corrodedDURING INSPECTION OF CORROSION TASK 58-53301 WHILE AIRCRAFT WAS IN C-CHECK, LEVEL 2 CORROSION WAS FOUND ON A FLOOR CHANNEL AT FUSELAGE STATION 776 LBL 33. THE CHANNEL WAS REPAIRED IAW KITTY HAWK EA D9-53-051. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA9815Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AT BS 383 LBL 44.5. (M)SDR GAIA9814Skin · crackedDURING INSPECTION OF THE FUSELAGE SKIN PER AD 81-26-03R1 SIX CRACKS WERE FOUND AT STATION 817. FOUR CRACKS BETWEEN L2R ANDL3R AND TWO CRACKS BETWEEN L1 AND L2L. THE SKIN WAS REPAIRED IAW SERVICE REWORK DRAWING J060143. (M)SDR GAIA9813Skin · dentedDURING C-CHECK INSPECTION, FOUND A TEMPORARY REPAIR AND DENT ON THE FUSELAGE SKIN JUST BELOW THE FORWARD ENTRANCE DOOR BETWEEN LONGRON 20L AND 18L AT FUSELAGE STATION 211. THE DAMAGE WAS REPAIRED IAW KITTY HAWK EA D9-53-049. (M)SDR GAIA9812Blkhd T-Cap · corrodedDURING INSPECTION OF CORROSION TASK 13-57301 WHILE AIRCRAFT WAS IN C-CHECK LEVEL 2 CORROSION WAS FOUND ON THE SURFACE OF THE WING BULKHEAD LOWER T-CAP AT STATION 58.5 OF THE LEFT WING BETWEEN STRINGER 11 THROUGH 17. THE T-CAP WAS REPAIRED IAW WITH DC-9 SB 57-SDR GAIA9811Blkhd T-Cap · corrodedDURING INSPECTION OF CORROSION TASK 14-57301 WHILE AIRCRAFT WAS IN C-CHECK LEVEL 2 CORROSION WAS FOUND ON THE SURFACE OF THE WING BULKHEAD LOWER T-CAP AT STATION 58.5 OF THE RIGHT WING BETWEEN STRINGERS 11 THROUGH 16. THE T-CAP WAS REPAIRED IAW THE DC-9 SB 57SDR 98ZZZM316Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AT BS 604 RBL 44.5. (M)SDR 98ZZZM315Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AT BS 784 RBL 22. (M)SDR 98ZZZM314Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AT BS 675 RBL 22. (M)SDR 98ZZZM313Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AT BS 674 RBL 22. (M)SDR 98ZZZM312Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AT BS 519 RBL 22. (M)SDR 98ZZZM311Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AT BS 764 LBL 22. (M)SDR 98ZZZM310Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS. (M)SDR 98ZZZM309Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AT BS 680 LBL 22. (M)SDR 98ZZZM308Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AT BS 585 LBL 22. (M)SDR 98ZZZM307Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AT BS 568 LBL 22. (M)SDR 98ZZZM306Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AT BS 517 LBL 22. (M)SDR 98ZZZM305Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AT BS 695 LBL 44.5. (M)SDR 98ZZZM304Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AT BS 634 LBL 44.5. (M)SDR 98ZZZM303Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AT BS 602 LBL 44.5. (M)SDR 98ZZZM302Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AT BS 516 LBL 44.5. (M)SDR 98ZZZM301Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AT BS 428 LBL 44.5. (M)SDR 98ZZZM286Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AB BS 383. SEAT TRACK WAS REPAIRED IAW KITTY HAWK EA D9-53-051. REFERENCE GAIA9815.SDR 98ZZZM285Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AB BS 383. SEAT TRACK WAS REPAIRED IAW KITTY HAWK EA D9-53-051. REFERENCE GAIA9815.SDR 98ZZZM284Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AB BS 383. SEAT TRACK WAS REPAIRED IAW KITTY HAWK EA D9-53-051. REF GAIA9815.SDR 98ZZZM283Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AB BS 383. SEAT TRACK WAS REPAIRED IAW KITTY HAWK EA D9-53-051. REF GAIA9815.SDR 98ZZZM282Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AB BS 383. SEAT TRACK WAS REPAIRED IAW KITTY HAWK EA D9-53-051. REF GAIA9815.SDR 98ZZZM281Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AB BS 383. SEAT TRACK WAS REPAIRED IAW KITTY HAWK EA D9-53-051. REF GAIA9815.SDR 98ZZZM280Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AB BS 383. SEAT TRACK WAS REPAIRED IAW KITTY HAWK EA D9-53-051. REF GAIA9815.SDR 98ZZZM279Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AB BS 383. SEAT TRACK WAS REPAIRED IAW KITTY HAWK EA D9-53-051. REF GAIA9815.SDR 98ZZZM278Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AB BS 383. SEAT TRACK WAS REPAIRED IAW KITTY HAWK EA D9-53-051. REF GAIA9815.SDR 98ZZZM277Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AB BS 383. SEAT TRACK WAS REPAIRED IAW KITTY HAWK EA D9-53-051. REF GAIA9815.SDR 98ZZZM276Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AB BS 383. SEAT TRACK WAS REPAIRED IAW KITTY HAWK EA D9-53-051. REF GAIA9815.SDR 98ZZZM275Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AB BS 383. SEAT TRACK WAS REPAIRED IAW KITTY HAWK EA D9-53-051. REF GAIA9815.SDR 98ZZZM274Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AB BS 383. SEAT TRACK WAS REPAIRED IAW KITTY HAWK EA D9-53-051. REF GAIA9815.SDR 98ZZZM273Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AB BS 383. SEAT TRACK WAS REPAIRED IAW KITTY HAWK EA D9-53-051. REF GAIA9815.SDR 98ZZZM272Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AB BS 383. SEAT TRACK WAS REPAIRED IAW KITTY HAWK EA D9-53-051. REF GAIA9815.SDR 98ZZZM271Seat Track · misrepairedDURING C-CHECK INSPECTION, FOUND INADEQUATE REPAIRS ON THE FLOOR SEAT TRACKS AB BS 383. SEAT TRACK WAS REPAIRED IAW KITTY HAWK EA D9-53-051. REF GAIA9815.SDR GAIA9905Bungee · leakingKHA - FLT 1563 - PIA-ELP - ON APPROACH TO ELP, THE FLIGHT CREW NOTICED THE LANDING GEAR WAS SLOW TO EXTEND. THE CREW ELECTED TO CYCLE THE GEAR AND NOTED THE SAME RESULTS. A UNEVENTFUL LANDING WAS MADE. THE AIRCRAFT WAS FERRIED GEAR DOWN TO DFW INVESTIGATIONSDR GAIA9606Frame · crackedDURING C-CHECK INSPECTION REVEALED 6 CRACKED STRUT FRAME ATTACH FITTINGS IN THE LOWER FUSELAGE CARGO COMPARTMENTS. CLOSER INSPECTION REVEALED THE CRACKS TO BE CORROSION CRACKS ALONG GRAIN LINES. FOUR FRAMES WERE REPLACED IAW THE DOUGLAS SRM AND TWO OF THE FRSDR GAIA9527Downlock Switch · iced upKHA - FLT 290 - TRI/ROC - ON APPROACH TO ROC, LT MLG DID NOT INDICATE DOWN AND LOCKED. GREEN LIGHT DID NOT ILLUMINATE. FLIGHT CREW DECLARED AN EMERGENCY, A NORMAL UNEVENTFUL LANDING WAS MADE IN ROC. ON TAXI TO RAMP, GROUND PERSONNEL NOTED LT INBOARD MAIN WHSDR GAIA9503Gear Selector · malfunctionedYIP/OKC - FLT 511 - DURING APPROACH TO OKC, FLIGHT CREW DISCOVERED LANDING GEAR SELECTOR WOULD NOT MOVE DOWN. ABNORMAL LANDING GEAR EXTENSION PROCEDURES WERE FOLLOWED AND THE GEAR WAS EXTENDED. PRIOR TO CROSSING THE OUTER MARKER, THE LANDING GEAR SELECTOR WA
Back to N563PC, cancelled Oct 16, 2017