N715SF, cancelled Feb 21, 2018
Service difficulty reports · 117
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 = 'N715SF' AND deregistration_id = 'N715SF-2018-02-21' 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 = 'N715SF' AND deregistration_id = 'N715SF-2018-02-21' 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 MASA2011012601792Light · inoperativeLT & RT FORWARD EXTERIOR EMERGENCY LIGHTS INOP. MX RELAMPED EMERGENCY LIGHT.SDR MASA2011011101652Wire · damagedPAX DOOR STAIR LIGHT INOP. MX REPAIRED WIRING.SDR MASA2011011101651Light · inoperativeLT OVERWING EMERGENCY LIGHT INOP. MX RELAMPED EMERGENCY LIGHT.SDR MASA2011010601618Cable · dirtyPAX DOOR ASSIST INOP. MX CLEANED ASSIST CABLE, OPS GOOD.SDR MASA2011010501615Battery · dischargedFLIGHT ATTENDANTS EMERGENCY FLASHLIGHT BATTERY DEAD. MX REPLACED F/A'S FLASHLIGHT BATTERY.SDR MASA2010120101370Light · inoperativeMIDDLE EXTERIOR EMER LIGHT ON RIGHT SIDE INOP. MX RELAMPED.SDR MASA2010112901350Light · inoperativeRT FORWARD OVERWING EMERGENCY LIGHT INOP. MX RELAMPED.SDR MASA2010112901349Battery · dischargedPILOT'S EMERGENCY FLASHLIGHT INOP. MX REPLACED BATTERY.SDR MASA2010112901342Life Vest · missingMISSING 1 SPARE LIFE VEST. MX REPLACED THE LIFE VEST.SDR MASA2010112301308Life Vest · missingINFANT LIFE VEST MISSING. MX REPLACED INFANT LIFE VEST.SDR MASA2010102901197Potentiometer · malfunctionedAPU OVER TEMP MASTER WARNING IN FLIGHT. R&R DOOR POTENTIOMETER, OPS CHECKED GOOD.SDR MASA2010100601079Flashlight · inoperativeF/O FLASHLIGHT LED INOP. MX REPLACED FLASHLIGHT ASSY.SDR MASA2010093001059Life Vest · missingINFANT LIFE VEST MISSING. MX INSTALLED NEW LIFE VEST.SDR MASA2010092101011Rod · disconnectedAIRCRAFT WILL NOT PRESSURIZE IN FLIGHT. MX RECONNECTED ROD FOR PAX DOOR PRESS RELIEF.SDR MASA2010092001001Life Vest · missingTWO ADULT LIFE VESTS MISSING FROM A/C. MX INSTALLED REPLACEMENT LIFE VESTS.SDR MASA2010081600882Fastener · missingSERVICE DOOR CAUTION IN FLT. MX INSTALLED MISSING HARDWARE.SDR MASA2010081000868Battery · dischargedF/O FLASHLIGHT LED NOT BLINKING. MX R2 BATTERY.SDR MASA2010071700771Loop · faultyRT 14TH STAGE DUCT WARN ON CLIMB, CREW DECLARED AN EMERGENCY AND RETURNED TO FIELD. MX REPLACED THE RT PYLON LOOP.SDR MASA2010071200752Frame · crackedIN-SERVICE DEVIATION FOR LT FS 640 FRAME CRACK ON FWD FACE ABOVE ENGINE SUPPORT BEAM (BETWEEN STRINGER 9 AND 12), JOB 5 OP (LINKED TO JOB 5 OP 151).SDR MASA2010070600726Bulkhead · crackedAT C-CHECK, CRACK NOTED ON FS 621 BULKHEAD FWD FACE ABOVE UPPER CARGO DOOR TRACK FITTING ON BOMBARDIER JOB 4711515 OP 70 ON 5-28-10. REO 601R-53-61-1541. INSPECT THE BULKHEAD IN THE AREA OF THE WEB REPAIR PER NDTM. SIGNED OFF AND SENT TO CASS ON 7/6/2010.SDR MASA2010071200751Bulkhead · crackedIN-SERVICE DEVIATION FOR 3(EA) CRACKS NOTED ON FS BLKD AT RBL 18 APPROX WL 59.1, OUTBOARD OF RBL 9 APPROX WL 54.1 AND LBL 18 IN CAP ANGLE, JOB 09 17. MX COMPLIED WITH GREO'S ON BOMBARDIER SERVICES TASK CARD.SDR MASA2010061400644Bulkhead · crackedTHREE CRACKS NOTED AND MARKED ON FS 559 BULKHEAD AT RBL 18 APPROX WL 59.1, OUTBOARD OF RBL 9 APPROX WL 54.1, AND LBL 18 IN CAP ANGLE. RECOMMENDED ACTION FROM BOMBARDIER IS TO REPAIR PER GREO 601R-53-41-260 AND GREO 601-53-41-609. MX COMPLIED WITH GREO'S VIA SDR MASA2010042900416Battery · dischargedSERVICE DOOR AND PAX DOOR EXTERIOR EMERGENCY LIGHTS INOP. CHARGED THE BATTERY.SDR MASA2010041700356Charger · inoperativeALL EXIT LIGHTS ASSOCIATED WITH NR 4 BATTERY AND LT FWD EMERGENCY LIGHT INOP. MX REPLACED NR 3 BATTERY CHARGER, FUSE ON NR 4 CHARGER, AND REMOVED AND REPLACED NR 1, 2, 3, 4 EMERGENCY BATTERIES.SDR MASA2010040400296Light · inoperativeROW 1 EMERGENCY FLOOR LIGHT STRIP INOP. R2 LIGHT STRIP.SDR MASA2010010600023Light · inoperativeLEFT AFT EMERGENCY LIGHT INOP. RELAMPED AFT EMERGENCY LIGHT, OPS CHECK GOOD.SDR MASA2009122800367Light · inoperativeASH FLT 7169 CAE-OVERNIGHT. CREW REPORTED THE ROW 2 EMERGENCY CEILING LIGHT WAS INOP. MX REPLACED THE LAMP AND OP CHECKS WERE GOOD.SDR MASA2009110100326A/C Pack · failedAIRSHUTTLE 7203 FROM CAK TO ORD DECLARED AND EMERGENCY JUST PRIOR TO LANDING DUE TO THE LT PACK FAILED AND THE RT WOULD NOT MAINTAIN PRESSURIZATION. THE CABIN CLIMBED TO 18000 FT AND THE O2 MASKS AUTO DEPLOYED.SDR MASA2009082200269Sign · inoperativeASH FLT 7246 ORD TO SBN. FLOOR EMERGENCY EXIT SIGN INOP. MX R2 FLOOR STRIP OPS GOOD.SDR MASA2008111400771Flap · failedASH FLT 7209 IAD-SYR - CAPTAIN RECEIVED A FLAP FAIL AT "0" IN CRUISE. FLIGHT ORIGINALLY SCHEDULED TO LGA AND DIVERTED DUE TO WEATHER. CAPTAIN DECLARED AN EMERGENCY AND LANDING WAS UNEVENTFUL. MX COMPLIED WITH PART A RESET SUCCESSFUL.SDR MASA2008110500763Ecu · malfunctionedASH 7093 ORD-CLE. CREW DECLARED AND EMERGENCY ON LANDING DUE TO A FLAP SYSTEM FAILED. AIRCRAFT FERRIED TO CAE WHERE MAINTENANCE COMPLIED WITH PART A/PART B AND REMOVED AND REPLACED FECU.SDR MASA2008102700753Bpsu · noneASH 7320 - MSN-ORD - CREW DECLARED AND EMERGENCY ON LANDING DUE TO A FLAP FAIL. MX REMOVED AND REPLACED BPSU AND COMPLIED WITH PART A AND B. OPS CHECKED GOOD.SDR MAS2008F00068Proximity Switch · out of adjustASH FLT 7319 IAD-CLT-SAV. PAX DOOR OUTER HANDLE CAUTION MESSAGE IN FLIGHT. MX ADJUSTED PROX SWITCH PS1MB. OPS CHECK GOOD.SDR MAS2008F00012Housing · unsecureASH FLT 7159 - IAD-CLE - PASSENGER DOOR OUTER HANDLE WILL NOT STOW FROM INSIDE. MAINTENANCE RESECURED PULL ROD HOUSING. (S)SDR MASA200800394Light · inoperativeASH FLT 7211 CAE - EMERGENCY FLOOR PATH LIGHTING FORWARD THREE SECTIONS INOP. MX REPLACED LIGHT STRIPS.SDR MASA200800257Proximity Sensor · out of adjustASH 7291 SPI - IAD, NOSE GEAR DOOR OPEN WARNING. ADJUSTED PROX SENSOR, SWUNG GEAR, OPS CHECK GOOD.SDR MASA200700458Battery Pack · inoperativeASH 7410 IAD. EMERGENCY PATH LIGHTING AT ROWS 2/4 AND LEFT OVERWING EMERGENCY EXIT LIGHT INOP. MX R2 BATTERY PACK FOR OVERWING AND THE PACK AND LIGHT STRIP FOR THE PATH LIGHTING, BOTH OPS CHECK GOOD.SDR MASA200700381Light · inoperativeASH 7358 ORD. MX REPORTED THAT THE RIGHT HAND AFT OVERWING EMERGENCY EXIT LIGHT WAS INOP. MX RELAMPED THE LIGHT.SDR MASA200602681Warning System · malfunctionedASH 7417 JFK. CAPT REPORTED A FLIGHT SPOILER CAUTION. CONTRACT MX RESET SPOILER SYSTEM.SDR MASA200602539Seal · cutASH 7230 ORD. AUTO PRESSURIZATION ERRATIC. MX FOUND TWO CUTS IN THE SERVICE DOOR SEAL AND ARE CURRENTLY TROUBLESHOOTING.SDR MASA200602178Ring · missingASH 7366 IAD - COCKPIT DOOR EMERGENCY RELEASE PIN PULL RING WAS MISSING. MX INSTALLED NEW RING.SDR MASA200601995Battery Pack · inoperativeASH 7118 ORD. BATTERY MASTER LEFT ON AND ALL EMERGENCY LIGHTS INOP. CONTRACT MAINTENANCE REMOVED AND REPLACED THE BATTERY PACKS. OP'S CHECK GOOD.SDR MASA200601918Warning System · malfunctionedASH 7369 IAD - INBD SPOILER FAULT CAUTION MESSAGE. MX RESET.SDR MASA200601820Warning System · malfunctionedASH 7356 ORD - PILOT REPORTED A FLT SPOILER AND SPOILERON MESSAGES. MX RESET.SDR MASA200601822Pressure Switch · malfunctionedASH 7356 ORD - SPOILERON FAULT AND FLIGHT SPOILER FAULT. MAINTENANCE REMOVED AND REPLACED 2B PRESSURE SWITCH.SDR MASA200601775Warning System · malfunctionedASH 7190 IAD - OUTBOARD GROUND SPOILER CAUTION ON LANDING. MX RESET SYSTEM. OP'S CHECK GOOD.SDR MASA200601562Warning System · malfunctionedASH 7208 ORD - OUTBRD GROUND SPOILER CTN. MX RESET SYSTEM AND NO FURTHER ACTION NEEDED.SDR MASA200601531Proximity Switch · out of adjustASH 7208 IAD - CLT TO JFK, AC DIVERTED TO IAD DUE TO PAX DOOR LATCH CAUTION MESSAGE. MX ADJ PROX SW.SDR MASA200601522Warning System · malfunctionedASH 7284 ORD - PASSENGER DOOR HANDLE MESSAGE IN FLIGHT. MX CND. OP'S CHECK GOOD.SDR MASA200600845Unknown · unknownASH 7288 DTW - SPOILERON CAUTION MESSAGE. RESET SYSTEM. OPS CHECK GOOD.
Back to N715SF, cancelled Feb 21, 2018