N403SW, cancelled Jul 17, 2013
Service difficulty reports · 156
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 = 'N403SW' AND deregistration_id = 'N403SW-2013-07-17' 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 = 'N403SW' AND deregistration_id = 'N403SW-2013-07-17' 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 SWIA95772Overheat Element · failedLT 14TH DUCT WARNING AND BLEED AIR DUCT AURAL AFTER TAKEOFF. WARNING DID NOT EXTINGUISH WITH LT 14TH BLEED CLOSED, WARNINGS EXTINGUISHED LT POWER REDUCTION BELOW 79 PERCENT N1. CONTINUED FLIGHT USING PARTIAL LT POWER. REMOVED AND REPLACED LT 14TH STAGE SENSSDR SWIA95683Windshield · crackedWHILE LEVEL AT FL 350, CAPTAIN'S WINDSHIELD CRACKED, DIVERTED TO RKS. DESCENT AND LANDING WERE UNEVENTFULL. CONTACTED SGU MX CONTROL REMOVED AND REPLACED CAPTAIN'S WINDSHIELD IAW MM 56-11-00 PAGES 401 TO 410. TORQUED ALL BOLTS AND REINSTALLED NEW SEAL.SDR SWIA95635Retract Mech · malfunctionedNOSE GEAR FAILED TO RETRACT. REMOVED AND REPLACED TOW BRACKET AND REINSTALLED PROX SENSOR. ADJUSTED SWITCH TO 0.045 TO 0.055 BRACKET IAW MM 32-61-05-400-805.SDR SWIA95582Scavenge Line · looseRIGHT ENGINE LOW OIL PRESSURE LIGHT ILLUMINATED IN FLIGHT, 16000 FT. PRESSURE FLUCTUATION BETWEEN 27 TO 22 PSI. ALL OTHER INDICATIONS WERE NORMAL. ANTI-ICE WAS SELECTED ON PRIOR TO LOW OIL PRESSURE READ OUT. WHEN PRESSURE WAS STEADY AT 22 PSI, ENGINE WAS SSDR SWIA95541Sensor · malfunctionedWING ANTI-ICE SENSOR CAUTION MESSAGE COMES ON WITH WING ANTI-ICE ON IN NORMAL. IN STANDBY, CHECKS OK. REPLACED LEFT WING CONTROL SENSOR AND OVERHEAT SENSOR. OPS CHECKS GOOD. SEE FL 5073 FOR MECH SIGN OFF.SDR SWIA95526Uplock · iced upUNABLE TO GET RIGHT MAIN GEAR TO GIVE AN UP AND LOCKED INDICATION. CYCLED GEAR SEVERAL TIME THEN GOT A GEAR DISAGREE WARNING IN RETRACT POSITION. AFTER DE-ICING MAIN ENG GEAR, INSPECTED GEAR AND PERFORMED A GEAR SWING. NO PROBLEMS FOUND. SUSPECT LARGE AMOU
Back to N403SW, cancelled Jul 17, 2013