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 SWIA201126058Relay · failedEMERGENCY LIGHTS FLICKER WITH SWITCH IN THE "ARMED" POSITION. (FLT 1145) REPLACED RELAY K135 IN JB11.SDR SWIA201125957Light · inoperativeNR 6 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6749) RELAMPED EMERGENCY LIGHT.SDR SWIA201125486Light · inoperativeNR 5 CEILING EMERGENCY LIGHT IS OUT. (FLT 6836) RELAMPED EMERGENCY LIGHT.SDR SWIA201025359Light · inoperativeAFT MOST CEILING EMERGENCY LIGHT DOES NOT ILLUMINATE. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201024276Light · inoperativeOVERHEAD CABIN LIGHT AT EXIT ROW INOP. (FLT 6427) RELAMPED OVERHEAD CABIN LIGHT.SDR SWIA201024210Light · inoperativeNR 2 CEILING EMERGENCY FLOODLIGHT INOP. (FLT 6563)RELAMPED.SDR SWIA201023742Light · inoperativeNR 5 EMERGENCY CEILING LIGHT INOP. (FLT 6441) RELAMPED EMERGENCY LIGHT.SDR SWIA201023696Light · inoperativeNR 1 CEILING EMERGENCY LIGHT INOP. (FLT 6753) RELAMPED EMERGENCY LIGHT.SDR SWIA201023642Light · inoperativeEMERGENCY LIGHT NR 2 IN CEILING INOP. (FLT 6674) RELAMPED EMERGENCY LIGHT.SDR SWIA201023497Lamp · burned outFLT 6365 - ONE EMERGENCY CEILING LIGHT INOP. RELAMPED.SDR SWIA200923374Light · inoperativeLAST CEILING EMERGENCY EXIT LIGHT INOP. (FLT 6105) RELAMPED EMERGENCY LIGHT.SDR SWIA200923008Light · inoperativeFRONT EMERGENCY LIGHT INOP. (FLT 6348) RELAMPED EMERGENCY LIGHT.SDR SWIA200922981Light · inoperativeNR 2 CEILING EMERGENCY LIGHT INOP. (FLT 5972) RELAMPED EMERGENCY LIGHT.SDR SWIA200922612Light · inoperativeEMERGENCY OVERHEAD LIGHT AT SEAT ROW 15 INOP. (FLT 6245) RELAMPED EMERGENCY LIGHT.SDR SWIA200922231Light · inoperativeCEILING EMERGENCY LIGHT NEXT TO ROW 4 INOP. (FLT 6552) RELAMPED EMERGENCY LIGHT.SDR SWIA200921588Lamp · burned outFLT 6565 - EMERGENCY EXIT LIGHT NEXT TO 12A INOP. RELAMPED.SDR SWIA200921369Windshield · crackedFLT 6563 - FIRST OFFICERS WINDSHIELD CRACKED. REPLACED WINDSHIELD.SDR SWIA200820169Light · inoperativeSECOND TO LAST EMERGENCY LIGHT INOP (FLT 6615). RELAMPED EMERGENCY LIGHT.
SDR SWIA200819952Charger · inoperativeFORWARD GALLEY EMERGENCY EXIT SIGNS ARE INOPERATIVE. REPLACED NR 1 BATTERY CHARGER PER AMM 33-51-17. OPS CHECK GOOD.
SDR SWIA200819037Handle · bindingFLT 5962 - PAX DOOR HANDLE IS HARD TO OPEN. CLEANED AND LUBRICATED PAX DOOR MECHANISM. OPS CHECK GOOD IAW AMM 52-00-00.
SDR SWIA200718939Relay · malfunctionedEMERGENCY LIGHTING TURNS ON AND OFF WITH COCKPIT SWITCH IN THE ARM POSITION. REPLACED RELAY K135 ON PCB5 IN JB11. OPS CHECKS GOOD.
SDR SWIA200719184Handle · crackedPAX DOOR OUTER HANDLE IS CRACKED, FOUND AT C-CHECK. REPLACED OUTER HANDLE ON PASSENGER DOOR PER CRJ700 AMM 52-11-03-400-801-A01.
SDR SWIA200719183Floorbeam · crackedCRACK IN UPPER FLANGE OF FS 280 FLOORBEAM AT RBL12 AND RBL9, FOUND AT C-CHECK. REPLACED FS 280 FLOORBEAM PER REO 670-53-11-047 REV D.
SDR SWIA200718091Dcu · malfunctionedELEVATOR SPLIT CAUTION MESSAGE FOLLOWED BY A CAS MISCOMP STATUS MESSAGE IN FLIGHT, RETURNED TO ORD. REPLACED NR 1 DCU IAW CRJ MM 31-41-04.SDR SWIA200617411Lamp · burned outAFT CEILING EMERGENCY LIGHT IS INOPERATIVE. RELAMPED AFT CEILING EMERGENCY LIGHT. OPERATIONAL CHECKS GOOD.SDR SWIA200617235Bulb · failedEMERGENCY EXIT ROW LIGHT OVERHEAD ROW 15 RIGHT SIDE INOP. REPLACED BULB FOR EMERGENCY LIGHT. OPERATIONAL CHECKS GOOD.SDR SWIA200515886Sensor · out of adjustINTERMITTENT ELEVATOR SPLIT CAUTION MESSAGE. ADJUSTED LT ELEVATOR POSITION SENSOR IAW AMM 27-34-10-400. OPERATIONAL CHECK GOOD.SDR SWIA200515922Transmitter · malfunctioned"ELEVATOR SPLIT" CAUTION MESSAGE IN FLARE JUST BEFORE LANDING AND INTERMITTENTLY ON TAXI IN. REPLACED RT ELEVATOR POSITION TRANSMITTER IAW MM 27-34-10. OPERATIONAL CHECK GOOD.SDR SWIA200515535Control Unit · malfunctionedSPOILER/STAB FAULT STATUS MSG ON TAXI. REPLACED BOTH SSCU'S IAW 27-61-05. OPERATIONAL CHECK GOOD, C13045BA04; SN2OFF 796.SDR SWIA200515233Sensor · malfunctionedSLAT FAULT STATUS MSG IN FLIGHT. REPLACED RT IB SLAT DISCONNECT SENSOR IAW CRJ 700 AMM 27-81-39, OPERATIONAL CHECK GOOD, P/N OFF 771410C S/N OFF M794.SDR SWIA200515025Controller · malfunctionedSLATS HALF SPEED STATUS MSG. REPLACED NR 1 SFECU IAW AMM 27-51-05. OPERATIONAL CHECK GOOD. P/N OFF 766389L, S/N OFF 0714.SDR SWIA200514993Light · burned outEMERGENCY LIGHT BURNED OUT, BULKHEAD AFT OF FIRST CLASS SECTION. REWIRED REF RIL FROM BOMBARDIER 0375 AND C & D AEROSPACE ENGINEERING CHANGE NOTICE CAGE 56135 DRAWING A407008. OPERATIONAL CHECK GOOD.
Back to N707SK