N101HQ
Service difficulty reports · 74
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 = 'N101HQ' 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 = 'N101HQ' 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 R61A201411201198Wire Harness · damagedCREW RECEIVED NR 2 ENGINE FIRE WARNING MESSAGE. AN EMERGENCY WAS NOT DECLARED AND CREW LANDED WITHOUT INCIDENT. ACFT REMAINS OUT OF SERVICE.SDR R61A201408080968Unknown · noiseCREW HEARD A LOUD THUMPING NOISE UNDER THE COCKPIT AND FRONT GALLEY. AFTER ACCLERATION THE NOISE BECAME MORE FREQUENT, SLOWING DOWN THE NOISE BECAME LESS FREQUENT. RETURNED TO DEPARTURE. DECLARED AN EMERGENCY AND DIVERTED. MADE ONE LOW APPROACH SO THE TOWSDR R61A201406200774Panel · corrodedFOUND LAVATORY SERVICE PANEL EXTERIOR SIDE LEADING EDGE WITH CORROSION. MX R & R WASTE SERVICE PANEL IAW SRM 51-40-00. PN 170-86668-403, WASTE SERVICE DOOR.SDR R61A201403150378Button · missingCREW REPORTED THAT THE F/A MEGAPHONE VOLUME CONTROL BUTTON WAS MISSING. MAINTENANCE R & R MEGAPHONE IAW AMM AND OPS CHECKED GOOD. ACFT IS GOOD FOR SERVICE.SDR R61A201311081121Girt Bar · dirtyCREW REPORTED THAT THE L2 DOOR ARMED INDICATION IS ONLY PARTIALLY SHOWING. MAINTENANCE CLEANED GIRT BAR ATTACH POINTS IAW AMM AND OPS CHECKED GOOD. ACFT IS GOOD FOR SERVICE.SDR R61A201309230909Girt Bar · out of adjustCREW REPORTED L2 DOOR WILL NOT DISARM. RESEATED GIRT BAR ON L2 DOOR IAW AMM AND OPS CHECKED GOOD. ACFT IS GOOD FOR SERVICE.SDR R61A201308070704Megaphone · weakCREW REPORTED THAT THE AFT F/A MEGAPHONE APPEARS TO BE WEAK. MX R & R AFT MEGAPHONE IAW AMM AND OPS CHECKED GOOD.SDR R61A201306250557Flashlight · unsecureCREW REPORTED THAT THE AFT F/A FLASHLIGHT DOES NOT INDICATE A CHARGE CONSISTENTLY. MX SECURED AFT F/A FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201306180546Slide · defectiveFA WAS HAVING TROUBLE CLOSING THE R2 DOOR. MX FOUND THE LACES ON THE SLIDE BAG ARE PULLED AND THE SLIDE IS FALLING OUT OF THE BAG. MX DEPLOYED THE SLIDE SO THE ACFT COULD BE FLOWN VIA MX FERRY. MX FOUND THE FLEXBALL KIT CABLE WAS BROKEN WHICH CAUSED THE GIRTSDR R61A201304130368Mask · missingCREW REPORTED THAT THE FORWARD FLIGHT ATTENDANT REQUIRES A DEMO OXYGEN MASK. MAINTENANCE INSTALLED NEW DEMO OXYGEN MASK PER EMB AMM AND OPS CHECKED GOOD.SDR R61A201303140288Rib · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT RIB 52 WHEEL WELL FORWARD BULKHEAD CRACKED AT PREVIOUS REPAIR. MAINTENANCE STOP DRILLED CRACK IAW EMB 175 SRM 53-22-04. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201303130290Shaft · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE AFT CARGO DOOR AFT DRIVE ROD SHAFT CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFT CARGO DOOR AFT DRIVE ROD SHAFT IAW EMB 175 AMM 52-32-24. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201303130289Seal Seat · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE AFT CARGO DOOR LOWER SILL SEAL REST CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFT CARGO DOOR LOWER SILL SEAL REST IAW EMB 175 SRM 51-40-02, AND 51-40-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHESDR R61A201303130275Attach Bolt · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LOWER EMERGENCY SLIDE ON L2 DOOR ATTACH BOLT CORRODED. MAINTENANCE REMOVED AND REPLACED ATTACH BOLT IAW EMB 175 AMM 52-12-40. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201303120291Spar · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT HORIZONTAL LEADING EDGE SPAR FLANGE CRACKED. MAINTENANCE REPAIRED THE RIGHT HORIZONTAL STABILIZER SPAR FLANGE IAW EMB ETD 2013-170-004305A REV A. "MAJOR REPAIR" THE AIRCRAFT IS CURRENTLY WAITING SDR R61A201303120276Hinge · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LAVATORY SERVICE DOOR HINGE HALF CORRODED. MAINTENANCE REMOVED AND REPLACED THE LAVATORY SERVICE DOOR HINGE IAW EMB 175 SRM 51-41-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201212110716Sensor · faultyCREW REPORTED SLAT FAIL MESSAGE IN FLIGHT. CREW DECLARED EMERGENCY AND RETURNED TO FIELD. MAINTENANCE T/S TO LEFT T1 SKEW SENSOR PER EMB AMM. MAINTENANCE REMOVED AND REPLACED LEFT INBOARD SLAT T1 SKEW SENSOR PER EMB AMM AND OPS CHECK GOOD.SDR R61A201210200594Light · inoperativeCREW REPORTED THE EMERGENCY LIGHTS ON CABIN CEILING PANEL ARE INOP. MAINTENANCE REPLACED THE LIGHTING ASSEMBLY. PARTS INFORMATION TO BE UPDATED WHEN AVAILABLE.SDR R61A201209300551Heat Exchanger · faultyCREW REPORTED WHILE APPLYING TAKEOFF POWER THEY NOTICED A GAS/CHEMICAL SMELL THAT LASTED THROUGH 3000FT. MAINTENANCE TROUBLESHOT TO A BAD HEAT EXCHANGER. MAINTENANCE REMOVED AND REPLACED THE DUAL PACK HEAT EXCHANGER PER EMB AMM.SDR R61A201206020304Rib · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT WING RIB 10 AT SPAR 2 CRACKED. MAINTENANCE REMOVED AND REPLACED THE RIB 10 AT SPAR 2 ON THE LEFT WING IAW EMB 175 SRM 51-43-03 AND 51-43-04. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201206020302Doubler · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE DOUBLER ON THE WATER SERVICE BOX CORRODED. MAINTENANCE REMOVED AND REPLACED THE DOUBLER ON THE WATER SERVICE BOX IAW EMB 175 SRM 51-43-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201206020301Doubler · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND DOUBLER ON WATER SERVICE BOX CORRODED. MAINTENANCE REMOVED AND REPLACED THE DOUBLER ON THE WATER SERVICE BOX IAW EMB175 SRM 51-43-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A20110208Power Unit · failedMAINTENANCE REPORTED NR 1 EMERGENCY LIGHT POWER UNIT FAILED TEST. MAINTENANCE REMOVED AND REPLACED NR 1 ELPU PER EMB AMM, OPS CHECK GOOD.SDR R61A200800009Wire Harness · defectiveCREW REPORTED SLAT FAIL MESSAGE ON APPROACH. CREW FOLLOWED QRH PROCEDURES AND LANDED WITHOUT INCIDENT. MAINTENANCE TROUBLESHOT AND FOUND SLAT 3/4 HARNESS TO BE BAD. REMOVED AND REPLACED SLAT SKEW SENSOR WIRING HARNESS OPERATIONAL CHECK GOOD.
Back to N101HQ