N707SK
Service difficulty reports · 282
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 = 'N707SK' 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 = 'N707SK' 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 SWIA202052675Intercostal · corrodedPASSENGER DOOR NR 3 INTERCOSTAL IS CORRODED, MARKED & FLAGGED. C-CHECK RO 9/21/2020. INSTALLED NEW PAX DOOR NR 3 (DD3) INTERCOSTAL, REF CRJ 700 SRM AND DWG. COMPLIED WITH SKY CARD.SDR SWIA202052674Handle · corrodedPASSENGER DOOR INNER HANDLE HAS CORROSION AROUND THE TWO ROLL PINS AT THE TOP OF THE HANDLE, MARKED. C-CHECK RO 9/21/2020. RECEIVED REF REO. THE PASSENGER DOOR INNER HANDLE AROUND THE TWO ROLL PINS AT THE TOP OF THE HANDLE IS STRUCTURE ACCEPTABLE, REF REO. SDR SWIA202052673Rod · corrodedPASSENGER DOOR THE THREE TORQUE RODS FOR THE BETWEEN THE PULL-IN LEVERS ARE CORRODED, FLAGGED. C-CHECK RO 9/21/2020. REPLACED PAX DOOR TORQUE RODS, REF CRJ 700 AMM. OPS CHECK GOOD.SDR SWIA202052672Door Sill · chafedAFT CARGO DOOR SILL HAS CHAFING DAMAGE, MARKED. C-CHECK RO 9/21/2020. BLENDED OUT CHAFING DAMAGE ON AFT CARGO DOOR SILL, REF CRJ700 SRM. BLEND IS WITHIN LIMITS, SEE CONTINUATION FOR DETAILS.SDR SWIA202052671Floorboard · brokenAVIONICS BAY FLOORBOARD 131ALF IS BROKEN. C-CHECK RO 9/21/2020. ORDERED AND RECEIVED NEW FLOORBOARD PN: CMKRJ700FP-185N. INSTALLED ON MXTRANS NR 21213507.SDR SWIA202052670Seat Track · corrodedRT SIDE SEAT RAIL MOUNTING CHANNEL HAS CORROSION AROUND FLOATING NUTPLATE CLIP HOLE. C-CHECK RO 9/21/2020. REMOVED CORROSION ON RT SIDE RAIL MOUNTING CHANNEL NUTPLATE CLIP HOLE ON FS 787-797, FOUND TO BE WITHIN LIMITS REF SRM.SDR SWIA202052669Seat Track · corrodedLT SIDE SEAT RAIL HAS CORROSION BETWEEN FS 785.15-FS 797.00. C-CHECK RO 9/21/2020. REMOVED CORROSION ON LEFT SIDE SEAT RAIL FS 785.00-797.00, REF CRJ700 SRM. OUT OF LIMITS, DAMAGE IS LOCATED AT UPPER LOCATION (C-C) AND AT THE FASTENER LOCATION, REF CRJ700 SSDR SWIA202052668Seat Track · corrodedLT SIDE SEAT RAIL HAS CORROSION BETWEEN FS 736.00 FS 752.00. C-CHECK RO 9/21/2020. REMOVED CORROSION ON LEFT SIDE SEAT RAIL BETWEEN FS 736.00 AND 752.00 REF CRJ700 SRM. ONLY ONE TYPE OF DAMAGE IS ALLOWED AT ANY TYPICAL CROSS-SECTION ALONG THE LENGTH OF THSDR SWIA202052667Seat Track · corrodedRT SIDE SEAT RAIL HAS CORROSION AT FS 561.00, MARKED. C-CHECK RO 9/21/2020. REMOVED CORROSION ON RIGHT SIDE SEAT RAIL AT FS 561.00, REF CRJ700 SRM. EVALUATED CORROSION REMOVAL RIGHT SIDE SEAT RAIL AT FS 561.00. ORIGINAL MATERIAL THICKNESS IS 0.105, REF CRJSDR SWIA202052666Slat Track · damagedRT WING SLAT TRACK 1-1 HAS FASTENER MISSING SAFETY ON NUT, MARKED. C-CHECK RO 9/21/2020. INSTALLED NEW COTTER PIN ON THE RT WING SLAT TRACK 1-1 NUT (OUTBOARD SIDE), REF CRJ-700 AMM.SDR SWIA202052665Skin · gougedFS 977.00 FWD OF FS 1162.00 AND STRG 0 HAS SEVERAL GOUGES ON EXTERNAL SKIN, MARKED. C-CHECK RO 9/21/2020. BLENDED ALL GOUGED AREAS AT UPPER FUSELAGE SKIN FROM APPROX FS 977 TO FS 1162 STRG 0, REF CRJ-700 SRM. ALL AREAS FOUND TO BE WITHIN LIMITS.SDR SWIA202052664Skin · corrodedEXTERNAL MATING SURFACE ON FUSELAGE SKIN AND FAIRING PANEL 192BB HAS CORROSION ON VARIOUS MOUNTING FASTENER HOLES, MARKED. C-CHECK RO 9/21/2020. COMPLIED WITH PERMANENT REPAIR SKIN UNDER 192BB, REF REO. DAMAGE WITHIN LIMITS, VERIFIED ALL STEPS COMPLIED WITHSDR SWIA202052663Skin · corrodedEXTERNAL MATING SURFACE ON FUSELAGE SKIN AND FAIRING PANEL 191AB HAS CORROSION ON VARIOUS MOUNTING FASTENER HOLES, MARKED. C-CHECK RO 9/21/2020. COMPLIED WITH PERMANENT REPAIR FUSELAGE SKIN UNDER 191AB, REF REO. DAMAGE WITHIN LIMITS, VERIFIED ALL STEPS COMPSDR SWIA202052662Skin · chafedLT WING PANEL 584EB IS CHAFED. C-CHECK RO 9/21/2020. REMOVED DAMAGE FROM FLAP PANEL 584EB, REF CRJ 700 SRM. PANEL OUT OF LIMITS. ORDERED AND RECEIVED NEW FLAP PANEL 584EB, SEE CONTINUATION CARD FOR DETAILS.SDR SWIA202052661Skin · chafedFLAP PANEL 684EB CHAFED. C-CHECK RO 9/21/2020. REMOVED DAMAGE FROM FLAP PANEL 684EB, REF CRJ 700 SRM. PANEL OUT OF LIMITS. ORDERED AND RECEIVED NEW FLAP PANEL 684EB, SEE CONTINUATION CARD FOR DETAILS.SDR SWIA202052660Skin · chafedINBOARD FLAP PANEL 684BB CHAFFED INBOARD OUTER SKIN SURFACE. C-CHECK RO 9/21/2020. BLENDED OUT CHAFE ON INBOARD OUT SKIN SURFACE, INBOARD FLAP PANEL 684BB, REF CRJ 700 SRM. SEE CONTINUATION CARD FOR DETAILS.SDR SWIA202052659Threshold · corrodedEVIDENCE OF CORROSION ON SERVICE DOOR THRESHOLD COVER PLATE. C-CHECK RO 9/21/2020. REMOVED CORROSION ON SERVICE DOOR THRESHOLD COVER PLATE. FOUND TO BE WITHIN LIMITS, REF CRJ700 SRM.SDR SWIA202052658Skin · dentedAFT FUSELAGE OUTSIDE SKIN RT SIDE BETWEEN FS 1015.00 AND FS 1051.30 AND BETWEEN STR 27R AND STR 23R THERE ARE VARIOUS DENTS AND GOUGES AND NICKS, MARKED. C-CHECK RO 9/21/2020. REPAIRED AFT FUSELAGE OUTSIDE SKIN ON RT SIDE BETWEEN APPROX FS 1015 AND FS 1051.3SDR SWIA202052657Retainer · bentFORWARD BAGGAGE BAY DOOR, METAL PRESSURE SEAL RETAINER INNER AND OUTER BENT IN SEVERAL PLACES ALONG EDGES, MARKED ORANGE FLAG. C-CHECK RO 9/21/2020. REMOVED AND INSTALLED NEW FORWARD BAGGAGE BAY DOOR, METAL PRESSURE SEAL RETAINER INNER AND OUTER, REF CRJ 70SDR SWIA202052656Skin · damagedSCRAPE ABOVE LT UPPER CORNER OF CARGO DOOR FS 533.00 STG LH 14. IF WITHIN ACCEPTABLE LIMITS OR REWORKED ELIMINATE EVIDENCE USING STANDARD PRACTICES. C-CHECK RO 9/21/2020. HAND DRESSED FUSELAGE SKIN DENT LOCATED JUST AFT OF FS 533.00 BETWEEN STRG 16L & STRGSDR SWIA201946098Rod · out of adjustRECEIVED A NOSE DOOR OPEN WARNING MESSAGE. RETURNED TO DEPARTURE. FLT 2983, ADJUSTED THE RT NLG DOOR ROD IAW AMM. OPERATIONAL TEST GOOD AT THIS TIME AND NO FURTHER DEFECTS NOTED.SDR SWIA201642584Door Sill · corrodedAFT CARGO COMPARTMENT LT SILL HAS CORROSION APPROXIMATELY FS 1047.00. REPLACED AFT CARGO DOOR SILL IAW STS EA AND SRM.SDR SWIA201642583Intercostal · corrodedPAX DOOR INTERCOSTAL, PN 601R31902-317 HAS CORROSION. REPLACED INTERCOSTAL IAW SRM.SDR SWIA201642582Intercostal · corrodedPASSENGER DOOR INTERCOSTAL DD3, PN 601R318054-1 HAS CORROSION. REPLACED INTERCOSTAL IAW SRM.SDR SWIA201642581Intercostal · corrodedMAIN AVIONICS COMPARTMENT DOOR SURROUND STRUCTURE, INTERCOSTAL 27 LT HAS CORROSION AT STA FS 364. REPLACED THE INTERCOSTAL 27LT PN SH670-32075-3 IAW SRM. LEAK CHECK GOOD.SDR SWIA201642580Intercostal · corrodedMAIN AVIONICS COMPARTMENT DOOR SURROUND STRUCTURE. INTERCOSTAL 27 RT HAS CORROSION AT STA FS 364. REPLACED INTERCOSTAL IAW SRM.SDR SWIA201642579Panel · chafedRT WING AILERON PANEL 699AB IS CHAFED. REPLACED PANEL IAW SRM.SDR SWIA201440136Web · crackedFOUND WEB CRACKED UNDER RIB. REPAIRED IAW REO.SDR SWIA201440132Conduit · brokenCONDUIT ON SERVICE DOOR BROKEN, REPAIRED THE CONDUIT IAW REO.SDR SWIA201440130Structure · bentRIGHT UPPER FAN COWL INBD LOWER AFT CORNER BENT. REPAIRED RT UPPER FAN COWL DOOR IAW REO. OPS CHECKED GOOD AT THIS TIME.SDR SWIA201440128Skin · dentedRT ENGINE UPPER TRANSCOWL INBD FWD CORNER DENTED. REPAIRED RT ENGINE UPPER TRANSCOWL INBD FWD CORNER DENT IAW REO TESTED GOOD.SDR SWIA201440126Frame · corrodedFRAME BS 310 STR 27 CORRODED BEYOND LIMITS. REPAIRED THE FRAME IAW REO.SDR SWIA201440122Skin · damagedPANEL 622AR HAS ONE ELONGATED HOLE ON BOTTOM OF SKIN NEAR THE L/E, ON OTBD SIDE OF SLAT TRACK 1-2, HEAD OF SCREW GOES THROUGH THE HOLE. C-CHECK, RO 11/24/14, REPAIRED PANEL 622AR IAW STS EA.SDR SWIA201440119Skin · gougedGOUGE ON OUTER LOWER FUSELAGE SKIN AT BS 295. REPAIRED THE SKIN IAW EA.SDR SWIA201440116Axle · corrodedCORROSION FOUND ON LT MLG NR 2 PISTON AXLE ROOT RADIUS. REPAIRED THE PISTON AXLE IAW REO.SDR SWIA201440114Axle · corrodedCORROSION FOUND ON LT MLG NR 1 PISTON AXLE ROOT RADIUS, C-CHECK RO 11/20/14. REPAIRED CORROSION ON LT MLG NR 1 PISTON/AXLE ROOT RADIUS IAW REO, BTAC M-210B, 3 PAGES.SDR SWIA201440109Web · crackedA CRACK WAS FOUND ON THE RIGHT TRU BAY FLOOR WEB, OTBD OF THE ADG PUMP. REPAIRED THE FLOOR WEB RT AT BS 193 IAW EA.SDR SWIA201440107Floorbeam · crackedBS 274, RBL 12 FLOORBEAM IS CRACKED. CUTOUT THE DAMAGE AND REPAIRED IAW REO.SDR SWIA201440105Floorbeam · crackedBS 274, LBL 12 FLOORBEAM IS CRACKED. CUT OUT THE DAMAGE AND INSTALLED A REPAIR IAW REO.SDR SWIA201440102Door Sill · corrodedAFT CARGO DOOR SILL HAS CORROSION. REMOVED CORROSION WITHIN LIMITS OF REO.SDR SWIA201440100Arm · gougedGOUGE ON FWD CARGO DOOR AFT HINGE ARM. REPAIRED THE HINGE ARM IAW EA.SDR SWIA201440097Arm · gougedGOUGE ON FWD CARGO DOOR FWD HINGE ARM. REPAIRED THE HINGE ARM IAW EA.SDR SWIA201440095Web · crackedCRACKED WEB AT APPROXIMATELY BS 909. REPAIRED THE WEB IAW REO.SDR SWIA201440093Panel · delaminatedPANEL 333AL IS DELAMINATED. REPAIRED DELAMINATION IN PANEL IAW EA.SDR SWIA201440091Pan · crackedCRACKED AFT LAVATORY FLOOR PAN. REPAIRED THE AFT LAVATORY FLOOR PAN IAW EA.SDR SWIA201440088Skin · dentedDENT ON LT ENGINE LOWER FAN COWL,. FOUND TO BE WITHIN LIMITS, IAW REO.SDR SWIA201440086Skin · dentedDENT AT BS 371 BELOW STRINGER 21L. COLD WORKED AND HAND DRESSED THE DENT TO OR AS CLOSE TO ORIGINAL CONTOUR IAW EA,SDR SWIA201439420Skin · dentedDENT FROM BIRDSTRIKE, THREE INCHES AFT AND THREE INCHES ABOVE RT PITOT TUBE, IN THE RVSM AREA. REMOVED AND REPLACED SKIN BETWEEN BS 202.75 AND 280 IAW SRM.SDR SWIA201439195Light · brokenPAX DOOR AREA EMERGENCY "EXIT" LIGHT BROKEN, R & R EMERGENCY LIGHT IAW AMM.SDR SWIA201438703Loop · failedLEFT BLEED DUCT WARNING ILLUMINATED AT APPROXIMATELY FL 270. WITHIN A MINUTE WARNING CHANGED TO LEFT PACK FAIL. CABIN CLIMBED TO FL 180, PAX OXYGEN MASKS AUTOMATICALLY DEPLOYED. DECLARED EMERGENCY AND RETURNED TO FIELD. REPLACED MT 139 LOOP A & B AND SUPPOR
Back to N707SK