N858AA, cancelled Aug 21, 2013
Service difficulty reports · 54
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 = 'N858AA' AND deregistration_id = 'N858AA-2013-08-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 = 'N858AA' AND deregistration_id = 'N858AA-2013-08-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 GTIA99128Duct · leakingFLT 718 - ENCOUNTERED DURING CRUISE FROM TOL TO OMA, NR 3 STRUT OVERHEAT LIGHT WITH THE BLEED OFF AND ENGINE AT IDLE. THE AIRCRAFT CONTINUED TO OMA AND LANDED AT OMA WITHOUT ANY FURTHER DIFFICULTIES. CONFIRMED LEAKAGE AT DUCT AND COUPLING IN THE NR 3 PYLON. SDR GAIA99127Seals · leakingFLT 509 - ENCOUNTERED ON CLIMB-OUT FROM MEM TO TOL, NR 3 STRUT OVERHEAT LIGHT WITH THE BLEED OFF AND ENGINE AT IDLE. THE AIRCRAFT CONTINUED TO TOL AND LANDED AT TOL WITHOUT ANY FURTHER DIFFICULTIES. REMOVED AND REPLACED BLOWN FIREWALL SEAL GASKETS AT THE 13TSDR GAIA99137Clamp · looseFLT 709 - MSP-TOL - ENCOUNTERED DURING CRUISE AN OVERHEAT DETECTION ON NR 3 PYLON. THE AIRCRAFT CONTINUED TO TOL AND LANDED SAFELY WITHOUT FURTHER DIFFICULTIES. FOUND LOOSE DUCT CLAMP IN NR 3 ENIGNE STRUT. TIGHTENED CLAMP AND DUCT LEAKS CHECK GOOD. THE AIRSDR CKSA96064Engine · flamed outNR 2 ENGINE FLAMED OUT AT FL370 WHILE CROSS FEEDING FROM ENGINES NR 1 AND NR 3. NR 2 ENGINE BOOST PUMPS OFF, NORMAL INFLIGHT RESTART WITH BOOST PUMPS ON. INSPECTED ENGINE IAW MM CHAPTER 72-00, OPS CHECKED GOOD ON ENGINE RUN.
Back to N858AA, cancelled Aug 21, 2013