N121HQ
Service difficulty reports · 157
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 = 'N121HQ' 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 = 'N121HQ' 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 R61A201209100486Lock · dirtyCREW REPORTED L1 DOOR HARD TO DISARM AND INDICATION WINDOW ISN’T SHOWING ALL GREEN. MAINTENANCE CLEANED AND LUBED PASSENGER DOOR LOCK ASSY PER EMB 175 MM 52-12-5.SDR R61A201202020075Doubler · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND CORROSION AROUND WASTE BOX. MAINTENANCE REMOVED AND REPLACED DOUBLER IAW EMB 175 SRM 51-43-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201202020074Doubler · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND CORROSION AROUND WASTE BOX. MAINTENANCE REMOVED AND REPLACED DOUBLER IAW EMB 175 SRM 51-43-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A20120071Shear Web · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND ON THE SHEAR WEB AFT OF L1 DOOR ON FWD CLOSET MOUNT BOLT HOLE. MAINTENANCE REMOVED AND REPLACED SHEAR WEB (DOUBLER FLOOR) AFT OF THE L1 DOOR IAW EMB 175 SRM 51-41-02, 51-10-03, 51-40-02, 51-40-SDR R61A20120069Crossbeam · corrodedWHILE A/C WAS IN FOR HEAVY CHECK FOUND FR 14 FLOOR CROSSBEAM , CORROSION OUTBD OF RT INBD SEAT TRACK BEAM. MX REPAIRED CORRODED AREA WITH RIVET IAW ETD 2012-170-001327A P/N FLUSH HEAD RIVET NAS1097-4. A/C REMAINS IN CMH FOR HEAVY CHECK COMPLETION. THIS IS A SDR R61A20110429Light · inoperativeCREW REPORTED EMERGENCY LIGHT IN CEILING OVER ROW 3 WAS INOP. MAINTENANCE PERFORMED OPS CHECK OF EMERGENCY LIGHT SYSTEM PER EMB AMM, OPS CHECK GOOD.SDR R61A20090003Sensor · defectiveCREW REPORTED SLAT FAIL MESSAGE ON EICAS PAGE. CREW FOLLOWED QRH PROCEDURES AND DECLARED EMERGENCY AND LANDED WITHOUT INCIDENT. MAINTENANCE DISPATCHED TO AIRCRAFT, TROUBLESHOOT AND REMOVED AND REPLACED LEFT SLAT 2-3 SKEW SENSOR. COMPLETED OPERATIONAL CHECKS
Back to N121HQ