N597NN
Service difficulty reports · 57
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 = 'N597NN' AND registry_match = 'registration' 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 = 'N597NN' AND registry_match = 'registration' 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 VNAA2020010311101Display · failedCREW REPORTED DUAL MFD FAILURE ON APPROACH TO CLT. MX PERFORMED POWER RESET AND OPS TEST OF PILOT AND CO PILOT MFD'S IAW CRJ 900 AMM. OPS TEST GOODSDR VNAA2019110861103Battery · no indicationREMOVED AND REPLACED LH COCKPIT FLASH LIGHT BATTERY IAWCRJ900 VCMM 25-60-11. OPS CHECKS GOOD AT THIS TIME.SDR VNAA201805231101Warning Message · false activationTHE CREW RECEIVED A STEERING INOP CAUTION MESSAGE. THEY DECLARED AN EMERGENCY. THE TRUCKS ROLLED AND THEY WERE ABLE TO TAXI TO THE GATE ON THEIR OWN. PROBLEM DID NOT REOCCURSDR VNAA2017090111101Clamp · out of positionFLIGHT CREW HAD A LT BLEED MESSAGE DISPLAY. LT PACK AUTOSHUTDOWN. ACFT LOST PRESSURIZATION. EMERGENCY DECLARED AND DIVERTED. MX FOUND A LEAK NEAR THE ACM . THE CLAMP ON THE VALVE POSITION WAS CHANGED TO PREVENT DIRECT FLOW ONTO THE BLEED LOOP. PERFORMED LEASDR VNAA2017083011101Unknown · odorIN FLIGHT RECEIVED L DUCT FAIL MESSAGE AND SHORTLY AFTER FA'S REPORTED A CIGARETTE-LIKE SMELL IN THE CABIN THEN A CHEMICAL SMELL IN CABIN. DECLARED EMERGENCY AND DIVERTED TO KTYS. MX CURRENTLY INSPECTING AIRCRAFT. NOTHING IN CURRENT FAULTS. AIRCRAFT HISTORY SDR VNAA2017012900039Light · detachedEMERGENCY LIGHT ON SERVICE DOOR FELL OFF. SECURED THE LIGHT, OPS CHECKED GOOD.SDR VNAA2016111000015Cover · looseEMERGENCY DOOR HANDLE COVER FELL OFF. MAINTENANCE INSPECTED, SECURED THE HANDLE COVER AND PERFORMED CHECKS IAW THE AMM. THE AIRCRAFT WAS RELEASED FOR SERVICE.
Back to N597NN