N607SK
Service difficulty reports · 163
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 = 'N607SK' 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 = 'N607SK' 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 SWIA2018032744428Post · corrodedBS 280, LBL11 POST BEHIND BULKHEAD WEB IS CORRODED. REPAIRED IAW REO.SDR SWIA2018032744426Landing · chafedPAX DOOR PIANO HINGE LANDS #2, 3, 4, 5, 7, 8, & 27 HAVE CHAFING DAMAGE ON FUSELAGE SIDE OF HINGE. (C-CHECK) RO: 03/24/2018 REMOVED PASSENGER DOOR HINGE FROM THE FUSELAGEAND REPLACED WITH NEW REPLACEMENT HINGE REFERENCING IAW SRM.SDR SWIA2018032744425Floorbeam · corrodedBS 280 FLOORBEAM CORRODED. REMOVED AND REPLACED THE FLOORBEAM ANGLE IAW SRM.SDR SWIA2018032744424Stringer · corrodedMAIN AVIONICS BAY STRINGER 26R FROM BS 333 TO 364 CORRODED. REMOVED AND REPLACED THE STRINGER IAW SRM.SDR SWIA2018032744423Frame · corrodedMAIN AVIONICS BAY BS 349 FRAME CORRODED BETWEEN STRINGERS 26 AND 27R. REMOVED AND REPLACED THE FRAME SECTOR IAW SRM.SDR SWIA2018032744422Stringer · corrodedMAIN AVIONICS BAY STRINGER 25L, BS 333 - 349 CORRODED. REMOVED AND REPLACED THE STRINGER IAW SRM.SDR SWIA201642049Stringer · corrodedAVIONICS BAY, STR 27 CORRODED BETWEEN FS 333 AND FS 349. REPLACED AVIONICS BAY, STR 27 BETWEEN FS 333-FS 349 IAW SRM. PRESSURE CHECK GOOD IAW AMM.SDR SWIA201642048Stringer · corrodedAVIONICS BAY, FOUND CORROSION ON STR 26R BETWEEN FS 319 AND FS 333. R & R STR 26 RT AT FS 280.00 TO 333.00 IAW SRM. PERFORMED LEAK TEST OF FASTENERS THAT GO THROUGH THE SKIN AT STR 26R BETWEEN FS 319 AND FS 333 IAW AMM, NO LEAKS NOTED.SDR SWIA201642047Skin · chafedLT INBD FLAP VANE PANEL 584ET HAS A CHAFE. R & R PANEL 584ET IAW SRM.SDR SWIA201642046Floor Support · corrodedAFT BAGGAGE BAY DOOR- FLOOR SILL HAS CORROSION. R & R THE AFT BAGGAGE BAY DOOR FLOOR SILL IAW SRM.SDR SWIA201642041Frame · corrodedREPAIR LOWER FRAME SECTION AT FS 295 BETWEEN STR 26L-STR 26R DUE TO CORROSION. REPLACED LOWER FRAME SECTION AT FS 295 BETWEEN STR 26L-STR 26R IAW REO. NO LEAKS NOTED.SDR SWIA201642040Frame · corrodedREPAIR LOWER FRAME SECTION AT BS 310 BETWEEN STR 26L-STR 26R DUE TO CORROSION. R & R SECTION OF FRAME 310 BETWEEN STR 25R TO STR 23L IAW REO. PERFORMED LEAK CHECK AT FRAME IAW AMM. LEAK CHECK WAS GOOD.SDR SWIA201642045Frame · corrodedAVIONICS BAY, FRAME BS 310 CORRODED STR 26L AND STR 26R. COMPLIED WITH REPAIR IAW SRM.SDR SWIA201642044Stringer Splice · corrodedAVIONICS BAY, STRINGER SPLICE 25R FS 331 AND FS 335 CORRODED. REPLACED STR SPLICE 25R PN SH670-32429-4 AT FS 331.00 TO 335.00 IAW SRM. PRESSURE CHECK GOOD.SDR SWIA201642043Intercostal · corrodedAVIONICS BAY, INTERCOSTAL STR 27R CORRODED FS 364 AND FS349. COMPLETED REPAIRS IAW STS EA COMPLETED PRESSURE CHECK OF INTERCOSTAL IAW AMM. LEAK CHECK GOOD.SDR SWIA201642042Fairing · chafedRIGHT WING FLAP FAIRING PANEL 684EB IS CHAFED. R & R SERVICEABLE PANEL 684EB, PN CC670-14177-2 IAW SRM.SDR SWIA201436608Sill · corrodedCORROSION FOUND ON SERVICE DOOR SILL AT APPROXIMATELY FS 329. C CHECK REPAIRED IAW SRM & REO.SDR SWIA201436607Angle · corrodedTWO EACH LOWER SILL ANGLES ATTACHED TO WEB FLOOR PROTECTORS AT APPROXIMATELY FS 329 & FS 337 HAVE CORROSION. C CHECK INSTALLED TWO EACH REPLACEMENT LOWER SILL ANGLES TO RESPECTIVE WEB FLOOR PROTECTORS IAW SRM.SDR SWIA201436606Channel · crackedPANEL 195DL AFT STRAP CHANNEL CRACKED. C CHECK REPLACED CRACKED AFT STRAP CHANNEL IAW SRM & AMM.SDR SWIA201436605Strap · crackedCRACK NOTED ON STRAP ASSEMBLY PN CC670-39171-1 IN THE AREA OF THE FIRST RIVET HOLE OF THE AFT STRAP CHANNEL. C CHECK REPLACED CRACKED STRAP ASSEMBLY IAW SRM.SDR SWIA201436612Support Angle · corrodedSERVICE DOOR, SILL TO FLOOR SUPPORT ANGLE CORRODED. C CHECK REPLACED SERVICE DOOR SILL TO FLOOR ANGLE IAW SRM.SDR SWIA201436611Angle · corrodedSERVICE DOOR, CORROSION ON DOOR SEAL ANGLE LOWER AFT AREA. C CHECK REPLACED THE SERVICE DOOR FITTING SEAL STRIKER IAW SRM.SDR SWIA201436610Support Angle · corrodedPAX DOOR SILL TO FLOOR SUPPORT ANGLE IS CORRODED. C CHECK REPLACED PAX DOOR SILL PLATE ANGLE IAW SRM.SDR SWIA201436609Angle · corrodedPAX DOOR MID CAP ANGLE CORRODED. C CHECK R & R PAX DOOR MID CAP ANGLE PN SH670-31825-7 IAW SRM.SDR SWIA201436613Sill · corrodedRT FLOOR SILL CORRODED AT FS 280. C-CHECK R & R RT FLOOR SILL AT FS 280 IAW SRM.SDR SWIA201436075Printed Ckt Board · failedEMERGENCY LIGHTS REMAIN ON IN ARM MODE ON FLIGHT OFFICER`S & FLIGHT ATTENDANT`S STATION, OFF WITH POWER ON AIRCRAFT. FLT4714 REPLACED PRINTED CIRCUIT BOARD 5 FROM JB-11 IAW AMM.SDR SWIA201232495Light · inoperativeEMERGENCY OVERHEAD LIGHT SECOND FROM REAR BURNED OUT. (FLT 4574) RELAMPED EMERGENCY LIGHT.SDR SWIA201232269Light · inoperativeSECOND OVERHEAD EMERGENCY LIGHT FROM THE BACK BURNED OUT. (FLT 4770) RELAMPED EMERGENCY LIGHT.SDR SWIA201231820Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 10 IS OUT. (FLT 4794) RELAMPED EMERGENCY LIGHT.SDR SWIA201231576Light · inoperativeSERVICE DOOR EMERGENCY EXIT SIGN HAS ONE BULB INOPERATIVE AND FIXTURE BASE IS BROKEN. (SERVICE) REPLACED THE SERVICE DOOR EXIT SIGN ASSEMBLY PER CRJ MM.SDR SWIA201231526Intercostal · corrodedCORROSION ON INTERCOSTAL AT STRINGER 27R, 27L, AND 26L, ALL JUST FORWARD OF FS 364 OF THE AVIONICS BAY DOOR. (C-CHECK) REPLACED INTERCOSTAL AT STRINGER 27R, REMOVED CORROSION ON INTERCOSTAL STRINGER 27L TO 26L, ALL JUST FORWARD OF FS 364 OF THE AVIONICS BAY SDR SWIA201231527Sill · corrodedRIGHT FLOOR SILL CORRODED FROM FS 280.00 TO FS 290.00. (C-CHECK) REPLACED RIGHT FLOOR SILL FROM F.S 280.00 - 310.00 IN REFERENCE TO CRJ700 SRM.SDR SWIA201231401Crossbeam · crackedLEFT AND RIGHT FS 280 CROSSBEAM IS CRACKED. (C-CHECK) REPAIR PER REO.SDR SWIA201231324Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4790) RELAMPED EMERGENCY LIGHT.SDR SWIA201231230Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4507) RELAMPED EMERGENCY LIGHT.SDR SWIA201231090Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4556) RELAMPED EMERGENCY LIGHT.SDR SWIA201231048Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4801) RELAMPED EMERGENCY LIGHT.SDR SWIA201230541Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4662) RELAMPED EMERGENCY LIGHT.SDR SWIA201230414Light · inoperativeOVERHEAD EMERGENCY LIGHTS AT ROW 2 AND 12 ARE OUT. (FLT 4668) RELAMPED EMERGENCY LIGHTS.SDR SWIA201229827Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4716) RELAMPED EMERGENCY LIGHT.SDR SWIA201229696Lamp · burned outFLT 4668, THE 4TH FROM REAR OVERHEAD EMERGENCY LIGHT IS OUT. RELAMPED EMERGENCY LIGHT.SDR SWIA201229530Light · inoperativeNR 1 CEILING EMERGENCY LIGHT INOPERATIVE. (FLT 4747) RELAMPED EMERGENCY LIGHT.SDR SWIA201128967Light · inoperativeTHE 4TH OVERHEAD EMERGENCY LIGHT INOPERATIVE. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201128484Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4611) RELAMPED EMERGENCY LIGHT.SDR SWIA201128125Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 10 DOES NOT ILLUMINATE. (FLT 4634) RELAMPED EMERGENCY LIGHT.SDR SWIA201127506Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4644) RELAMPED EMERGENCY LIGHT.SDR SWIA201127223Wire · unsecureCOULD NOT OPEN MCD FROM INSIDE. (FLT 4577) RESECURED WIRING TO PAX DOOR.SDR SWIA201126728Light · inoperativeTHE 2ND FROM AFT OVERHEAD EMERGENCY LIGHT BULB IS BURNT OUT. (FLT 4716) RELAMPED EMERGENCY LIGHT.SDR SWIA201126595Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 9 IS OUT. (FLT 4684) RELAMPED EMERGENCY LIGHT.SDR SWIA201125813Light · inoperativeSECOND TO LAST OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4569) RELAMPED EMERGENCY LIGHT.
Back to N607SK