N213SW, cancelled Nov 14, 2007
Service difficulty reports · 63
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 = 'N213SW' AND deregistration_id = 'N213SW-2007-11-14' 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 = 'N213SW' AND deregistration_id = 'N213SW-2007-11-14' 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 SWIA971081De-Ice Boots · failedLEFT AND RIGHT INBOARD STABILIZER DE-ICE BOOTS AND INBOARD LEFT AND RIGHT WING DE-ICE BOOTS FAIL AFTER ABOUT 10 SECONDS OR LESS IN BOTH TIMERS AND LIGHT AND HEAVY CYCLE. RETURNED TO LAX. INSTALLED SERVICEABLE EJECTOR VALVE IAW MM 30-10-00. RAN SYSTEM AND OPSDR SWIA97989Sill · corrodedLEFT OUTBOARD FLOOR SUPPORT UNDER GALLEY FLOOR BOARDS HAS SOME CORROSION. LEFT THRESHOLD SILL PARTS IN STOCK. REMOVED AND REPLACED LEFT OUTBOARD THRESHOLD SILL IAW MM 51-00-00.SDR SWIA97988Strap · corrodedOBSERVED LIGHT CORROSION (WHILE VISUALLY INSPECTING) ON THE AREA BELOW THE LAVATORY FLOOR PANEL AND TOWARD THE PASSENGER DOOR FLOOR PANEL BETWEEN LAVATORY AND PASSENGER DOOR ENTRANCE. REMOVED AND REPLACED RIGHT AND LEFT BUTT STRAPS UNDER GALLEY AND LAVATORY ASDR SWIA97833Selector Handle · malfunctionedAFTER TAKEOFF WHEN FLAPS WERE RETRACTED, THE TAKEOFF FLAPS AURAL WARNING CAME ON. FLAP INDICATIONS WERE NORMAL BUT THE AURAL WARNING WOULD NOT SILENCE. RETURNED TO FIELD. REPLACED FLAP SELECTOR HANDLE, OPERATED FLAPS AND POWER LEVERS AND SYSTEM CHECKS GOOD.SDR SWIA97831Aural Warn Comp · malfunctionedTAKEOFF AURAL WARNING SYSTEM ACTIVATED AFTER TAKEOFF WHEN POWER LEVERS WERE BROUGHT BACK TO CLIMB POWER. TURNED OFF BACK UP BUTT AND PULLED AURAL WARNING CIRCUIT BREAKER TO STOP WARNING. ALL SYSTEMS WERE CORRECT, COULD NOT RESET UNTIL CRUISE POWER SET WITHOSDR SWIA95793Computer · malfunctionedFLAP CONTROL FAULT OUTBOARD FLAPS 15 DEG INBD AND NACELLE FLAPS 25 DEG. UNABLE TO LAND SBP DIVERTED TO SMX.REPLACED FLAP COMPUTER, CLEANED TRACKS, RAN FLAPS. SYSTEM OPS CHECKS GOOD AT THIS TIME.SDR SWIA95784Aural Warning · soundedON TAKEOFF ROLL, TRIM AURAL WARNING SOUNDED, ABORTED TAKEOFF. RESET AURAL WARNING CIRCUIT BREAKER, OPS CHECKS GOOD.SDR SWIA95758Control Box · malfunctionedLANDING GEAR WOULD NOT RETRACT. REPLACED LANDING GEAR CONTROL BOX, OPS CKS GOOD.SDR SWIA95711Tracks · wornAFTER TAKEOFF, FLAPS WOULD NOT RETRACT, RECEIVED FLAP DISAGREEMENT. REPLACED BOTH MOVEABLE FLAP TRACKS ON LEFT OUTBOARD FLAP. REPLACED FOUR TRACK ROLLERS. OPS CHECKS GOOD.SDR SWIA95697Cables · wornRT AILERON CABLES WORN OUTBOARD OF NACELLE. REPLACED RT AILERON CABLES PER MM 27-00-01.SDR SWIA95696Control Cable · wornLT AILERON CABLES WORN OUTBOARD OF NACELLE. REPLACED LT AILERON CABLES PER MM 27-00-01.SDR SWIA95532Rollers · lack of lubeAFTER TAKEOFF, SELECTED FLAPS UP. GOT A DISAGREEMENT INDICATION. SHOWED OB FLAPS NOT RETRACTING. CLEANED AND LUBED FLAP ROLLERS. CLEANED MOISTURE FROM CANNON PLUGS. CYCLED FLAPS MANY TIMES. CHECKS GOOD. SEE FL FOR MECH SIGN OFF.SDR SWIA95531Connector · dirtyOB FLAP DISAGREED AFTER LANDING AND FLAPS WERE SELECTED UP. CLEANED CANNON PLUGS ON OB ACTUATORS. COULD NOT DUPLICATE PROBLEM. FLAPS OPERATED NORMALLY. SEE FL FOR MECH SIGN OFF.
Back to N213SW, cancelled Nov 14, 2007