N105HQ
Service difficulty reports · 111
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 = 'N105HQ' 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 = 'N105HQ' 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 R61A201803170343Gusset · corrodedREPLACED FRAME 90 FLOORBEAM RIGHT GUSSET REF SRM 51-23-05.SDR R61A201803170342Splice · corrodedREMOVED AND REPLACED AFT WET AREA AT FM 90 CENTER INTERCOSTAL SPLICE IAW SRM 51-43-01.SDR R61A201803170341Panel Support · corrodedREMOVED AND REPLACED PANEL SUPPORT BRACKETS 2 EA AFT WET ARE FR 87 LT AND RT REF SRM 51-41-01.SDR R61A201803170340Floor Support · corrodedREMOVED AND REPLACED FLOOR SUPPORT FR 16 TO 17 REF SRM 51-40-08.SDR R61A201803170339Floor Support · corrodedREMOVED AND REPLACED FLOOR SUPPORT AT RT FR 17 IAW SRM 51-41-01.SDR R61A201803170338Floor Support · corrodedREMOVED AND REPLACED FLOOR SUPPORT RT FR 16 IAW SRM 51-41-01.SDR R61A201803170337Floor Support · corrodedREMOVED AND REPLACED FLOOR SUPPORT AT RT FR 14 IAW SRM 51-41-01.SDR R61A201803170336Seat Track · corrodedREMOVED AND INSTALLED NEW RT FWD SEAT TRACK FR 12 - 20 IAW SRM 51-40-08.SDR R61A201803170335Seat Track · corrodedINSTALLED REPAIR DOUBLER AND FILLER LT SEAT TRACK FR 12 TO 20 IAW SRM 53-10-10 AND ETD 2018-170-020241.SDR R61A201803170333Service Door · corrodedREMOVED AND REPLACED WASTE SERVICE DOOR REF AMM 53-03-60.SDR R61A201803170334Door Sill · corrodedREMOVED AND REPLACED LT FWD SILL IN FWD FUSELAGE WET AREA IAW SRM 51-40-08.SDR R61A201711250891A/C Pack · smokeHEARD A BUZZING NOISE IN FLIGHT WITH AN ELECTRICAL SMELL. NO MESSAGES OR ANYTHING, NO INDICATIONS. CREW SUSPECTS IT IS COMING FROM PACK 1, NOISE AND SMELL WENT AWAY WHEN THEY TURNED IT OFF ON THE GROUND. R & R THE 1 PACK AIR CYCLE MACHINE IAW AMM 21-51-05. OPSDR R61A201711090840Connector · unsecureOVERHEAD, COCKPIT EMERGENCY EXIT SIGN DOES NOT ILLUMINATE. SECURED THE CONNECTOR ON CEILING PANEL AND EMERGENCY LIGHT OPS CHECKED GOOD IAW AMM 33-50-05.SDR R61A201701040009Battery Pack · inoperativeCREW REPORTED THAT THE COCKPIT EMERGENCY LIGHT WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED BATTERY PACK NR 1 IAW AMM AND OPS CHECKED GOOD.SDR R61A201608020448Ramp · defectiveCREW REPORTED THAT THE L1 UPPER LEFT DOOR LATCH INDICATOR WAS NOT SHOWING GREEN WHEN DOOR WAS CLOSED AND LOCKED. MAINTENANCE PLACED ON MEL AND LATER R & R GUIDE RAMP ON L1 DOOR IAW AMM AND OPS CHECKED GOOD.SDR R61A201606200391Girt Bar · out of adjustCREW REPORTED THAT THE L1 DOOR WOULD NOT DISARM AND THE L2 DOOR ASSIST BOTTLE WAS BLOWN. ACFT WAS FLOWN VIA MAINTENANCE FERRY WHERE MAINTENANCE ADJUSTED L1 DOOR GIRT BAR AND SERVICED L2 DOOR ASSIST BOTTLE IAW AMM AND OPS CHECKED GOOD.SDR R61A201605020297Slide · partial deployMAINTENANCE REPORTED THAT THE L1 DOOR SLIDE BECAME PARTIALLY DEPLOYED. MAINTENANCE R & R L1 DOOR SLIDE IAW AMM AND OPS CHECKED GOOD.SDR R61A201512170939Indication Sys · malfunctionedCREW REPORTED THAT THE L1 DOOR SHOWS X WITH YELLOW WHEN THE DOOR IS CLOSED, LOCKED AND LATCHED.SDR R61A201512070902Relief Valve · leakingF/A REPORTED A STREAM OF FLUID COMING FROM THE RT WING AND CAPTAIN NOTED RT FUEL TANK WAS 300 POUNDS LOW. CREW DECLARED AN EMERGENCY AND DIVERTED. WITH EMERGENCY VEHICLES ROLLING, CREW LANDED AND TAXIED TO GATE WITHOUT INCIDENT. ACFT WAS FLOWN VIA MAINTENANCSDR R61A201503190177Blade · bird ingestionCREW HEARD LOUD NOISE AFTER BRINGING THE GEAR UP. NR 2 ENGINE WENT AMBER, DECLARED AN EMERGENCY AND RETURNED TO DEPARTURE WITHOUT INCIDENT. MAINTENANCE INSPECTED AND FOUND NUMEROUS DAMAGED FAN BLADES DUE TO BIRD STRIKE. ACFT REMAINS OUT OF SERVICE. REPLASDR R61A201412261260Light · inoperativeCREW REPORTED THAT THE EMERGENCY LIGHT STRIP ON THE RT SIDE OF THE FIRST SECTION WAS INOPERATIVE. R & R THE EMERGENCY LIGHT STRIP IAW AMM AND OPS CHECKED GOOD.SDR R61A201412201251Flashlight · inoperativeCREW REPORTED THAT BOTH FLIGHT DECK FLASHLIGHTS WERE INOPERATIVE. MAINTENANCE REPLACED FLASHLIGHTS AND BATTERIES IAW AMM AND OPS CHECKED GOOD.SDR R61A201410261129Flashlight · inoperativeCREW REPORTED THAT THE FORWARD F/A FLASHLIGHT WAS NOT CHARGING.SDR R61A201410201124Flashlight · inoperativeCREW REPORTED THAT THE CAPTAIN`S FLASHLIGHT WAS INOPERATIVE. MAINTENANCE R & R THE FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201310301079Cradle · brokenCREW REPORTED THAT THE FORWARD F/A FLASHLIGHT HOLDER WAS BROKEN. MAINTENANCE R & R THE F/A FLASHLIGHT HOLDER IAW AMM AND OPS CHECKED GOOD.SDR R61A201310281075Flashlight · brokenCREW REPORTED THAT THE CAPTAIN`S FLASHLIGHT WAS BROKEN. MX INSTALLED A NEW FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201310111003Buss · inoperativeCREW REPORTED THAT THE FLIGHT DECK AND CABIN FLASHLIGHTS ARE NOT CHARGING. MAINTENANCE FOUND CIRCUIT BREAKER BUSS AND SECURED IAW AMM. OPS CHECKED GOOD.SDR R61A201309100861Flashlight · inoperativeAFT F/A REPORTED THAT THE AFT F/A FLASHLIGHT INOPERATIVE. MX R & R FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201308190751Sensor · failedAT APPROXIMATELY 1000 FT, RECEIVED A CAUTION MESSAGE AND CHIME FOR SLAT FAIL. SLATS WERE IN POSITION 3 AND FLAPS CONTINUED TO WORK. DECLARED AN EMERGENCY, RAN SLAT/FLAP FAIL PROCEDURES AND LANDED WITHOUT INCIDENT. MX FOUND THAT BOTH LT OTBD SKEW SENSORS HADSDR R61A201306270564Girt Bar · out of adjustCREW REPORTED R2 DOOR WAS JAMMED AND WOULD NOT OPEN. MX FOUND THE GIRT BAR OUT OF ADJUSTMENT. ADJUSTED AFT LOWER GIRT BAR PLATE CLIP IAW AMM. OPS CHECKED GOOD.SDR R61A201306150562Nut · corrodedDURING HEAVY CHECK, FOUND FWD LOWER GUIDE RAMP ADJUSTMENT HARDWARE CORRODED. MX R & R HARDWARE LOCK NUT AND SET SCREW IAW AMM 53-10-21.SDR R61A201306120535Glowstrip · brokenCREW REPORTED THAT THE PHOTO LUMINESCENT STRIP AT SEAT 1D WAS BROKEN. MX R & R STRIP IAW AMM AND OPS CHECKED GOOD.SDR R61A201305270497Glowstrip · looseCREW REPORTED THAT THE PHOTO LUMINESCENT STRIP CAME OFF. MX REINSTALLED PHOTO LUMINESCENT STRIP IAW AMM AND OPS CHECKED GOOD.SDR R61A201304270429Cover · out of adjustCREW REPORTED THAT THE L1 DOOR WILL NOT LATCH OPEN. MAINTENANCE ADJUSTED ARM COVER FOR THE L1 DOOR PER EMB AMM AND OPS CHECKED GOOD.SDR R61A20130102001Sensor · looseCREW REPORTED LG WOW FAIL MESSAGE SHORTLY AFTER TAKEOFF. THE MESSAGE EXTINGUISHED ONCE THE LANDING GEAR WAS FULLY RETRACTED. THE CREW DECLARED AN EMERGENCY, RETURNED TO IND WITH EMERGENCY VEHICLES ROLLED AND LANDED WITHOUT INCIDENT. MAINTENANCE FOUND THE R1SDR R61A201207140369Floorbeam · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE INBOARD FF1 FLOORBEAM AT FRAME 17 CORRODED. MAINTENANCE REMOVED AND REPLACED THE INBOARD FF1 FLOORBEAM AT FRAME 17 IAW EMB 175 SRM 51-40-02, 51-41-00, 51-41-02, 51-43-01, 51-43-02, AND 51-23-06. THE AIRSDR R61A201207140368Seat Track · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE AFT LEFT SEAT TRACK BEAM AT FRAME 86 TO 87 CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFT LEFT SEAT TRACK BEAM AT FRAME 86 TO 87 IAW EMB 175 SRM 51-40-02, 51-41-01, 51-42-01, 51-43-01, AND 51-23-01. SDR R61A201207140367Doubler · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE AFT WASTE BOX DOUBLER CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFT WASTE BOX DOUBLER IAW EMB 175 SRM 51-40-02,AND 51-43-04. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201207140366Doubler · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LAV WASTE BOX DOUBLER CORRODED. MAINTENANCE REMOVED AND REPLACED LAV WASTE BOX DOUBLER IAW EMB 175 SRM 51-40-02 AND 51-43-04. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201207140365Splice · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE AFT RIGHT FLOOR SUPPORT BEAM SPLICE AT FRAME 86 TO 87 CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFT RIGHT FLOOR SUPPORT BEAM SPLICE AT FRAME 86 TO 87 IAW EMB 175 SRM 51-41-00, 51-43-00, 51-40-02, 51SDR R61A201207140364Floorbeam · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE AFT RIGHT FLOOR SUPPORT BEAM AT FRAME 86 TO 87 CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFT RIGHT FLOOR SUPPORT BEAM IAW EMB SRM 51-41-00, 51-43-00, 51-40-02 51-42-01, AND 51-43-01. THE AIRCRAFT ISDR R61A201202020085Windshield · faultyWHILE IN CRUISE FLIGHT FROM PHL TO MCI, PILOTS NOTICED A ODOR THAT WAS ONLY NOTED IN THE FLIGHT DECK. THE CREW DECIDED TO DIVERT TO CMH AND DECLARED EMERGENCY. MAINTENANCE PERFORMED OPPS CHECK OF AC SYSTEMS, PACKS, RAN ENGINES, AND NOTICED THAT THE WINDSHIELSDR R61A20110335Door · out of adjustCREW REPORTED R-1 DOOR DIFFICULT TO OPERATE. MAINTENANCE RE-ADJUSTED R-1 DOOR PER EMB AMM, OPS CHECK GOOD.SDR R61A20110242Power Unit · inoperative*** GENEREATED WHILE A/C WAS IN HEAVY CHECK *** ALL EMERGENCY LIGHTS ON R-1 DOOR INOP. MAINTENANCE REMOVED AND REPLACED THE RT FWD EMERGENCY LIGHT POWER UNIT PER EMB AMM, OPS CHECK GOOD.SDR R61A20110240Doubler · misinstalled*** WHILE AIRCRAFT WAS IN FOR HEAVY CHECK *** LARGE RECTANGULAR PATCH AT FR 28, STR 13L DOES NOT APPEAR TO BE EDGE SEALED. MAINTENANCE PERFORMED A MAJOR REPAIR IAW EMB ETD2011-170-101683 REV E & EMB 175 SRM 53-21-01. REFERENCE PO #'S 024093-2011 & 023526-201SDR R61A20110241Shear Plate · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK CMH, MAINTENANCE FOUND CENTER SHEAR PLATE CORRODED AT FRAME 87 AND 88. MAINTENANCE REMOVED AND REPLACED THE CENTER SHEAR PLATE IAW EMB 175 SRM 51-42-01 AND 02. AIRCRAFT REMAINS OUT OF SERVICE AND IS STILL IN C CHECK.SDR R61A20110238Floorbeam · corroded*** WHILE AIRCRAFT WAS IN FOR HEAVY CHECK *** LEVEL TWO CORROSION WAS FOUND IN THE AFT GALLEY/LAV AREA, CTR RT FLOORBEAM TIE PLATE AT FR 90. MAINTENANCE REMOVED AND REPLACED THE RT SHEAR PLATE AT FR 90 IAW EMB 175 SRM 51-41-02. AIRCRAFT IS STILL CURRENTLY OUSDR R61A20110237Floorbeam · corroded*** WHILE AIRCRAFT WAS IN FOR HEAVY CHECK *** LEVEL TWO CORROSION WAS FOUND IN THE AFT GALLEY/LAV AREA, CTR LT FLOORBEAM TIE PLATE AT FR 90. MAINTENANCE REMOVED AND REPLACED LT SHEAR PLATE AT FR 90 IAW EMB 175 SRM 51-41-02. AIRCRAFT IS CURRENTLY STILL OUT OFSDR R61A20110236Plate · corroded*** WHILE AIRCRAFT WAS IN FOR HEAVY CHECK *** LEVEL TWO CORROSION WAS FOUND IN THE AFT LAV AREA, LT SILL TIE PLATE AT FR 87-88. MAINTENANCE REMOVED AFT LAV LT SILL SPLICE PLATE AND INSTALLED SERVICEABLE SPLICE PLATE IAW EMB 175 SRM 51-42-02. AIRCRAFT STILL OSDR R61A20110235Shear Plate · corroded*** WHILE AIRCRAFT WAS IN FOR HEAVY CHECK *** LEVEL TWO CORROSION WAS FOUND IN THE AFT LAV AREA, LT SHEAR PLATE AT FR 87-88. MAINTENANCE REMOVED AND REPLACED THE LT SHEAR PLATE IAW EMB 175 SRM 51-42-01 & 02. AIRCRAFT STILL OUT OF SERVICE FOR HEAVY CHECK COMP
Back to N105HQ