N135HQ
Service difficulty reports · 73
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 = 'N135HQ' 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 = 'N135HQ' 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 R61A201406120758Seat Track · corrodedDURING HEAVY CHECK, LT INBD SEAT TRACK EXTENSION AT FRAME 86 AROUND RIVET HEADS IS CORRODED. MX R & R SEAT TRACK IAW SRM 51-40-02,51-41-02,51-43-01.SDR R61A201406110757Firewall · crackedDURING HEAVY CHECK, APU FIREWALL 351BZ FOUND CRACKED. MX REPAIRED APU FIREWALL IAW SRM 53-31-21, REPAIR 02, TYPE 1.SDR R61A201406110754Door Sill · corrodedDURING HEAVY CHECK, FWD CARGO DOOR CUTOUT LOWER SILL IN BOTH FWD AND AFT LOWER CORNERS ARE CORRODED. MX R & R FWD CARGO DOOR CUTOUT LOWER SILL IN BOTH FWD AND AFT LOWER CORNERS IAW SRM 51-41-01 AND AMM 20-10-01. PN 170-66803-401, SILL REST.SDR R61A201406100782Check Valve · corrodedDURING HEAVY CHECK, FWD CARGO SIDE WALL CHECK VALVE SHOWS SIGNS OF CORROSION. MX R & R FWD CARGO SIDE WALL CHECK VALVE IAW AMM21-27-03.SDR R61A201401040027Flashlight · inoperativeF/O FLASHLIGHT DOES NOT WORK. R & R FLASHLIGHT ASSY IAW AMM 33-51-00. OPS CHECKED GOOD.SDR R61A201303030212Mask · damagedFLIGHT ATTENDANTS OXYGEN DEMO MASK WAS TATTERED. MAINTENANCE REMOVED AND REPLACED DEMO MASK PER EMB AMM, OPS CHECKED GOOD.SDR R61A201207150370Potable Water · contaminatedPOT WATER FROM SINK AND COFFEEMAKERS RELEASES FUMES THAT BURN THROAT AND NOSE. MAINTENANCE PERFORMED POTABLE WATER SANITIZATION IAW EMB 175 J/C R12-14-01-670-810A. WATER IS CLEAR AND NO LONGER CONTAINS ODOR. PLACED POTABLE WATER TANK ON MEL 38-10-00-2.SDR R61A201207040348Rib · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT WING RIB 10 EXTENSION CRACKED. MAINTENANCE REMOVED AND REPLACED THE LEFT WING RIB 10 EXTENSION IAW EMB 175 SRM 51-40-02, 51-41-01, 51-43-01, 51-43-02, AND 51-23-09. THE AIRCRAFT IS OUT OF SERVICE SDR R61A201207040355Gusset · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE CENTER RIGHT GUSSET FRAME 90 CORRODED. MAINTENANCE REMOVED AND REPLACED THE CENTER RIGHT GUSSET FRAME 90 IAW EMB 175 SRM 51-41-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201207040354Gusset · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE CENTER LEFT GUSSET FRAME 90 CORRODED. MAINTENANCE REMOVED AND REPLACED THE CENTER LEFT GUSSET FRAME 90 IAW EMB 175 SRM 51-41-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201207040351Bracket · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT PACK RAM AIR VALVE BRACKET CRACKED. MAINTENANCE REMOVED AND REPLACED THE BRACKET ON THE LEFT PACK RAM AIR VALVE IAW EMB 175 SRM 51-40-02, 51-41-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201207040350Profile · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT PACK RAM AIR VALVE PROFILE CRACKED. MAINTENANCE REMOVED AND REPLACED THE CRACKED PROFILE LEFT PACK RAM AIR VALVE IAW EMB 175 SRM 51-40-02, 51-41-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201207040349Bracket · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT PACK RAM AIR VALVE BRACKET CRACKED. MAINTENANCE REMOVED AND REPLACED THE BRACKET ON LEFT PACK RAM AIR VALVE IAW EMB 175 SRM 51-40-02, 51-41-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201207040347Seat Track · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT FORWARD SEAT TRACK BEAM CORRODED AT FRAME 17. MAINTENANCE REMOVED AND REPLACED THE LEFT FORWARD SEAT TRACK IAW EMB 175 SRM 51-40-02, 52-41-02, 51-43-01, AND 51-43-02. THE AIRCRAFT IS OUT OF SERVICESDR R61A201207040346Seat Track · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT LOWER SEAT TRACK BETWEEN FRAMES 13 AND 14 HAVE CORROSION. MAINTENANCE REMOVED AND REPLACED THE RIGHT LOWER SEAT TRACK IAW EMB 175 SRM 51-40-02, 51-41-01, 51-41-02, 51-43-01, 51-43-02, 51-43-03 AND SDR R61A201207040340Service Panel · delaminatedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE AFT LAVATORY SERVICE BOX IS DELAMINATED. MAINTENANCE REMOVED AND REPLACED THE AFT LAVATORY SERVICE BOX IAW EMB 175 SRM 51-40-02 AND 51-43-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A20110108Girt Bar · unsecureCREW REPORTED L-2 DOOR WILL NOT DISARM. MAINTENANCE RE-SECURED L-2 DOOR GIRT BAR AND PERFORMED OPS CHECKS PER EMB AMM.SDR R61A20100523Cable · defectiveCREW REPORTED R-1 DOOR WOULDN'T DISARM. MAINTENANCE REMOVED AND REPLACED DISARM CABLE PER EMB AMM, OPS CHECK GOOD.SDR R61A20100330Light · malfunctionedCREW REPORTED EMERGENCY LIGHT OVER FORWARD EXITS WOULDN'T TURN OFF. MAINTENANCE PERFORMED OPS CHECK OF EMERGENCY LIGHTS PER EMB AMM, NO DEFECTS WERE NOTED.SDR R61A20100130Indication Sys · malfunctionedCREW REPORTED L-1 DOOR SLIDE ARMED/DISARMED INDICATION WASN'T SHOWING IN THE WINDOW. MAINTENANCE VERIFIED THE GIRT BAR INDICATION WAS WORKING AND PLACED ON MEL. A/C WAS RETURNED TO SERVICE.SDR R61A20100096Indicator · out of adjustCREW REPORTED L-1 DOOR SLIDE INDICATION DOESN'T ROTATE TO GREEN WHEN UNLOCKED. MAINTENANCE TROUBLESHOT AND PERFORMED ADJUSTMENT ON L-1 DOOR SLIDE INDICATOR PER EMB AMM, OPS CHECK GOOD.SDR R61A20100070Indication Sys · malfunctionedCREW REPORTED THE L-1 DOOR INDICATION WAS SHOWING ALL WHITE. MAINTENANCE WAS DISPATCHED TO THE A/C TO TROUBLESHOOT. MAINTENANCE PLACED THE L-1 DOOR ARM/DISARM INDICATION ON MEL 52-70-01-03.SDR R61A20090048Pin · out of positionMAINTENANCE REPORTED 2L DOOR BUSSEL PIN HANGING OUTSIDE OF DOOR. MAINTENANCE RE-SECURED L2 BUSSEL PIN IAW EMB AMM.
Back to N135HQ