N107HQ
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 = 'N107HQ' 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 = 'N107HQ' 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 R61A201509090669Seal Rest · corrodedHEAVY CHECK WAS REPORTED, AFT CARGO DOOR FWD, AFT CORNER SEAL REST IS CORRODED. MAINTENANCE R & R AFT CARGO DOOR FWD, AFT CORNER SEAL REST IAW SRM 51-40-02, 51-21-02, 51-23-06, 20-10-01. PN 170-85492-403 SEAL REST.SDR R61A201509090668Finger Doubler · corrodedDURING HEAVY CHECK WAS REPORTED THAT FWD CARGO DOOR BEAM AFT FINGER DOUBLER IS CORRODED. MAINTENANCE R & R FWD CARGO DOOR BEAM AFT FINGER DOUBLER IAW SRM 51-40-02, 51-23-04, 51-43-02, PN 170-67115-002, DOUBLER.SDR R61A201509090665Splice · corrodedDURING HEAVY CHECK, SPLICE PLATE AT RT SHEAR PANEL FRAME 87-88 AND OTBD SILL. MAINTENANCE R & R SPLICE PLATE AT RT SHEAR PANEL FRAME 87-88 AND OTBD SILL IAW SRM 51-42-02, 51-40-02, PN 170-65644-001 SPLICE.SDR R61A201509090664Stiffener · corrodedDURING HEAVY CHECK, AFT LATERAL STIFFENER AT DRAIN MAST DOUBLER BETWEEN FRAMES 86-87, STR 27-28R IS CORRODED. MAINTENANCE R & R AFT LATERAL STIFFENER AT DRAIN MAST DOUBLER BETWEEN FRAMES 86-87 STR 27-28R IAW SRM 51-41-01, 51-41-02.SDR R61A201509090662Shear Plate · corrodedDURING HEAVY CHECK, LT SHEAR PLATE FRAME 87-88 IS CORRODED. MAINTENANCE R & R LT SHEAR PLATE FRAME 87-88 IAW SRM 51-42-01, 51-40-02.SDR R61A201509090660Support Bracket · corrodedDURING HEAVY CHECK, PANEL SUPPORT BRACKET AT FRAME 87 BETWEEN RT BEAM Y10.784 AND OTBD SILL IS CORRODED. MX R & R PANEL SUPPORT BRACKET AT FRAME 87 BETWEEN RT BEAM Y10.784 AND OTBD SILL IAW SRM 51-41-02, 51-40-02, 51-41-01, PN 170-66797-001, SUPPORT.SDR R61A201509090659Splice · corrodedDURING HEAVY CHECK LT CENTER SPLICE FRAME 89 IS CORRODED. MX R & R THE SPLICE FRAME 89 IAW SRM 51-43-01, PN 170-861130-001, CENTER SPLICE.SDR R61A201509090658Shear Plate · corrodedDURING HEAVY CHECK, CENTER SHEAR PLATE AT FRAMES 87-88 IS CORRODED. MAINTENANCE R & R THE SHEAR PLATE IAW SRM 51-42-01, 52-41-02.SDR R61A201509090657Shear Plate · corrodedDURING HEAVY CHECK, RT SHEAR PLATE AT FRAME 87-88 IS CORRODED. MAINTENANCE R & R THE SHEAR PLATE IAW SRM 51-42-01, 51-40-02.SDR R61A201509090655Shear Tie · corrodedDURING HEAVY CHECK, THE SHEAR TIE AT FRAME 75, STRINGERS 27-28R FOUND CORRODED. MAINTENANCE R & R THE SHEAR TIE IAW 170 SRM 51-41-01, AND 51-41-02.SDR R61A201509090654Shear Tie · corrodedDURING HEAVY CHECK, THE SHEAR TIE AT FRAME 75, STRINGER 27-28R FOUND CORRODED. MAINTENANCE R & R SHEAR TIE IAW SRM 170 51-41-01, 51-41-02.SDR R61A201509090652Bracket · corrodedDURING HEAVY CHECK, BRACKET ON BACK SIDE OF LAV SERVICE PAN IS CORRODED. MAINTENANCE R & R BRACKET ON BACK SIDE OF LAV SERVICE PAN IAW SRM 51-43-01. PN 170-87889-401 BRACKET.SDR R61A201509090651Floor Support · corrodedDURING HEAVY CHECK, LT PANEL SUPPORT FRAME 88-90 IS CORRODED. MAINTENANCE R & R LT PANEL SUPPORT FRAME 88-90 IAW SRM 170 51-41-02, 51-41-01.SDR R61A201501080025Flashlight · inoperativeCREW REPORTED THAT THE FORWARD F/A FLASHLIGHT WAS INOPERATIVE.SDR R61A201412101231Flashlight · dimCREW REPORTED THAT THE FORWARD F/A FLASHLIGHT IS VERY DIM.SDR R61A201411221209Skin · damagedDURING HEAVY CHECK, SKIN DAMAGED FRAME 21 ABOVE STRINGER 27L. REPAIRED THE SKIN IAW ETD 2014-170-098904, REV C.SDR R61A201409071048Strap · missingCREW REPORTED THAT THE AFT F/A FLASHLIGHT STRAP WAS MISSING. MAINTENANCE R & R AFT F/A FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201403200414Light · looseCREW REPORTED THAT THE EMERGENCY LIGHT IN FRONT OF SEAT 1D WAS NOT SECURED TO THE FLOOR. MAINTENANCE SECURED LIGHT IAW AMM AND OPS CHECKED GOOD. ACFT IS GOOD FOR SERVICE.SDR R61A201308260783Bracket · brokenCREW REPORTED THE MEGAPHONE BRACKET WAS BROKEN. MX RESECURED BRACKET IAW AMM AND OPS CHECKED GOOD.SDR R61A201307130615Torque Tube · corrodedWHILE ACFT WAS IN FOR HEAVY CHECK FOUND LT FLAP TORQUE TUBE NR 6 HAS CORROSION TO MALE END. MX R & R L FLAP TORQUE TUBE F6 IAW AMM 27-51-03. PN 5912949-3. ACFT RETURNED TO SERVICE.SDR R61A201307130614Torque Tube · corrodedWHILE ACFT WAS IN FOR HEAVY CHECK FOUND RT FLAP TORQUE TUBE NR 6 HAS CORROSION TO MALE END. MX R & R RT FLAP TORQUE TUBE F6 IAW AMM 27-51-03, PN 5912949-3. ACFT WAS RETURNED TO SERVICE.SDR R61A201307080613Structure · corrodedWHILE ACFT WAS IN FOR HEAVY CHECK, FOUND AFT GALLEY HAS CORROSION AT MATING SURFACE AND DAMAGED TRIM ON FWD FWD SECTION FRONT. MX R & R CORRODED TRIM IAW AMM 25-00-23. PN 170-59523-001. ACFT RETURNED TO SERVICE.SDR R61A201307080594Bolt · corrodedDURING HEAVY CHECK, FOUND CORROSION ON RT MLG SIDE STAY BOLT. MX R & R BOLT IAW AMM 32-11-05. ASDR R61A201307070598Damper · corrodedDURING HEAVY CHECK, FOUND AFT SERVICE DOOR DAMPER IS CORRODED. MX R & R L2 DOOR DAMPER IAW AMM 52-12-27.SDR R61A201307060612Bolt · corrodedWHILE ACFT WAS IN FOR HEAVY CHECK, FOUND R2 DOOR GRIT BAR HARDWARE CORRODED. MX R & R HARDWARE IAW AMM 52-42-41. ACFT RETURNED TO SERVICE.SDR R61A201307060611Bolt · corrodedWHILE ACFT WAS IN FOR HEAVY CHECK, FOUND L1 DOOR GIRT BAR HARDWARE CORRODED. MX R & R L1 DOOR GIRT BAR HARDWARE IAW AMM 52-41-04. ACFT RETURNED TO SERVICE.SDR R61A201307060600Damper · corrodedDRUING HEAVY CHECK, FOUND R1 DAMPER HAD CORROSION AT THE THREADS ON THE BARREL AND JAMNUT. MX R & R R1 DOOR DAMPER IAW AMM 52-41-27.SDR R61A201307060599Damper · corrodedDURING HEAVY CHECK, FOUND L1 DOOR DAMPER HAS CORROSION ON PLUNGER AND THREADS ON BARREL. MX R & R DAMPER IAW AMM 52-11-27.SDR R61A201307050597Damper · corrodedWHILE ACFT WAS IN FOR HEAVY CHECK FOUND AFT SERVICE DOOR DAMPER IS CORRODED. MX R & R AFT SVC DOOR DAMPER IAW AMM 52-42-27.SDR R61A201307060593Bracket · crackedDURING HEAVY CHECK, FOUND LT PACK RAM AIR EMERGENCY CHECK VALVE BRACKET CRACKED. MX R & R BRACKET IAW SRM 51-41-01.SDR R61A201306240555Light · unsecureCREW REPORTED THAT THE PHOTOLUMINESCENT STRIP NEXT TO SEAT 1D WAS NOT ATTACHED. MX SECURED PHOTOLUMINESCENT STRIP IAW AMM AND OPS CHECKED GOOD.SDR R61A201305190474Spar · crackedWHILE PERFORMING A LECK CHECK ON A RT WING FUEL LEAK. MX DISCOVERED A CRACK. INSPECTION VERIFIED CRACK PRESENT WITH EDDY CURRENT FROM THE A3 HOLE AFT SPAR AT RIB 10. REPAIRED IAW ETD2013-170-009240, REV B. MAJOR REPAIRSDR R61A201304300436Glowstrip · detachedCREW REPORTED THAT THE PHOTO LUMINESCENT STRIP NEAR THE FORWARD GALLEY IS DETACHED. MAINTENANCE RE-SECURED PHOTO LUMINESCENT STRIP PER EMB AMM 33-50-21 AND OPS CHECKED GOOD.SDR R61A201303020211Bracket · brokenCREW DISCOVERED MEGAPHONE BRACKET DAMAGED. MAINTENANCE RE-SECURED MEGAPHONE BRACKET PER EMB AMM 25-62-03 AND OPS CHECKED GOOD.SDR R61A201302120146Glowstrip · missingPHOTO LUMINESCENT STRIP MISSING IN FRONT OF A/C. MAINTENANCE RE-SECURED STRIP PER EMB AMM 25-24-01. OPS CHECKED GOOD.SDR R61A20130124074Light · detachedEMERGENCY PACK LIGHTING STRIP DETACHED AT ROW NR 1. MAINTENANCE RE-SCURED STRIP PER EMB AMM.SDR R61A20130124071Accessory Unit · faultedWHILE EN ROUTE FROM IND TO DCA, AIRCRAFT HAD AN AVIONICS MAU FAULT, ALONG WITH BRAKE FAILURE MESSAGE. CREW DECLARED EMERGENCY, DIVERTED TO PIT AND LANDED WITHOUT INCIDENT. MAINTENANCE FOUND THE MAU 2B BAD AND CHANGED PER EMB AMM.SDR R61A20130124070Accessory Unit · faultedWHILE EN ROUTE FROM DCA TO IND, CREW RECEIVED A NUMBER OF FAULT MESSAGES WHICH LEAD THEM TO BELIEVE THEY HAD NO BRAKES. CREW DECLARED AN EMERGENCY AND LANDED AT IND WITHOUT INCIDENT AND WITH BRAKES WORKING NORMALLY. MAINTENANCE FOUND THE MAU 2B BAD AND CHANGSDR R61A201210290612Unknown · fumesCREW REPORTED EXHAUST FUMES IN THE COCKPIT IT SMELLED OF DE-ICE FLUID. MAINTENANCE TROUBLESHOT THE EXHAUST FUMES IN THE COCKPIT BY STARTING THE APU WITH BLEEDS ON. RAN BOTH PACKS TO REMOVE THE FUMES REF AMM 36-10-00/49-10-0.SDR R61A201207250385Seat Track · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND CORROSION ON THE FORWARD LEFT INBOARD FUSELAGE SEAT TRACK EXTENSION. MAINTENANCE REMOVED AND REPLACED THE FORWARD LEFT INBOARD SEAT TRACK EXTENSION IAW EMB 175 SRM 51-43-01, 51-41-01. THE AIRCRAFT IS OUT OFSDR R61A201207240386Doubler · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE DOUBLER BETWEEN FRAMES 13 AND 16 CORRODED. MAINTENANCE REMOVED AND REPLACED THE FLOOR DOUBLER BETWEEN FRAMES 13 AND 16 IAW EMB 175 SRM 51-40-02 AND 51-41-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECSDR R61A201205050280Lanyard · out of positionCREW REPORTED R1 DOOR WILL NOT DISARM. MAINTENANCE RE-INSTALLED DOOR LANYARD PIN PER EMB AMM, AND DOOR OPS CHECKED GOOD.SDR R61A20110395Fitting · defectiveCREW REPORTED L-2 DOOR WOULDN'T DISARM. MAINTENANCE REMOVED AND REPLACED L-2 DOOR ESCAPE SLIDE FITTING ASSY'S AND ADJUSTED L-2 DOOR AFT COMMAND RAMP, OPS CHECK GOOD.SDR R61A20110390Fitting · out of adjustCREW REPORTED L-2 DOOR WAS JAMMING AND BINDING. MAINTENANCE ADJUSTED FLOOR FITTING AT THE BOTTOM OF THE DOOR PER EMB AMM, OPS CHECK GOOD.SDR R61A20110384Nut · corrodedWHILE A/C WAS IN FOR HEAVY CHECK FOUND FWD CARGO DOOR, AFT VENT DOOR CABLE ROD END HAS EVIDANCE OF CORRODED HARDWARE. MX REMOVED AND REPLACED CORRODED HARDWARE IAW EMB 170/175 AMM 52-31-25. P/N MS14144-4 AND NAS6404A14D. A/C REMAINS IN CMH FOR HEAVY CHECK CSDR R61A20110383Latch · corrodedWHILE A/C WAS IN FOR HEAVY CHECK FOUND BRASS DOOR HOLD OPEN LOCK AT PNL 132BZ LOC IS CORRODED. MX REMOVED AND REPLACED LATCH IAW EMB 175 AMM 52-31-28 P/N 170-84599-407. A/C REMAINS IN CMH FOR HEAVY CHECK COMPLETION.SDR R61A20110316Service Panel · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE WASTE SERVICE BOX CORRODED. MAINTENANCE REMOVED AND REPLACED THE WASTE SERVICE BOX IAW EMB 175 SRM 51-43-02. THE AIRCRAFT IS IN CMH SCHEDULED FOR A TEST FLIGHT AND POSSIBLE RETURN TO SERVICE TODAY AT 11SDR R61A20110312Gusset · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND ON THE LT LONGITUDINAL SPLICE PLATE AT FRAME 90. MAINTENANCE REMOVED AND REPLACED THE GUSSETS IAW EMB 175 SRM 51-41-02. P/N'S 170-60261-001 (GUSSET) & 170-60257-001 (GUSSET). AIRCRAFT CURRENSDR R61A20110313Panel · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND ON THE LT SHEAR PANEL AT FRAMES 87-88. MAINTENANCE REMOVED AND REPLACED THE LT SHEAR PLATE AT AFT GALLEY FLOOR STRUCTURE AT FRAME 87-88 IAW EMB 175 SRM 51-40-02 & 51-42-01. AIRCRAFT IS CURRENSDR R61A20110314Panel · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND ON THE CENTER SHEAR PANEL AT FRAMES 87-88. MAINTENANCE REMOVED AND REPLACED THE CENTER SHEAR PANEL AT FRAMES 87-88 IAW EMB 175 SRM 51-42-01, 51-42-03, 51-43-01 & 51-40-02. AIRCRAFT IS CURRENT
Back to N107HQ