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 SWIA201438416Lamp · inoperativeAFT OVERHEAD EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP.SDR SWIA201438402Lamp · inoperativeAFT POD LIGHT INOPERATIVE. REPLACED THE LAMP.SDR SWIA201438596Light · brokenEMERGENCY LIGHT ASSY ABOVE GALLEY SERVICE DOOR IS BROKEN. R & R EMERGENCY LIGHT ASSY ABOVE GALLEY SERVICE DOOR IAW AMM.SDR SWIA201437546Bulb · burned outEXIT LIGHT AND FLOOR LEVEL EXIT SIGN HAVE BULBS BURNED OUT. REPLACED BULBS.SDR SWIA201437002Control Panel · failedAUTO PRESSURE FAILED CAUTION MESSAGE AT 1,000 FT, CABIN WAS NOT PRESSURIZING. REPLACED CABIN PRESSURE CONTROL PANEL IAW AMM.SDR SWIA201436904Lamp · burned outOVERHEAD EMERGENCY LIGHT BETWEEN SEATS 7B & 7C IS BURNED OUT. REPLACED LAMP.SDR SWIA201436473Door Seal · dirtyMAIN CABIN DOOR IS HARD TO OPEN & CLOSE. FLT 4972 CLEANED & LUBRICATED MAIN CABIN DOOR SEAL. LUBRICATED PAX DOOR HANDLE, INNER SPRING, VERIFIED ICE DOOR CABLE, INSTALLED & SERVICEABLE. APPLIED GREASE TO SEVERAL INTERNAL PIVOT POINTS. DOOR NOW OPERATIONS CHSDR SWIA201335810Light · inoperativeGALLEY LOWER EMERGENCY LIGHT BULBS ARE BURNED OUT. FLT 5185 RELAMPED.SDR SWIA201335659Light · inoperativeLT EXIT ROW EMERGENCY LIGHT IS BURNED OUT. FLT 6296 RELAMPED PN 3071BPE.SDR SWIA201335344Light · inoperativeSECOND TO LAST OVERHEAD EMERGENCY LIGHT IS BURNED OUT. FLT 6530 RELAMPED.SDR SWIA201334794Brake Assy · contaminatedRT BRAKE IS MUSHY, MUST BE DEPRESSED ALL THE WAY BEFORE THE BRAKE FULLY ENGAGES. FLT#5216 INSPECTED LT & RT BRAKE ASSEMBLY. BLED NR 3 & NR 4 BRAKE ASSEMBLIES IAW AMM. CHANGED NR 4 BRAKE TEMPERATURE SENSOR IAW AMM.SDR SWIA201334169Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 5 IS BURNED OUT. FLT#6345 RELAMPED.SDR SWIA201334122Seat Track · corrodedREPLACE LT SEAT SIDE RAIL FS 477.00 TO FS 573.00. C-CHECK R&R NEW FABRICATED SEAT RAIL IAW REO.SDR SWIA201334120Seat Track · corrodedREPLACE RT SIDE SEAT TRACK FROM FS 573.00 TO 669.00. C-CHECK R&R WITH NEW RT SIDE SEAT TRACK FROM FS 573.00 TO 669.00 IAW REO & AMM.SDR SWIA201334118Seat Track · corrodedREPLACE LT SEAT SIDE RAIL FS669.00 TO FS713.00. C-CHECK REPLACED LT SIDE SEAT TRACK. PN SH670-36255-3 IAW REO & AMM.SDR SWIA201334117Seat Track · corrodedREPLACE LT SIDE RAIL FS713.00 TO FS761.00. C-CHECK R&R NEW LT SIDE SEAT RAIL AT FS713.00 TO FS761.00 IAW REO & AMM.SDR SWIA201334121Seat Track · corrodedLT SEAT SIDE RAILS HAS CORROSION IN SEVERAL AREAS FROM APPROXIMATELY FS 577.00 TO FS 645.00. C-CHECK REPAIRED LT SIDE SEAT TRACK IAW REO.SDR SWIA201334119Seat Track · corrodedRT SEAT SIDE RAIL HAS CORROSION IN SEVERAL AREAS FROM APPROXIMATELY FS 379.00 TO FS 412.00. C-CHECK BLENDED RT SIDE SEAT TRACK SEVERAL AREAS FROM FS 379.00 TO FS 412.00 IAW REO.SDR SWIA201334116Seat Track · corrodedLT SEAT SIDE RAIL HS CORROSION IN SEVERAL AREAS FROM APPROXIMATELY FS813.00 TO F 830.00. C-CHECK BLENDED LT SIDE SEAT TRACK SEVERAL AREAS FROM FS13.00 TO FS830.00 IAW REO.SDR SWIA201334115Seat Track · gougedRT SEAT SIDE RAIL HAS A GOUGE AT APPROXIMATELY FS813.00. C-CHECK REPAIRED RT SIDE SEAT TRACK APPROXIMATELY FS813.00 IAW REO.SDR SWIA201334123Skin · gougedEXTERNAL REAR FUSELAGE FS 977.00 BOTTOM CENTER FUSELAGE GOUGED. C-CHECK REPAIRED GOUGE ON EXTERNAL FUSELAGE APPROXIMATELY FS 977.00 AT STRINGER 27 IAW REO.SDR SWIA201334124Crossbeam · corrodedEVIDENCE OF SURFACE CORROSION ON THE TOP OF LT FS 280.0 CROSSBEAM. C-CHECK REPAIRED CORROSION TO LT FS 280.0 CROSSBEAM IAW REO.SDR SWIA201333313Mechanism · dirtySERVICE DOOR WILL NOT OPEN FROM INSIDE OR OUTSIDE. (FLT 6231) MOVED AIRCRAFT FORWARD 4 FEET, OPENED SERVICE DOOR. CLEANED AND LUBRICATED SERVICE DOOR ROLLER AND MECHANISM.SDR SWIA201333248Brake · defectiveRIGHT BRAKE DOES NOT FULLY ENGAGE BOTH THE OUTBOARD LEFT AND RIGHT BRAKES AT THE SAME TIME. FELT ON BOTH CAP AND FO BRAKES. TURNED OFF ANTI-SKID WITH NO EFFECT. (FLT 5166) REPLACED NR 4 BRAKE UNIT IAW AMM. P/N: 5013642-1 S/N ON: MAR01-0213 S/N OFF: EC05-SDR SWIA201333067Light · inoperativeGALLEY FLOOR LEVEL EMERGENCY LIGHT DOES NOT ILLUMINATE. (SERVICE) REPLACED THE GALLEY FLOOR LEVEL LIGHT ASSEMBLY.SDR SWIA201333034Light · inoperativeEMERGENCY OVERHEAD LIGHT NR 5 BURNED OUT. (FLT 5494) RELAMPED EMERGENCY LIGHT.SDR SWIA201332850Windshield · crackedCAPTAIN'S WINDSHIELD CRACKED. (FLT 6262) REPLACED CAPTAIN'S WINDSHIELD IAW AMM. P/N ON :NP-139321-13 S/N ON: 12143H8294 P/N OFF: NP-139321-5 S/N OFF: 04245H5184.SDR SWIA201332600Window · crackedAT GATE, CAPTAIN'S SIDE WINDOW CRACKED. (FLT 6394) REPLACED CAPTAIN'S SIDE WINDOW. P/N ON: NP-139322-11 S/N ON: 10326H8866 P/N OFF: NP-139322-9 S/N OFF: 04119H3392SDR SWIA201332558Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5570) RELAMPED EMERGENCY LIGHT.SDR SWIA201231713Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6372) RELAMPED EMERGENCY LIGHT.SDR SWIA201230883Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5212) RELAMPED EMERGENCY LIGHT.SDR SWIA201230487Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5352) RELAMPED EMERGENCY LIGHT.SDR SWIA201230381Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201230272Light · inoperativeOVERHEAD EMERGENCY LIGHT AT 3RD FROM AFT POSITION IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201230080Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5559) RELAMPED EMERGENCY LIGHT.SDR SWIA201229515Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201229461Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5162) RELAMPED EMERGENCY LIGHT.SDR SWIA201229066Light · inoperativeNR 5 AND NR 6 OVERHEAD EMERGENCY LIGHTS ARE OUT. (SERVICE) RELAMPED EMERGENCY LIGHTS.SDR SWIA201128889Floorbeam · crackedFS 280 FLOORBEAM CRACKED. (C-CHECK) REPLACE PER SRM.SDR SWIA201131357Skin · chafedRIGHT AILERON UPPER LEADING EDGE SURFACE IS CHAFED. (C-CHECK) REPAIRED PER CRJ700 SRM.SDR SWIA201131356Stringer · crackedSTRINGER 3L AT FS 280 HAS A CRACK. (C-CHECK) REPAIRED PER REO.SDR SWIA201128703Light · inoperativeRIGHT SIDE FLOOR EMERGENCY EXIT SIGN IS OUT. (FLT 5176) RELAMPED EMERGENCY EXIT SIGN.SDR SWIA201128234Light · inoperativeTHE 2ND TO LAST OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6453) RELAMPED EMERGENCY LIGHT.SDR SWIA201128246Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5530) RELAMPED EMERGENCY LIGHT.SDR SWIA201127935Light · inoperativeAFT CEILING EMERGENCY INOPERATIVE. (FLT 6215) RELAMPED EMERGENCY LIGHT.SDR SWIA201127699Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6508) RELAMPED EMERGENCY LIGHT.SDR SWIA201127498Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5373) RELAMPED EMERGENCY LIGHT.SDR SWIA201127451Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201127150Light · inoperativeAFT CABIN OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5465) RELAMPED EMERGENCY LIGHT.SDR SWIA201126222Sign · missingGALLEY AREA LOWER EXIT SIGN MISSING. (FLT 6453) REPLACED MISSING GALLEY LOWER EXIT SIGN.
Back to N707SK