N802SK
Service difficulty reports · 338
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 = 'N802SK' 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 = 'N802SK' 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 SWIA202054768Striker · corrodedGALLEY SERVICE DOOR LOWER SILL STRIKER IS CORRODED, MARKED. C-CHECK RO 12/26/2020. REPLACED GALLEY SERVICE DOOR LOWER SILL STRIKER, REF DRAWING AND CRJ900 SRM. LEAK CHECK GOOD. SEE CONTINUE CARD FOR DETAILS.SDR SWIA202054767Plate · corrodedFORWARD BAGGAGE BAY DOOR JOINT PLATE, FS 562.36 STGR 25, HAS CORROSION ON MULTIPLE AREAS, MARKED. C-CHECK RO 12/26/2020. FORWARD BAGGAGE BAY DOOR JOINT PLATE, FS 562.36 STGR 25. CORROSION REMOVED, BLENDED, NDT'D, MEASURED, ENGINEERING ORDER ASSIGNED, FASTENSDR SWIA202054766Plate · corrodedFORWARD BAGGAGE BAY DOOR JOINT PLATE, FS 519.64 STGR 25, HAS CORROSION ON MULTIPLE AREAS, MARKED. C-CHECK RO 12/26/2020. FORWARD BAGGAGE BAY DOOR JOINT PLATE, FS 519.64 STGR 25. CORROSION REMOVED, BLENDED, NDT'D, MEASURED, ENGINEERING ORDER ASSIGNED, FASTENSDR SWIA202054765Stringer · corrodedFORWARD BAGGAGE BAY DOOR JOINT PLATE LOWER LONGERON, FS 519.64-FS 562.36 STGR 25, HAS CORROSION ON MULTIPLE AREAS, MARKED. C-CHECK RO 12/26/2020. FORWARD BAGGAGE BAY DOOR JOINT PLATE LOWER LONGERON, FS 519.64-FS 562.36 STGR 25. CORROSION REMOVED, BLENDED, NSDR SWIA202054835Bolt · corrodedRT AFT EMERGENCY DOOR LATCH MECHANISM ATTACHING HARDWARE CORRODED, MARKED. C-CHECK RO 12/26/2020. REMOVED 5 BOLTS NUTS AND WASHERS ON RT AFT EMERGENCY DOOR LATCH MECHANISM ATTACHING HARDWARE, IAW CRJ900 AMM. INSTALLED 5 BOLTS NUTS AND WASHER ON RT AFT EMERGSDR SWIA202054834Bolt · corrodedLT FWD EMERGENCY DOOR LATCH MECHANISM ATTACHING HARDWARE CORRODED, MARKED. C-CHECK RO 12/26/2020. REMOVED 6 BOLTS NUTS AND WASHERS ON LT FWD EMERGENCY DOOR LATCH MACHANISM ATTACHING HARDWARE, IAW CRJ900 AMM. INSTALLED 6 BOLTS NUTS AND WASHER ON LT FWD EMERGSDR SWIA202054833Bolt · corrodedLT AFT EMERGENCY EXIT HARDWARE BELOW INNER HANDLE CORRODED. C-CHECK RO 12/26/2020. REMOVED 6 BOLTS NUTS AND WASHERS ON LT AFT EMER DOOR LATCH MACHANISM ATTACHING HARDWARE, IAW CRJ900 AMM. INSTALLED 6 BOLTS NUTS AND WASHER ON LT AFT EMERGENCY DOOR LATCH MECHSDR SWIA202054880Housing · chafedAFT CARGO DOOR OUTER HANDLE HOUSING HAS CHAFE AT BOTTOM. REMOVED AND INSTALLED NEW AFT BAGGAGE BAY DOOR HANDLE AND HANDLE HOUSING, REF CRJ900 AMM AND CRJ900 AMM. ALL ASSOCIATED CHECKS C/W, NO DEFECTS NOTED AT THIS TIME. SEE CONTINUATION CARD FOR FURTHER DETSDR SWIA202054832Bolt · corrodedRT FWD EMERGENCY EXIT DOOR HARDWARE CORRODED INSIDE BELOW INTERNAL HANDLE. C-CHECK RO 12/26/2020. REMOVED 6 BOLTS NUTS AND WASHERS ON RT FWD EMERGENCY DOOR LATCH MACHANISM ATTACHING HARDWARE, IAW CRJ900 AMM. INSTALLED 6 BOLTS NUTS AND WASHER ON RT FWD EMERGSDR SWIA202054831Door Sill · corrodedSERVICE DOOR LOWER SILL ALL ATTACH ANGLES AND LATCH FITTINGS CORRODED. C-CHECK RO 12/26/2020. REPLACED SERVICE DOOR LOWER SILL ALL ATTACH ANGLES AND LATCH FITTINGS, REF CRJ900 SRM AND CRJ900 AMM.SDR SWIA202054830Angle · corrodedPAX DOOR MID CAP ANGLE CORRODED. C-CHECK RO 12/26/2020. PAX DOOR MID CAP ANGLE HAS 100% EXFOLIATION. OUT OF LIMITS, REF CRJ900 SRM. INSTALLED NEW PAX DOOR MID CAP ANGLE, IAW CRJ 900 SRM AND BOMBARDIER DWG.SDR SWIA202054764Door Sill · corrodedSERVICE DOOR LOWER SILL CORRODED. C-CHECK RO 12/26/2020. REPLACED SERVICE DOOR LOWER SILL ANGLE, REF CRJ 900 SRM AND BOMBARDIER DWG.SDR SWIA202054763Door Sill · corrodedPAX DOOR LOWER SILL ANGLE CORRODED. C-CHECK RO 12/26/2020. PAX DOOR LOWER SILL HAS 100% EXFOLIATION, OUT OF LIMITS, REF CRJ900 SRM. INSTALLED NEW PAX DOOR LOWER SILL ANGLE, IAW CRJ 900 SRM AND BOMBARDIER DWG.SDR SWIA202054879Structure · chafedRT INBOARD FLAP APPROXIMATELY WS 147.50 CHAFED, MARKED. C-CHECK RO 12/26/2020. REPAIRED RT INBOARD FLAP AT APPROXIMATELY WS147.50 REFERENCING REO.SDR SWIA202054878Skin · chafedLT INBOARD FLAP AT APPROXIMATELY WS 147.50 CHAFED, MARKED. C-CHECK RO 12/26/2020. REPAIRED LT INBOARD FLAP AT APPROXIMATELY WS 147.50, REF REO. ALL STEPS COMPLETED. SEE CONTINUE CARD FOR DETAILS.SDR SWIA202054877Skin · chafedLT INBOARD FLAP AT APPROXIMATELY WS 38.0 CHAFED, MARKED. C-CHECK RO 12/26/2020. REPAIRED LT INBOARD FLAP AT APPROXIMATELY WS 38.0, REF REO ALL STEPS COMPLETED. SEE CONTINUE CARD FOR DETAILS.SDR SWIA202054762Skin · dentedADM-802SK NR 5016- DENT JUST FORWARD OF MID CARGO DOOR, 3/4 X 3/4 .008 DEEP. PLOT, MAP, AND EVALUATE DAMAGE IF WITHIN ACCEPTABLE LIMITS OR REWORKED, ELIMINATE EVIDENCE USING STANDARD A/C PRACTICES. C-CHECK RO 12/26/2020. INSTALLED REPAIR DOUBLER. REWORK WISDR SWIA2020091652495Skin · crackedFOUND CRACK INDICATION ASSOCIATED WITH THE DENT ON THE LT FUSELAGE JUST FWD OF FS 517.00 BETWEEN STGR 16L AND STGR 17L. FILED CLOSED. REPAIRED DENT ON THE LT FUSELAGE JUST FWD OF FS 517.00 BETWEEN STGR 16L AND STGR 17L IN ACCORDANCE WITH REO.SDR SWIA2018080644971Stringer · chafedSTRINGER 7L CHAFED BETWEEN BS 1144 - 1162. REPAIRED THE STRINGER IAW REO.SDR SWIA201743070Angle · corrodedFOUND CORROSION ON ANGLE, LBL 11, WL 71. INSTALLED A NEW ANGLE IAW REO.SDR SWIA201743069Strap · corrodedCORROSION FOUND ON BS 280 UPPER SPLICE STRAP BETWEEN LBL 12 & RBL 12, (C-CHECK) RO: 02/16/2017 REMOVED AND REPLACED THE FS 280.00 BEAM UPPER SPLICE STRIP IAW SRM.SDR SWIA201743068Stringer · corrodedMAIN AVIONICS COMPARTMENT, STRINGER 27 HAS CORROSION BETWEEN BS 319 - 349. REMOVED AND REPLACED IAW SRM.SDR SWIA201743062Skin · dentedTWO DENTS ON FUSELAGE SKIN BETWEEN BS 421 - 453, STRINGERS 16 - 21L. REPAIRED THE SKIN IAW REO.SDR SWIA201743053Floorbeam · corrodedBS 280 FLOORBEAM CORRODED. REMOVED AND REPLACED THE FLOORBEAM IAW SRM.SDR SWIA201743067Cleat · corrodedPAX DOOR CLEAT BS 313.IS CORRODED. REMOVED AND REPLACED THE CLEAT IAW SRM.SDR SWIA201743066Intercostal · corrodedMAIN AVIONICS COMPARTMENT, STRINGER 26L INTERCOSTAL HAS CORROSION BETWEEN BS 349 - 364. REMOVED AND REPLACED THE INTERCOSTAL.IAW SRM.SDR SWIA201743065Stringer Splice · corrodedMAIN AVIONICS COMPARTMENT, STRINGER SPLICE 25R AT BS 333 HAS CORROSION. REMOVED AND REPLACED THE STRINGER SPLICE IAW SRM.SDR SWIA201743064Stringer · corrodedMAIN AVIONICS COMPARTMENT, STRINGER 26R HAS CORROSION BETWEEN BS 295 - 310. REMOVED AND REPLACED THE STRINGER IAW SRM.SDR SWIA201743063Antenna · corrodedMAIN AVIONICS COMPARTMENT, LOWER TCAS OMNI-DIRECTIONAL ANTENNA HAS CORROSION. REMOVED AND REPLACED THE ANTENNA IAW SRM. CHECKED GOOD.SDR SWIA201743061Panel · chafedRT WING PANEL 684ET CHAFED. A NEW PANEL WA INSTALLED IAW SRM.SDR SWIA201743060Floorbeam · corrodedFLOORBEAM ANGLE HAS CORROSION BS 280 LBL 9.04 TO RBL 9.04. REMOVED AND REPLACED FLOORBEAM ANGLE IAW SRM.SDR SWIA201743059Crossbeam · corrodedBS 280 CROSSBEAM HAS CORROSION AT RBL 9.04 TOP SIDE. CROSSBEAM WAS REMOVED AND REPLACED IAW SRM.SDR SWIA201743058Crossbeam · corrodedFS 280 CROSSBEAM HAS CORROSION AT LBL 9.04. REMOVED AND REPLACED THE CROSSBEAM IAW SRM.SDR SWIA201743057Frame · corrodedAVIONICS BAY, FRAME AT BS 349 BETWEEN STRINGERS 26 & 27L CORRODED. REMOVED AND REPLACED THE FRAME IAW SRM. ALL CHECKED GOOD.SDR SWIA201743056Frame · corrodedAVIONICS BAY, FRAME AT BS 295 BETWEEN STRINGERS 26 & 27L CORRODED. PERFORMED A FRAME SPLICE REPAIR IAW REO. ALL CHECKED GOOD,SDR SWIA201743055Panel · chafedLEFT WING PANEL 522CB IS CHAFED. A NEW PANEL WAS INSTALLED IAW SRM.SDR SWIA201743054Panel · chafedPANEL 684GB IS CHAFED. A NEW PANEL WAS INSTALLED IAW SRM.SDR SWIA201541699Proximity Sensor · out of adjustGEAR WOULD NOT RETRACT. CLOSED, ADJUSTED NLG PROXIMITY SENSOR PX08 IAW AMM. PERFORMED OPS CHECK AND EMERGENCY EXTENSION IAW AMM. OPS CHECKS GOOD. PERFORMED OPS CHECK OF LAND GEAR PROXIMITY SENSOR. OPS CHECK GOOD.SDR SWIA201540967Hinge · gougedGOUGE IN AFT PAX DOOR PIANO HINGE FUSELAGE LUG LANDING WHERE THE HINGE SECURING ROLL PIN HAS MADE CONTACT WITH THE SKIN, MARKED, C-CHECK, RO 4/1/15, AFT PAX DOOR PIANO HINGE FUSELAGE LUG LANDING REPAIRED REF STS EA.SDR SWIA201540966Door Sill · corrodedINNER CHORD FS1000 TO FS1015 MATTING TO LT FUSELAGE AFT BAGGAGE BAY DOOR SILL LOWER SURFACE HAS CORROSION AT NUTPLATES AREAS. C-CHECK, RO 4/1/15, BLENDED OUT CORROSION REF SRM PERFORMED UT THICKNESS REF NDTM. RECEIVED STS EA NO DEFECTS REF ATTACHED NDT REPOSDR SWIA201540965Door Sill · corrodedINNER CHORD FS 1015.00 TO FS 1031.00 MATTING TO LT FUSELAGE AFT BAGGAGE BAY DOOR SILL LOWER SURFACE HAS CORROSION AT NUTPLATES AREAS. C-CHECK, RO 4/1/15, BLENDED OUT CORROSION REF SRM PERFORMED UT THICKNESS REF NDTM MINIMUM THICKNESS .060" IN ALL BLENDED AREASDR SWIA201540964Door Sill · corrodedINNER CHORD, FS 1031.00 TO FS 1047.00 MATTING TO LT FUSELAGE AFT BAGGAGE BAY DOOR SILL LOWER SURFACE HAS CORROSION AT NUTPLATES AREAS. C-CHECK, RO 4/1/15, BLENDED OUT CORROSION REF SRM. PERFORMED UT THICKNESS REF NDTM. RECEIVED STS EA. PERFORMED VISUAL INSPECSDR SWIA201540959Angle · chafedAFT PRESSURE BULKHEAD AFT SIDE DOUBLING ANGLE, VERTICAL STIFFENER, AT BL 0.0 HAS CHAFE AT LOWER FWD END. CAUSED BY CONTACT WITH FLOTATION VALVE MIGRATED HINGE PIN, CAMP 11987372, JOB 91506171, OP 121, C-CHECK RO 4/1/15. COMPLIED WITH REPAIR OF AFT PRESSURE BSDR SWIA201540962Door Sill · corrodedLEFT FUSELAGE AFT BAGGAGE BAY DOOR SILL HAS CORROSION UNDER FLOOR PANEL 281JLF. C-CHECK, RO 4/1/15. BLENDED OUT CORROSION ON THE AFT BAGGAGE BAY DOOR LOWER SILL UPPER SURFACE REF SRM. AFT BAGGAGE BAY DOOR SILL ORIGINAL MATERIAL THICKNESS IS 0.063" REF SRM ASDR SWIA201540958Hinge Pin · migratedFLOTATION VALVE HINGE PIN MIGRATED FROM HINGE. C-CHECK, RO 4/1/15, INSTALLED HITCH PINS AND WASHERS TO PREVENT ROTATION VALVE HINGE PIN FROM MIGRATING REF STS EA.SDR SWIA201540969Floor Skin · crackedFWD EQUIPMENT BAY FLOOR SKIN CRACKED AT LT FS 193.00 FRAME CUTOUT. C-CHECK, RO 4/1/15. REPAIRED FORWARD EQUIPMENT BAY FLOOR SKIN CRACKED AT LT FS193.00, FRAME CUTOUT REF REO COMPLIED WITH ST, SRM RII. COMPLETED FORM 337. WEIGHT CHANGE +0.036 LBS.SDR SWIA201540968Floor Skin · crackedFWD EQUIPMENT BAY FLOOR SKIN CRACKED AT RT FS 193.00 FRAME CUTOUT. C-CHECK, RO 4/1/15, REPAIRED FORWARD EQUIPMENT BAY FLOOR SKIN CRACKED AT RT FS193.00, REF STS EA. COMPLIED WITH ST CL600-2024 SRM, RII. COMPLETED FORM 337. WEIGHT CHANGE +0.23 LB.SDR SWIA201540963Skin · chafedLEFT AILERON L/E UPPER SIDE IS CHAFE, C-CHECK, RO 4/1/15. REMOVED CHAFE DAMAGE ON LT AILERON UPPER L/E. ORIGINAL MATERIAL THICKNESS IS .090", REMAINING MATERIAL AFTER BLEND OUT IS .083", TOTAL MATERIAL REMOVED IS .007". REPAIR FOUND TO BE WITHIN LIMTS. REF RSDR SWIA201540961Skin · corrodedPAX DOOR FWD STRUCTURE FOR INNER SKIN HAS CORROSION AROUND FWD UPPER TENSION FITTING. REPAIRED CORROSION IN REF TO STS EA COMPLETED OPS CHECK OF PASSENGER DOOR IN REF TO AMM.SDR SWIA201540960Skin · chafedRT AILERON UPPER L/E IS CHAFED. C-CHECK, RO 4/1/15, REMOVED DAMAGE FROM RT AILERON UPPER L/E. ORIGINAL MATERIAL THICKNESS IS .090", REMAINING MATERIAL AFTER BLEND OUT IS .088", TOTAL MATERIAL REMOVED IS .002". REPAIR FOUND TO BE WITHIN LIMTS. REF REO AND SR
Back to N802SK