N115HQ
Service difficulty reports · 112
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 = 'N115HQ' 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 = 'N115HQ' 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 R61A20120022Cable · brokenCREW REPORTED R-2 DOOR WOULDN'T ARM. MAINTENANCE REPORTED R-2 DOOR WOULDN'T ARM. MAINTENANCE REMOVED AND REPLACED R-2 DOOR ARM/DISARM CABLE PER EMB AMM, OPS CHECK GOOD.SDR R61A20110441Nut Plate · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND ON THE NUT PLATES OF THE FORWARD CARGO DOOR BUMP PLATE. MAINTENANCE REMOVED AND REPLACED THE NUT HOLDERS (PLATES) AT THE FORWARD CARGO DOOR CUT-OUT BUMP PLATES IAW EMB 175 SRM 51-41-02. REFERESDR R61A201112190442Beam · corrodedDURING HEAVY CHECK, FOUND CORROSION ON RT BEAM FR-86-88. MX REMOVED AND REPLACED RT BEAM, AND SHEET GUSSET PN 170-86101-001 IAW SRM 51-40-02, 51-41-01, 51-42-01, 51-43-01.SDR R61A20110438Panel · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND CORROSION ON CENTER INTERCOSTAL/SHEAR PANEL FRAME 87 TO FRAME 88. MAINTENANCE REMOVED AND REPLACED SHEAR PANEL ON FR 87 TO FR 88 IAW EMB 175 SRM 51-40-02, 51-21-01 AND 51-42-01. THE AIRCRAFT IS OUT OF SERVISDR R61A20110436Panel · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND CORROSION ON RT SHEAR PANEL/INTERCOSTAL FRAME 87 TO 88. MAINTENANCE REMOVED AND REPLACED RT SHEAR PANEL/INTERCOSTAL FRAME 87 TO 88 IAW EMB 175 SRM 51-40-02, 51-42-01, AND 51-42-02. THE AIRCRAFT IS OUT OF SESDR R61A20110437Panel · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND CORROSION ON LT INTERCOSTAL/SHEAR PANEL FR 87 TO FR 88. MAINTENANCE REMOVED AND REPLACED THE LT INTERCOSTAL/ SHEAR PANEL IAW EMB 175 SRM 51-40-02, AND 51-42-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECKSDR R61A20110432Gusset · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND CORROSION ON GUSSET AT FRAME 90 RT I BEAM. MAINTENANCE REMOVED AND REPLACED GUSSET AT FR 90 RT I BEAM IAW EMB 175 SRM 51-41-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A20110349Arming Lever · out of adjustCREW REPORTED R-1 ARMING LEVER WAS DIFFICULT TO USE. MAINTENANCE ADJUSTED R-1 DOOR ARMING LEVER PER EMB AMM, OPS CHECK GOOD.SDR R61A20110039Control Module · failedCREW REPORTED A STEER FAIL MESSAGE ON APPROACH, AN EMERGENCY WAS DECLARED AND THE A/C LANDED WITHOUT INCIDENT AT CLT. MAINTENANCE RESET STEERING SYSTEM AND PERFORMED OPS CHECKS PER EMB AMM, A/C WAS THEN RETURNED TO SERVICE. PER ENGINEERING INSTRUCTION R170EISDR R61A20110033Girt Bar · stuckCREW REPORTED L-1 DOOR WAS DIFFICULT TO ARM. MAINTENANCE FREED THE GIRT BAR DOOR AND PERFORMED OPS CHECKS PER EMB AMM, OPS CHECK GOOD.SDR R61A20100193Door · bindsCREW REPORTED L-1 DOOR WAS HARD TO OPEN FROM THE OUTSIDE. MAINTENANCE PERFORMED OPERATIONAL CHECK OF L-1 DOOR PER EMB AMM, NO DEFECTS WERE NOTED.SDR R61A20100094Wire Harness · faultyCREW REPORTED A WING A/I LEAK IN FLIGHT, DECLARED AN EMERGENCY AND RETURNED TO FIELD AT PHL, AND LANDED WITHOUT INCIDENT. MTX WAS DISPATCHED TO THE AIRCRAFT TO TROUBLESHOOT, AND FOUND THE LT NR 4 SLAT HARNESS AT FAULT, REPLACED IT PER EMB AMM AND AIRCRAFT WAS
Back to N115HQ