N732SK
Service difficulty reports · 190
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 = 'N732SK' 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 = 'N732SK' 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 SWIA202264840None · groovedPAX DOOR, HINGE DAMAGED AT AFT LUG (GROOVED) (C-CHECK RO 3/11/2022) COMPLIED WITH REPAIRED ON PAX DOOR FUSELAGE HINGE AT AFT LUG LAND REF CRJ 700 SRM 53-21-23-201-010-A01 DISPOSITION TYPE IVSDR SWIA202264837None · chafedEVALUATE 2 SKIN CHAFES AT STGR. 27 JUST FWD OF F.S. 977 (MARKED) (C-CHECK RO 3/11/2022) PERFORMED REPAIR TO EXTERNAL SKIN AT FWD AND AFT OF FS 977 AND STRINGER 27 REF REO 670-53-00-687 REV -- DATED 2022-02-07 (ALL STEPS COMPLIED WITH) AND REO 670-53-00-SDR SWIA202264835None · gougedRH SLAT #2 TRAILING EDGE HAVE GOUGE AND MISSING PIECE, LOCATE APPROX. 48 INCHES FROM IB SIDE OF RH#2 SLAT (C-CHECK RO 3/11/2022) BLENDED DAMAGE TO A SMOOTH CONTOUR REF CRJ700 SRM 51-12-00-001-001-A01, EVIDENCE OF GOUGE IS STILL PRESENT ON LOWER SKIN TRASDR SWIA202164833None · dentedADM 7524 - DENT ON SEAL STRIKER 1.9" L BY 0.024" D BETWEEN R/H STRINGER 13 & STRINGER 14. PLOT, MAP, AND EVALUATE DAMAGE IF WITHIN ACCEPTABLE LIMITS OR REWORKED, ELIMINATE EVIDENCE USING STANDARD ACFT PRACTICES. (C-CHECK RO 3/11/2022) PERFORMED PERMANESDR SWIA202158609Windshield · crackedCA WSHLD CRACKED DURING CRUISE AT FL370 , RAN A QRH CONTINUED TO DFW (FLIGHT 3223 - FILED CLOSED) PLEASE REFERENCE AML 648035 PLEASE REFERENCE AML 648036 PLEASE REFERENCE AML 648041 / REMOVED AND REPLACED CAPT WSHLD IN REFERENCE TO AMM 56-11-01 AND SDR SWIA2019030145587Bolt · broken(SUPPLEMENTAL INFORMATION) BROKEN TIE BOLTS. (INSP)MSO M2372664 SN FEB04-1083, 1 BOLT. LAST SHOP VISIT FAT M2346943 TIRE CHANGE, 1ST CYCLE ON THE BOLTS SINCE OVERHAUL. MS21250-08034 BOLTS USED ON THE WHEELS. RESULTS OF TEST OF P/N 5013641 SN FEB03-0776 4 WHEELSDR SWIA2018032044420Door Sill · corrodedSERVICE DOOR SILL HAS CORROSION AFT OF FORWARD FRAME. (C-CHECK) RO 03/17/2018. REMOVED AND REPLACED THE SERVICE DOOR SILL ANGLE WITH NEW PARTS & REPLACED THE SERVICE DOOR MACHINED ANGLE WITH NEW PART IAW SRM. LEAK CHECK GOOD.SDR SWIA2018032044419Stringer Splice · corrodedCORROSION FOUND ON STRINGER JOINT PIECE AT FS333.00 COMMON TO STRINGER 26R. (C-CHECK) RO 03/17/2018, REPLACED STRINGER JOINT PIECE AT FS333.00 COMMON TO STR 26R WITH NEW PART IAW SRM. LEAK CHECK GOOD.SDR SWIA2018032044418Vane · chafedRIGHT WING INBOARD FLAP VANE IS CHAFED ON THE I/B AND O/B EDGES. (C-CHECK) RO 03/17/2018, INSTALLED NEW RT WING INBD FLAP VANE L/E PANELS 684ET AND 684HT IAW SRM.SDR SWIA2018032044417Hinge · gougedPASSENGER DOOR HINGE, FUSELAGE SIDE, LAND NR 27 IS GOUGED. (C-CHECK) RO 03/17/2018, HINGE REPLACED IAW SRM.SDR SWIA201642094Intercostal · crackedPAX DOOR INTERCOSTAL CRACKED. REPLACED THE INTERCOSTAL IAW SRM. LEAK CHECK GOOD.SDR SWIA201642093Angle · corrodedPAX DOOR ANGLE HAS CORROSION. INSTALLED NEW PASSENGER DOOR ANGLE, PN 601R317052-1, IAW SRM. RESTORED FINISH, LEAK CHECK GOOD.SDR SWIA201642092Doubler · corrodedANTENNA DOUBLER FROM BS 295 TO 310 BETWEEN STRINGERS 26R AND 26L HAS CORROSION. INSTALLED NEW ANTENNA DOUBLER, RESTORED FINISH IAW SRM. LEAK CHECK GOOD.SDR SWIA201642091Intercostal · corrodedAVIONICS BAY DOOR SURROUND STRUCTURE, STR 26R INTERCOSTAL IS CORRODED. R & R INTERCOSTAL AT STR 26R, FS 364.00 WITH PN: SH670-32077-4 IAW SRM.SDR SWIA201642088Floor Panel · crackedFWD EQUIPMENT COMPARTMENT RT SIDE FLOOR PANEL HAS CRACK AT APPROXIMATELY FS 195.00. CUT OUT DAMAGE AND INSTALLED DOUBLER IAW EA.SDR SWIA201642090Door Sill · corrodedAFT BAG BIN DOOR CUTOUT LOWER DOOR SILL HAS CORROSION FROM BS 1000 - 1047. REPLACED THE LOWER DOOR SILL IAW SRM.SDR SWIA201642089Scuff Plate · dentedDENTS IN AFT CARGO SCUFF PLATE APPROXIMATELY 12" FROM AFT END. R & R IAW SRM.SDR SWIA201439241Battery Pack · inoperativeNUMEROUS EMERGENCY EXIT SIGNS INOPERATIVE. R & R NR 2 ELBP IAW AMM. OPS CHECKED GOOD.SDR SWIA201437816Bulb · burned outEMERGENCY LIGHT HAS A BULB BURNED OUT, REPLACED THE BULB.SDR SWIA201437817Bulb · burned outBULB BURNED OUT ON EMERGENCY LIGHT SIGN NEAR GALLEY SERVICE DOOR, REPLACED BULB.SDR SWIA201436152Light · inoperativeNR 4 EMERGENCY OVERHEAD LIGHT IS BURNED OUT. FLT 1366 RELAMPED.SDR SWIA201435971Pcu · failedOTBD FLT SPOILERONS CAUTION. ON ARRIVAL FIRST OFFICER DEPLOYED FLT SPOILERONS & WE IMMEDIATE ROLLED TO RIGHT, RECEIVED THE CAUTION MESSAGES & THE AUTOPILOT CORRECTED THE ROLL AFTER THE OTBD SPOILERONS WENT OFFLINE. FLT 5177 FOUND RT OTBD MULTI-FUNCTION SPOILSDR SWIA201435967Light · inoperativeEMERGENCY LIGHTS 2ND POD DOES NOT ILLUMINATE. FLT 4970 RELAMPED.SDR SWIA201334860Light · inoperativeEMERGENCY LIGHT ON PASSENGER BOARDING STAIRS IS BURNED OUT. FLT#5603 RELAMPED.SDR SWIA201334084Light · inoperativeNR 5 EMERGENCY OVERHEAD LIGHT IS BURNED OUT. SERVICE RELAMPED.SDR SWIA201333980Light · inoperativeNR 2 EMERGENCY OVERHEAD LIGHT IS BURNED OUT. FLT#6471 RELAMPED.SDR SWIA201333432Hydraulic Line · chafedCOMPLETE LOSS OF FLUID IN HYDRAULIC SYSTEM 3. LANDING WAS NORMAL. (FLT 6225) PERFORMED OPS CHECK OF NORMAL MLG EXTENSION AND RETRACTION. GEAR SWINGS GOOD. SERVICED 3 HYD SYSTEM. FOUND CHAFED 3 SYSTEM HYD LINE, REPLACED IAW AMM.SDR SWIA201333267Axle · corrodedCORROSION FOUND ON MLG AXLE NR 1 ROOT RADIUS. (C-CHECK) REPAIRED LEFT MLG AXLE NR 1 ROOT RADIUS IAW REO.SDR SWIA201333266Axle · corrodedCORROSION FOUND ON MLG AXLE NR 2 ROOT RADIUS. (C-CHECK) REPAIRED LEFT MLG AXLE NR 2 ROOT RADIUS IAW REO.SDR SWIA201333265Axle · corrodedCORROSION FOUND ON RIGHT MLG AXLE NR 3 ROOT RADIUS. (C-CHECK) REPAIRED RIGHT MLG AXLE NR 3 ROOT RADIUS IAW REO.SDR SWIA201333264Axle · corrodedCORROSION FOUND ON RIGHT MLG AXLE NR 4 ROOT RADIUS. (C-CHECK) REPAIRED RIGHT MLG AXLE NR 4 ROOT RADIUS IAW REO.SDR SWIA201333269Seat Track · corrodedLEFT FLOOR SEAT TRACK IS CORRODED AT FS 510 - 570. (C-CHECK) LEFT FLOOR SEAT TRACK AT FS 510.00 TO 570.00 OUT OF LIMITS PER REO. REPLACED SEAT TRACK FROM FS 469.0 TO FS 566.0, LBL 9.0 IAW AMM.SDR SWIA201333268Seat Track · corrodedLEFT SIDEWALL SEAT TRACK IS CORRODED AT FS 715 - 740. (C-CHECK) REMOVED CORROSION FROM LEFT SIDEWALL SEAT TRACK IAW REO.SDR SWIA201333270Floorbeam · corrodedFS 280 IS CORRODED BEYOND LIMITS AND REQUIRES REPLACEMENT. (C-CHECK) REMOVED AND REPLACED FS 280.0 FLOORBEAM IAW REO.SDR SWIA201232343Light · inoperativeEMERGENCY LIGHT OVERHEAD 2 AND 4 BURNED OUT. (FLT 5159) RELAMPED EMERGENCY LIGHT.SDR SWIA201232200Light · inoperativeNR 1 EMERGENCY OVERHEAD LIGHT BURNED OUT. (FLT 5209) RELAMPED EMERGENCY LIGHT.SDR SWIA201231581Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5607) RELAMPED EMERGENCY LIGHT.SDR SWIA201231202Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5642) RELAMPED EMERGENCY LIGHT.SDR SWIA201230143Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6497) RELAMPED EMERGENCY LIGHT.SDR SWIA201229887Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5297) RELAMPED EMERGENCY LIGHT.SDR SWIA201229632Light · inoperativeNR 6 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5385) RELAMPED EMERGENCY LIGHT.SDR SWIA201229450Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6479) RELAMPED EMERGENCY LIGHT.SDR SWIA201229287Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5162) RELAMPED EMERGENCY LIGHT.SDR SWIA201229156Light · inoperativeLEFT FORWARD EXTERIOR EMERGENCY EXIT LIGHT IS OUT. (FLT 5186) RELAMPED EMERGENCY LIGHT.SDR SWIA201128590Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 1355) RELAMPED EMERGENCY LIGHT.SDR SWIA201128482Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 15 IS OUT. (FLT 6356) RELAMPED EMERGENCY LIGHT.SDR SWIA201127962Stiffener · crackedC-CHECK, LEFT FS 280 BULKHEAD STIFFENER IS CRACKED. REPAIRED PER SRM.SDR SWIA201127963Crossbeam · crackedC-CHECK, FS 280 CROSSBEAM HAS CORROSION AND IS CRACKED. REPAIRED PER REO.SDR SWIA201127399Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5446) RELAMPED EMERGENCY LIGHT.SDR SWIA201126625Light · inoperativeOVERHEAD EMERGENCY LIGHT ABOVE ROW 9 IS OUT. (FLT 5462) RELAMPED EMERGENCY LIGHT.
Back to N732SK