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 MASA200600831Strut · dischargedASH 7138 EWR, ABORTED TAKEOFF. SEVERE OSCILLATIONS ON NOSE GEAR STRUT AND THE STRUT WAS LOW. MX SERVICED THE NOSE STRUT.SDR MASA200600572Spoiler Sys · noneASH 7182 ABE - SPOILERONS CAUTION MESSAGE AFTER PERFORMING PREFLIGHT CHECKS. THE SYSTEM WAS RESET AND PREFLIGHT CHECKS PERFOMED WITH NO FAULTS NOTED.SDR MASA200600362Light · inoperativeASH 7342 IAD - THE FRONT HALF EMERGENCY PATH LIGHTING INOP. MX REPLACED 2 FLOOR STRIPS.SDR MASA200600169Light · inoperativeASH 7247 ORD - LEFT EMERGENCY LIGHT 8A INOP. MX REPLACED POWER STRIP.SDR MASA200600168Light · inoperativeASH 7247 ORD - LEFT EMERGENCY LIGHT FWD SEC ROW 5 INOP. MX REPLACED POWER STRIP.SDR MASA200600062Computer · malfunctionedASH 7303 ORD - REPEAT STALL FAIL ON APPROACH. MX R2 STALL PROTECTION COMPUTER.SDR MASA200600053Light · smokeASH 7223 FSD - FIRST OFFICERS FLOOD LIGHT EMITTED ELECTRICAL SMOKE. OPS CHECKED GOOD.SDR MASA200501013Idg · disconnectedASH 2972 CLT - NR 2 IDG DISCONNECTED ON TAXI OUT. MAINTENANCE REMOVED AND REPLACED IDG.SDR MASA200500974Idg · warning messageASH 2918 CHA, IDG 2 CAUTION MSG. MAINTENANCE MEL'D IDG. REPOSITIONED TO CLT. MAINTENANCE REMOVED AND REPLACED IDG.SDR MASA200500946Latch · unknownASH 2749 CLT - MAIN CABIN DOOR WILL NOT OPEN. MAINTENANCE REPLACED LATCH ASSEMBLY.SDR MASA200500965Light · inoperativeFLOOR EMERGENCY ESCAPE PATH LIGHTING RIGHT SIDE OF ACFT IS INOP. MAINTENANCE REPLACED NR 1 FLOOR LIGHT STRIP ON RIGHT SIDE.SDR MASA200500942Handle · failedASH 2762 CLT - PAX DOOR WILL NOT OPEN. REPLACED LATCH.SDR MASA200500618Lamp · inoperativeASH 2635 STL. LEFT AFT EXTERIOR EMERGENCY EXIT LIGHTS WERE FOUND TO BE INOP. MAINTENANCE RELAMPED.SDR MASA200500129Connector · crimpedASH - PHL ONE SEGMENT OF THE FLOOR PATH LIGHTING INOP. MAINTENANCE REPLACED THE CONNECTOR.SDR MASA200500029Proximity Switch · out of adjustASH 2669 FROM PHL TO GRR, DIVERTED TO PIT DUE TO A LT MAIN LANDING GEAR DISAGREE MESSAGE AFTER TAKEOFF. AIRCRAFT FERRIED TO PHL AND MX ADJUSTED THE UPLOCK PROXIMITY SWITCHES. AIRCRAFT DEPARTED WITHOUT FURTHER INCIDENT.SDR MASA200400691Element · brokenCLOSED 2748 FROM PHL TO DTW, DECLARED AN EMERGENCY AND RETURNED TO THE FIELD DUE TO A COWL ANTI-ICE FAIL AND 14TH STAGE BLEED FAIL. MAINTENANCE IS IN THE PROCESS OF TROUBLESHOOTING. 12/11/04, MAINTENANCE REPLACE PYLON LOOP A OPS CHECKED GOOD.SDR MASA200400573Connector · looseASH 2605 BOS, LEFT ROW 2 OVERHEAD EMERGENCY LIGHT INOP. LIGHT WAS DEFERRED PER MEL 33-51-01-1. MAINTENANCE RESECURED CONNECTOR OPS CHECKED GOOD.
Back to N715SF, cancelled Feb 21, 2018