N102HQ
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 = 'N102HQ' 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 = 'N102HQ' 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 R61A201212050712Rib · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT WING SPAR 2 RIB 10 EXTENSION CRACKED. MAINTENANCE REMOVED AND REPLACED THE LEFT WING SPAR 2 RIB 10 EXTENSION IAW EMB 175 SRM 51-43-03 AND 51-43-04. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201209300543Life Vest · damagedCREW REPORTED 2 INFANT LIFE VESTS DAMAGED. MAINTENANCE REPLACED 2 INFANT LIFE VESTS AS REQUIRED PER EEM CHAPTER 4.SDR R61A20110393Switch · failedCREW REPORTED PARKING BRAKE NOT REALEASED MSG IN FLIGHT AND THE "ON" LIGHT FOR EMERGENCY BRAKE WAS FLICKERING DURING FLIGHT. DECLARED AN EMERGENCY AND LANDED WITHOUT INCIDENT INTO MCI. MAINTENANCE REMOVED AND REPLACED BOTH EMERGENCY BRAKE PSI SWITCHES PER EMSDR R61A20110165Light · inoperativeCREW REPORTED AFT RED RAINBOW LIGHT WOULDN'T ILLUMINATE. MAINTENANCE PLACED ITEM ON MEL 44-13-07-1.SDR R61A20110160Seat Track · corrodedWHILE A/C WAS IN FOR HEAVY CHECK FOUND RT AFT SEAT TRACK HAS CORROSION AT FR 87. MX REPLACED RT SEAT TRACK AT FR 86-89 IAW EMB 175 SRM 51-43-01 NO FCS AFFECTED. A/C REMAINS IN CMH FOR HEAVY CHECK COMPLETION.SDR R61A20110158Sill · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK, MAINTENANCE REPORTED NUT PLATE HOLDER ATTACH BASE CORRODED ALONG FWD CARGO DOOR SILL. MAINTENANCE REMOVED AND REPLACED NUT PLATE HOLDER ATTACH BASES 10 EA ALONG LOWER SILL FOR THE FWD CARGO DOOR IAW EMB170 SRM 51-41-02. AIRSDR R61A20110155Shear Plate · corroded*** WHILE AIRCRAFT WAS IN FOR HEAVY CHECK *** LEVEL 2 CORROSION WAS FOUND ON SHEAR PLATE AT FRAME 88 & 89. MAINTENANCE REMOVED AND REPLACED THE RIGHT AND CENTER SHEAR PLATES IAW EMB 175 SRM 51-42-01, 51-42-02, 51-42-03 & 51-43-03. P/N'S 170-65928-001 & 170-9SDR R61A20110154Splice · corroded*** WHILE AIRCRAFT WAS IN HEAVY CHECK *** LEVEL 2 CORROSION WAS FOUND ON THE RT FLOOR SUPPORT GUSSET AT FR 89. MAINTENANCE REMOVED AND REPLACED THE RT SEAT TRACK SPLICE AT FRAME 89 IAW EMB 175 SRM 51-43-01 & 51-40-02. AIRCRAFT IS CURRENTLY STILL OUT OF SERVISDR R61A20110143Battery · activatedCREW REPORTED EMERGENCY LIGHTS INOP. MAINTENANCE REMOVED AND REPLACED FWD RT EMERGENCY BATTERY UNIT PER EMB AMM.SDR R61A20110142Light · malfunctionedCREW REPORTED CABIN EMERGENCY LIGHTS ILLUMINATED DURING TAKEOFF AND ON LANDING. MAINTENANCE PERFORMED OPS CHECK OF EMERGENCY LIGHTS PER EMB AMM, OPS CHECK GOOD.SDR R61A20100501Sensor · failedCREW REPORT SLAT FAIL ON APPROACH, AND DECLARED AN EMERGENCY INTO PHL, AND LANDED WITHOUT INCIDENT. MAINTENANCE REMOVED AND REPLACED BOTH SLAT 3/4 HARNESSES AND THE RT OUTBOARD SKEW SENSORS, AND REPLACED BOTH LT OUTBOARD SKEW SENSORS PER EMB AMM, OPS CHECK GOSDR R61A20100358Power Unit · inoperativeCREW REPORTED EMERGENCY LIGHT AT ROW 190 WAS INOP. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY LIGHT POWER UNIT PER EMB AMM, THE A/C WAS THEN RETURNED TO SERVICE.
Back to N102HQ