N804SK
Service difficulty reports · 289
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 = 'N804SK' 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 = 'N804SK' 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 SWIA2017090843740Intercostal · corrodedINTERCOSTAL JUST LEFT OF STRINGER 27 HAS CORROSION, BETWEEN FRAMES BS 349 AND BS 364. INSTALLED A NEW INTERCOSTAL IAW SRM.SDR SWIA2017090843739Stringer · corrodedSTRINGER 27 HAS CORROSION BETWEEN BS 333 AND 349. INSTALLED A NEW STRINGER IAW SRM.SDR SWIA2017090843738Stringer · corrodedSTRINGER 25L HAS CORROSION AROUND FASTENERS BETWEEN BS 333 AND 349. INSTALLED A NEW STRINGER IAW SRM.SDR SWIA2017090843737Stringer · corrodedSTRINGER 25R HAS CORROSION AROUND FASTENERS BETWEEN BS 333 AND 349. REMOVED AND REPLACED THE STRINGER IAW SRM.SDR SWIA2017090843736Frame · corrodedFRAME BS 349 HAS CORROSION BETWEEN STRINGERS 26L AND 26R. REMOVED AND REPLACED THE LOWER FRAME IAW DWG SH690-31350, REV L IAW SRM.SDR SWIA2017090843735Frame · corrodedFRAME BS 333 HAS CORROSION BETWEEN STRINGERS 26L AND 26R. COMPLIED WITH REPAIR TO THE FRAME IAW REO.SDR SWIA201709083731Stringer · corrodedSTRINGER 26L HAS CORROSION BETWEEN BS 333 AND 364. REMOVED AND INSTALLED A NEW STRINGER IAW SRM.SDR SWIA201743730Stringer · corrodedSTRINGER 26R HAS CORROSION BETWEEN BS 333 AND 349. REMOVED AND INSTALLED A NEW STRINGER IAW SRM.SDR SWIA201743734Floorbeam · corrodedBS 280 FLOORBEAM ANGLE UPPER SURFACE LBL TO RBL 9 HAS CORROSION. INSTALLED REPLACEMENT FLOORBEAM ANGLE IAW SRM.SDR SWIA201743733Floorbeam · corrodedBS 280 FLOORBEAM BETWEEN LBL AND RBL 9 HAS CORROSION ON THE UPPER SURFACE. REMOVED AND REPLACED THE FLOORBEAM IAW SRM.SDR SWIA201743602Pseu · failedGEAR DISAGREE WARNING, WOW INPUT CAUTION, PROXIMITY SYS CHANNEL CAUTION. IAW QRH SLOWED ACFT AND LOWERED GEAR. RECEIVED A 3 DOWN AND GREEN INDICATION AND DIVERTED. REMOVED AND REPLACED PSEU IAW AMM. PERFORMED GEAR SWINGS OPS CHECKED GOOD.SDR SWIA201743442Actuator · failedRETURNED TO THE FIELD WHEN THE NOSE GEAR DID NOT RETRACT. REMOVED AND REPLACED THE NOSE GEAR RETRACT ACTUATOR, OPS CHECKED GOOD.SDR SWIA201541447Skin · not reportedREPLACE PAX DOOR INNER SKIN. C-CHECK, RO: 10/03/2015 R & R PASSENGER DOOR INNER SKIN, PN 601R318024-13 IAW SRM.SDR SWIA201541448Frame · crackedFRAME BS 235 BELOW PILOTS WINDOW FRAME CRACKED. C-CHECK, REPAIRED THE FRAME IAW EA.SDR SWIA201540592Skin · dentedLARGE DENT ON LEFT INBD FLAP BETWEEN FLAP STA 15.00 AND FLAP STA 25.00 THAT EXTENDS OVER CLOSING RIB AT FLAP STA 22.5, INTERCOSTAL SPAR AND T/E ON LOWER SKIN. ACFT IS STRUCTURALLY ACCEPTALE AS DESCRIBED IN REO. R & R THE LT INBD FLAP PANEL IN REFERENCE TO ASDR SWIA201439166Flashlight · inoperativeFLIGHT DECK FLASHLIGHTS INOPERATIVE. R & R FLIGHT DECK FLASHLIGHTS IAW AMM.SDR SWIA2014061238142Lamp · inoperativeRT OVERWING AFT LOWER EMERGENCY EXIT EXIT SIGN INOPERATIVE. R & R RT OVERWING AFT LOWER EMERGENCY EXIT SIGN LAMPS IAW AMM.SDR SWIA201436662Light · inoperativeEMERGENCY OVERHEAD EXIT SIGN IS BURNED OUT. FLT 4462 RELAMPED, PN 6839.SDR SWIA201335378Axle · corrodedMLG NR 1 PISTON AXLE CORRODED. C-CHECK REPAIRED MLG NR 1 PISTON AXLE IAW REO.SDR SWIA201335377Axle · corrodedMLG NR 2 PISTON AXLE CORRODED. C-CHECK REPAIRED MLG NR 2 PISTON AXLE IAW REO.SDR SWIA201335376Axle · corrodedMLG NR 3 PISTON AXLE CORRODED. C-CHECK REPAIRED MLG NR 3 PISTON AXLE IAW REO.SDR SWIA201335375Axle · corrodedMLG NR 4 PISTON AXLE CORRODED. C-CHECK REPAIRED MLG NR 4 PISTON AXLE IAW REO.SDR SWIA201335379Shelf · crackedFWD EQUIPMENT BAY SHELF SKIN UNDER ADG RESTOW PUMP CRACKED. C-CHECK TYPE 2 REPAIR, ON FWD EQUIPMENT BAY RT SHELF SKIN WEB UNDER ADG RESTOW PUMP IAW REO.SDR SWIA201335385Seat Track · corrodedSIDE SEAT RAIL AT RT FS 677 TO FS 720 HAS SURFACE CORROSION. C-CHECK REPAIRED SIDE SEAT RAIL AT RT FS 677.00 TO FS 720.00 BY BLENDING IAW REO.SDR SWIA201335384Seat Track · corrodedRT SIDE CENTER SEAT RAIL FROM FS 440 TO FS 480 HAS LIGHT SURFACE CORROSION. C-CHECK REPLACED RT SIDE SEAT TRACK FROM FS 440 TO 480 IAW REO.SDR SWIA201335383Sill · corrodedFLOOR SILL FS349 TO FS364, AFT OF SERVICE DOOR HAS SURFACE CORROSION. C-CHECK REPAIRED AFT SERVICE DOOR FLOOR SILL FS349 TO FS364 IAW EA.SDR SWIA201335382Seat Track · corrodedFLOOR SEAT TRACK RT FS 477 TO FS581 HAS CORROSION. C-CHECK REPLACED RT SIDE SEAT TRACK FROM FS 477 TO FS581 IAW REO.SDR SWIA201335381Seat Track · corrodedFLOOR SEAT TRACK RT FS581 TO FS661+32 HAS CORROSION. C-CHECK REPAIRED SEAT RAIL AT RT FS 581.00 - FS 661.00 +32 BY BLENDING IAW REO.SDR SWIA201335380Seat Track · corrodedFLOOR SEAT TRACK LT FS597 TO FS661+32 HAS CORROSION. C-CHECK REPAIRED SEAT RAIL AT LT FS 597.00 - FS 661.00 +32 BY BLENDING IAW REO.SDR SWIA201335386Sill · gougedAFT CARGO LOWER SILL HAS GOUGES. C-CHECK REPAIRED AFT CARGO LOWER DOOR SILL IAW REO.SDR SWIA201335387Sill · corrodedRT FLOOR SILL AT FS 280 TO FS 319 CORRODED. C-CHECK R & R RT FLOOR SILL AT FS 280 TO FS319 IAW SRM.SDR SWIA201334538Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 11 IS BURNED OUT. FLT#4743 RELAMPED.SDR SWIA201333336Control Unit · failedSMOKE AND SMELL OF BURNING PLASTIC UPON OPENING THE AFT CARGO COMPARTMENT DOOR. (FLT 4800) REPLACED AACU AND ACPU REPLACED. P/N: P12954 S/N ON: 1295411265 S/N OFF: 1295411710 P/N: P12955 S/N ON: 1295511761 S/N OFF: 1295510543.SDR SWIA201333217Light · inoperativeONE LAMP IS BURNED OUT IN MAIN CABIN DOOR EMERGENCY EXIT LIGHT. (FLT 4556) RELAMPED EMERGENCY LIGHT.SDR SWIA201332837Light · inoperativeNR 1 EMERGENCY OVERHEAD LIGHT BURNED OUT. (FLT 4781) RELAMPED EMERGENCY LIGHT.SDR SWIA201332688Connector · defectiveGOT ANTI-ICE DUCT WARNING MESSAGE, MESSAGE CHANGED TO ANTI-ICE DUCT CAUTION MESSAGE. (FLT 4535) REPLACED CONNECTORS MT 167P1, MT170P2, MT173P1, MT174P2, MT171P1, MT171P2, MT172P1, MT172P2, MT169P2, MY170P1, MT167P1, MT174P1, AND MT173P2.SDR SWIA201332689Printed Ckt Board · failedTRU2 & ESS TRU2 FAILED. (FLT 4639) T/S: TRU2 AND AC BUS 2. FOUND BURNT SMELL FROM RIGHT DCPC REPLACED PCB1 A186, SSPC CONTACTOR RELAY K106 AND REPLACED K142, K141 CONTACTORS. P/N: M83536/33-003L, 421CC02, 835CR02Y01, 310CZ01Y00.SDR SWIA201232393Light · inoperativeNR 6 CEILING EMERGENCY OVERHEAD LIGHT BURNED OUT. (FLT 4745) RELAMPED EMERGENCY LIGHT.SDR SWIA201232328Battery Pack · dischargedFIRST FIVE EMERGENCY OVERHEAD LIGHTS IN THE CEILING ILLUMINATE FOR 1 SECOND THEN TURN OFF. (FLT 4513) REPLACED NR 2 ELBP P/N: 2013-1A S/N ON: 73409 P/N OFF: AD-2013-1A S/N OFF: 67042.SDR SWIA201232173Acm · overtempBURNING SMELL AND SMOKE IN FLIGHT DECK. LEFT PACK OVERTEMP. (FLT 4825) REPLACED THE LEFT ACM IAW AMM. ACM P/N OFF GG670-95009-5, S/N OFF 01382.SDR SWIA201231818Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4515) RELAMPED EMERGENCY LIGHT.SDR SWIA201231626Acm · failedRIGHT PACK AUTO FAIL. (FLT 4678) REPLACED RIGHT ACM IN ACCORDANCE WITH AMM.SDR SWIA201231543Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 17 IS OUT. (FLT 4531) RELAMPED EMERGENCY LIGHT.SDR SWIA201231193Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4600) RELAMPED EMERGENCY LIGHT.SDR SWIA201230954Acm · malfunctionedSTRONG BURNT SMELL IN FLIGHT DECK FOLLOWED BY LEFT PACK TEMPERATURE AND LEFT PACK AUTOFAIL CAUTION MESSAGES. (FLT 4631) REPLACED LEFT PACK ACM IN REFERENCE TO CRJ 900 AMM.SDR SWIA201230803Light · inoperativeNR 4 AND NR 7 OVERHEAD EMERGENCY LIGHTS ARE OUT. (FLT 4461) RELAMPED EMERGENCY LIGHTS.SDR SWIA201230423Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4646) RELAMPED EMERGENCY LIGHT.SDR SWIA201229733Light · inoperativeSECOND TO LAST OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201229605Light · inoperativeLAST OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4494) RELAMPED EMERGENCY LIGHT.SDR SWIA201229355Floorbeam · crackedFLOORBEAM AT LEFT FS 274 CRACKED. (C-CHECK) REPAIR CRACKED FLOORBEAM AT FS 274.
Back to N804SK