N650ML, cancelled Jan 10, 2011
Service difficulty reports · 73
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 = 'N650ML' AND deregistration_id = 'N650ML-2011-01-10' 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 = 'N650ML' AND deregistration_id = 'N650ML-2011-01-10' 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 MASA200600111Spoiler Sys · faultedASH 7199 IAD - THE CREW NOTED AN OUTBOARD GROUND SPOILER FAULT. MAINTENANCE RESET SYSTEM. OPS CHECK GOOD.SDR MASA200600047Lamp · inoperativeASH 7157 IAD - ONE CABIN OVERHEAD EMERGENCY EXIT LIGHT INOP. MAINTENANCE RELAMPED.SDR MASA200501085Lamp · inoperativeAFT EMERGENCY EXIT LIGHT INOP. MAINTENANCE REPLACED LAMP.SDR MASA200501084Lamp · inoperativeROW 8 EMERGENCY EXIT LIGHT INOP. MAINTENANCE REPLACED LAMP.SDR MASA200501076Unknown · unknownASH 7172 ORD - DIVERTED AND DECLARED AN EMERGENCY TO CLT DUE TO THE MACH AND STAB TRIM CAUTION MESSAGES. RESET SYSTEM PERFORMED OPS CHECKED GOOD.SDR MASA200500779Connector · disconnectedASH 2750 PHL - REAR HALF OF THE EMERGENCY PATH LIGHTING INOPERATIVE. MX CLEANED AND RE CONNECTED CONNECTOR AT BATTERY PACK.SDR MASA200500769Spoiler · unwanted deployASH 2661 PHL - UNCOMMANDED SPOILER DEPLOYMENT. MX RESET AND OPS CHECKED SYSTEM, OPS CHECK GOOD.SDR MASA200500758Apu · lack of lubeASH 2672 PHL, APU OIL TEMPATURE CAUTION MESSAGE. SVCD APU OIL ADDED 1/2 QT. OPS CHK GOOD.SDR MASA200500579Wire · damagedSEVERAL SECTIONS OF FLOOR PATH LIGHTING INOP. REPAIRED WIRE.SDR MASA200500476Seal · failedASH 2635 STL, DIVERTED TO CVG DUE TO A CABIN ALT MASTER WARNING IN FLT. THE PLANE WAS CRUISING ABOVE 250 AND NOTICED THE CABIN ALT. CLIMBING ABOVE 120. THE CREW DESCENDED AND WAS ABLE TO STABILIZE THE CABIN ALT. THE PLANE LANDED IN CVG AND CONTRACT MX FOUSDR MASA200500316Warning Light · illuminatedASH 2940 PHL. THE AIRCRAFT RETURNED TO THE FIELD DUE TO PITOT BASE HEAT CAUTION MESSAGE. MAINTENANCE REMOVED AND REPLACED THE P/B HEAT SPLICE.SDR MASA200500277Light · inoperativeCREW REPORTED OVERHEAD EMERGENCY FLOOD LIGHT AT ROW 5 INOP. PLACED OVERHEAD EMERGENCY FLOOD LIGHT AT ROW 5 ON MEL. MAINTENANCE REMOVED AND REPLACED THE LIGHT.SDR MASA200500224Power Supply · inoperativeASH 2698 - IN PHL HAD 1ST 4 FLOOR EMERGENCY LIGHT INOP. MAINTENANCE REPLACED POWER SUPPY FOR LIGHTING STRIPS.SDR MASA200500163Bulb · burned outDURING OVERNIGHT MAINTENANCE IN PHL, RT OVERWING EMERGENCY LIGHT WAS FOUND INOPERATIVE. MAINTENANCE REPLACED THE LIGHT BULB AND NO FURTHER DEFECTS WERE NOTED.SDR MASA200500133Wire · brokenPHL - REPORTED A SECTION OF THE FLOOR PATH LIGHTING INOP. MAINTENANCE REPAIRED A BROKEN WIRE. OPS CHECK GOOD.SDR MASA200400738Bulb · burned outTHE CREW REPORTED A CEILING EMERGENCY LIGHT INOPERATIVE. THE ITEM WAS PLACED ON MEL. 1/3/05 MAINTENANCE RELAMPED, OPS CHECKED GOOD.SDR MASA200400516Bulb · burned outDURING PREFLIGHT, THE SERVICE DOOR LOWER EXIT SIGN WAS INOP. MAINTENANCE REPLACED THE LIGHT.SDR MASA200400265Proximity Sensor · looseASH 2928 PHL-DCA. DEPARTING PHL THE CAPTAIN REPORTED THE RIGHT MAIN LANDING GEAR WOULD NOT RETRACT AND A GEAR UNSAFE CONDITION EXISTED. THE GEAR WAS PLACED BACK DOWN AND ABNORMAL SAFE LANDING WAS EXECUTED. MX FOUND THE RT MLG PROXIMITY SENSOR TARGET NOT SECSDR MASA200400246Proximity Sensor · inoperativeASH 2888 ATL. AIRCRAFT RETURNED TO THE FIELD, NLG WILL NOT RETRACT. A/C WAS FERRIED TO PHL FOR REPAIRS. MX REPLACED THE ELECTRONIC PROXIMITY SENSOR. OPS CHECKED GOOD.SDR MASA200400216Trim System · malfunctionedDURING FLIGHT THE STAB TRIM MOVED UNCOMMANDED IN SMALL INCREMENTS. MX INSPECTED AND RESET THE SYSTEM BUT COULD NOT DUPLICATE THE PROBLEM. NO PARTS USEDSDR MASA200400219Switch · looseDURING CRUISE, THE STAB TRIM MOVED UN-COMMANDED. MX OP CHECKED SYSTEM AND FOUND NO FAULTS. DURING OVER NIGHT MX THE FO'S TRIM SWITCH WAS FOUND TO BE LOOSE IN THE YOKE AND WAS REINSTALLED. OP CHECKS GOOD. NO PARTS USEDSDR MASA200400205Priority Valve · leakingASH 2608 CLT. AFTER TAKEOFF WITH GEAR SELECTED UP, THE NOSE REMAINED EXTENDED. AFTER THE AURAL WARNING SOUNDED THE NOSE RETRACTED WITH NO FURTHER INPUT FROM THE FLIGHT CREW. A/C LANDED AT DESTINATION AIRPORT NORMALLY. MX IS TROUBLESHOOTING AT THIS TIME. MSDR MASA200400200Battery Pack · dischargedASH NR 2917. CLT-BNA. OPERATIONS LEFT THE EMERGENCY LIGHTS ON AND RAN DOWN THE BATTERIES. MECHANIC REPLACED THE BATTERIES. OP CHECKS GOOD.
Back to N650ML, cancelled Jan 10, 2011