N111HQ
Service difficulty reports · 125
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 = 'N111HQ' 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 = 'N111HQ' 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 R61A201703250245Door Sill · corrodedDURING HEAVY MX CK, FWD RT FLOOR SILL CORRODED AND HAS ELONGATED HOLES AS MARKED FR 13-14 STR 17R. REMOVED AND REPLACED FWD RT SILL PANEL FR 12-14 AND APPLIED SURFACE PROTECTION REF SRM 51-12-01, 51-41-02, 51-43-04, 51-23-04, 51-40-02, 51-23-06.SDR R61A201703250244Shear Panel · corrodedDURING HEAVY MX CHECK. AFT WET AREA CENTER SHEAR PANEL CORRODED AS MARKED BETWEEN FR 87-88. REMOVED AND REPLACED CENTER SHEAR
PNL REF SRM 51-40-02,51-42-01.SDR R61A201703250243Beam · corrodedDURNING HEAVY MX CHECK, CORROSION AROUND FWD AND AFT GIRT FITTING SPOTFACE AND ONE AREA OUTSIDE THE AFT GIRT BAR FITTING AS MARKED. REMOVED AND REPLACED AFT SERVICE DOOR LOWER THRESHOLD BEAM IN REF TO SRM 51-41-01, SRM 51-43-01,02.SDR R61A201703250242Frame · damagedDURING HEAVY MAINTENANCE, ARC DAMAGE FROM LHCBP THAT CONTACTED FR10 BETWEEN STR 12L AND 13L. CUT-OUT AND FORMED L SHAPED ANGLE REPAIR WITHOUT A FILLER PER ETD2017-170-024953-ASDR R61A201608250508Indicator · defectiveCREW REPORTED THAT THE L2 DOOR LOCK VISUAL INDICATOR WAS NOT SHOWING GREEN. MAINTENANCE PLACED ON MEL AND ACFT IS GOOD FOR SERVICE. MAINTENANCE REMOVED AND REPLACED VISUAL INDICATOR PER EMB AMM AND OPS CHECKED GOOD.SDR R61A201509230646Mau · malfunctionedCREW RECEIVED A ANVX MAU 1B FAIL MESSAGE ALONG WITH A SPOILER FAULT MESSAGE. CREW RAN QRH AND CONTACTED MAINTENANCE. CREW DECLARED AN EMERGENCY AND LANDED AT DCA WITHOUT INCIDENT. MAINTENANCE RESET MAU 1 AND PERFORMED RETURN TO SERVICE TEST IAW AMM AND OPS CHSDR R61A201507260461Warning Message · activatedCREW RECEIVED A MAU 1B FAIL MESSAGE. CREW RAN QRH AND DECLARED AN EMERGENCY. LANDED WITHOUT INCIDENT. MAINTENANCE DID A POWER RESET IAW AMM AND FAULT CLEARED. ACFT IS GOOD FOR SERVICE.SDR R61A201505210339Door Frame · damagedDURING HEAVY CHECK, FWD CARGO DOOR FRAME 27 DAMAGED HOLE AFT SIDE OF CARGO DOOR BEAM. MAINTENANCE REAMED HOLE IAW ETD2015-170-047841, INSTALLED REPAIR BUSHING IAW ETD2015-170-047841.SDR R61A201505210338Beam · damagedDURING HEAVY CHECK, FWD LOWER CARGO DOOR BEAM AT FRAME 27 HAS ONE SHEAR LOCK. MX REPLACED FWD LOWER CARGO DOOR BEAM IAW SRM 51-40-02, 51-23-04,51-43-01, AND 53-43-02,SDR R61A201505130318Gusset · corrodedDURING HEAVY CHECK, CROSSBEAM ASSY GUSSET AT FRAME 12 IS CORRODED. MX R & R CROSSBEAM ASSY GUSSET AT FRAME 12 IAW SRM 51-41-01.SDR R61A201505130315Gusset · corrodedDURING HEAVY CHECK, CROSSBEAM ASSY GUSSET AT FRAME 11 IS CORRODED. MAINTENANCE R & R CROSSBEAM ASSY GUSSET AT FRAME 11 IAW SRM 51-41-02, PN 170-13808-001, GUSSET. ACFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.SDR R61A201505110482Frame · corrodedDURING HEAVY CHECK, PANEL 523BB BEARING AREA OF FRAME 1 HAS CORROSION. MAINTENANCE R & R THE FRAME IAW SRM 51-43-04.SDR R61A201505110480Beam · corrodedDURING HEAVY CHECK, FWD CARGO LOWER BEAM IS CORRODED. MAINTENANCE R & R, LOCATED AND DRILLED NEW HOLES, REINSTALLED IAW SRM 51-40-01, 51-23-06.SDR R61A201505110477Hinge · corrodedDURING HEAVY CHECK, POTABLE WATER SERVICE ACCESS PANEL HINGE HALF IS CORRODED. MAINTENANCE R & R THE HINGE IAW AMM 53-03-62.SDR R61A201505110476Seal Rest · corrodedDURING HEAVY CHECK, FWD CARGO AFT CORNER SEAL REST IS CORRODED. MAINTENANCE R & R FWD CARGO AFT CORNER SEAL REST IAW SRM 51-23-04, 51-40-02, 20-10-01.SDR R61A201505110475Seal Rest · corrodedDURING HEAVY CHECK, FWD CARGO FWD CORNER SEAL REST IS CORRODED AND GOUGED. MAINTENANCE R & R FWD CARGO FWD CORNER SEAL REST IAW SRM 51-23-04, 51-40-02,20-10-01.SDR R61A201505080478Threshold · corrodedDURING HEAVY CHECK, R2 DOOR THRESHOLD AROUND RIVET HEAD OF GIRT BAR IS CORRODED. MAINTENANCE BLENDED IAW ETD 2015-170-046056.SDR R61A201505080316Seat Track · corrodedDURING HEAVY CHECK LT FLOOR TRACK AT FRAME 12-20 IS CORRODED. MAINTENANCE R & R LT FLOOR TRACK AT FRAME 12-20 IAW SRM 175 51-41-01, 51-41-02, 51-43-03, 51-43-04. PN 170-03264-001 TRACK. ACFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.SDR R61A201505070483Retainer · corrodedDURING HEAVY CHECK, WATER SERVICE RETAINERS HAVE CORROSION. MAINTENANCE R & R WATER SERVICE RETAINERS AND C/W SB 170-53-0095, WP H4605, SEQ 2582 FOR EO 170, EO -53-10-0020 FOR WORK DETAILS.SDR R61A2015050700483Upper Sheet · corrodedDURING HEAVY CHECK, UPPER SHEET HAS CORROSION AT RT 10.748, FRAMES 85 - 86. MX R & R UPPER SHEET IAW SRM 51-41-01, 51-43-03.SDR R61A201505070481Threshold · corrodedDURING HEAVY CHECK, L2 DOOR THRESHOLD AROUND GIRT BAR RIVETS ARE CORRODED. MX R & R THRESHOLD IAW SRM 51-21-01, 51-43-03, AND 51-43-04.SDR R61A201505070479Seat Track · corrodedDURING HEAVY CHECK, LEFT SEAT TRACK, Y 10.748 FRAME 84 IS CORRODED. REPAIRED IAW ETD 2015-170-046056.SDR R61A201505070320Gusset · corrodedDURING HEAVY CHECK, RT GUSSET PLATE AT FRAME 90 IS CORRODED. MAINTENANCE R & R GUSSET IAW SRM 51-43-02.SDR R61A201505070319Support · corrodedDURING HEAVY CHECK, RT PANEL SUPPORT FRAME 86-90 IS CORRODED. MAINTENANCE R & R RT PANEL SUPPORT FRAME 86-90 IAW SRM 51-42-01, 51-43-01.SDR R61A201505070317Retainer · corrodedDURING HEAVY CHECK DISCOVERED WATER SERVICE RETAINERS ARE CORRODED. MAINTENANCE REMOVED CORRODED WATER SERVICE RETAINERS AND PERFORMED SB 170-53-0095.SDR R61A201505070314Upper Sheet · corrodedDURING HEAVY CHECK, RT Y=10.748 UPPER SHEET FRAME 85-86 IS CORRODED. MX R & R RT Y=10.748 UPPER SHEET FRAME 85-86 IAW SRM 51-41-01, 51-43-03. PN 170-86101-001. SHEET ACFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.SDR R61A201505070313Beam · corrodedDURING HEAVY CHECK, RT BEAM Y=10.748, FRAMES 86-89 IS CORRODED. R & R THE BEAM IAW SRM 51-41-01, 51-43-03.SDR R61A201505070312Gusset · corrodedDURING HEAVY CHECK, RT GUSSET PLATE FRAME 90 IS CORRODED. R & R THE GUSSET PLATE IAW SRM 51-41-02, 51-40-02, 51-23-00.SDR R61A201505070311Threshold · corrodedDURING HEAVY CHECK, L2 DOOR THRESHOLD AROUND GIRT BAR RIVETS IS CORRODED. MAINTENANCE R & R L2 DOOR THRESHOLD BEAM IAW SRM 51-21-01, 51-43-03, 51-43-04, PN 170-65703-005. BEAM ACFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.SDR R61A201505070299Shear Plate · corrodedDURING HEAVY CHECK, LT SHEAR PLATE FRAME 87-88 IS CORRODED. MAINTENANCE R & R THE SHEAR PLATE FRAME 87-88 IAW SRM 51-42-03, 51-21-00.SDR R61A201505070298Shear Plate · corrodedDURING HEAVY CHECK, CENTER SHEAR PLATE AT FRAME 87-88 IS CORRODED. MAINTENANCE R & R THE CENTER SHEAR PLATE IAW SRM 51-21-00, 51-42-01.SDR R61A201505070297Shear Plate · corrodedDURING HEAVY CHECK, RT SHEAR PLATE AT FRAME 87-88 HAS CORROSION. MAINTENANCE R & R THE SHEAR PLATE IAW SRM 51-21-00, 51-42-02.SDR R61A201505070296Structure · corrodedDURING HEAVY CHECK, RT SILL FRAME 84 IS CORRODED. MX R & R RT SILL FRAME 84 IAW SRM 51-42-02,51-43-04.SDR R61A201412291264Engine · malfunctionedAT ABOUT 1000 FT, CREW REPORTED A LOUD NOISE COMING FROM THE NR 2 ENGINE. RECEIVED A NR 2 ENGINE CONTROL FAULT MESSAGE, RAN QRH AND PLACED THE NR 2 ENGINE IN IDLE, AT THAT POINT NOISE SUBSIDED. DECLARED AN EMERGENCY AND RETURNED TO DEPARTURE AND LANDED WITHOSDR R61A201412161238Tru · inoperativeCREW RECEIVED A NR 2 DC BUSS OFF, TRU 2 FAIL, MAU 3B FAIL, MAU 2A FAIL, RAT ALT 2 FAIL AND FWD CVR/DVR FAIL. DECLARED AN EMERGENCY AND DIVERTED. LANDED WITHOUT INCIDENT. R & R THE NR 2 TRAMSFORMER RECTIFIER UNIT, AMM AND OPS CHECKED GOOD. ACFT IS GOOD FORSDR R61A201412101232Light · unsecureCREW REPORTED THAT THE EMERGENCY LIGHT STRIP AT SEAT 1D CAME UP. MAINTENANCE SECURED THE LIGHT STRIP IAW AMM AND OPS CHECKED GOOD.SDR R61A201411231202Flashlight · inoperativeCREW REPORTED THAT THE CAPTAINS FLASHLIGHT WAS INOPERATIVE. MAINTENANCE R & R CAPTAIN`S FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201411151182Flashlight · inoperativeCREW REPORTED THAT THE F/O FLASHLIGHT WAS INOPERATIVE. R & R THE FLASHLIGHT IAW AMM.SDR R61A201411061157Flashlight · inoperativeMAINTENANCE REPORTED THAT THE FORWARD F/A FLASHLIGHT WAS INOPERATIVE. MAINTENANCE R & R FORWARD F/A FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201407010822Battery Pack · weakFORWARD F/A FLASHLIGHT DIM. REPLACED BATTERY IAW AMM 33-51-01. OPS CHECKED GOOD.SDR R61A201407010816Flashlight · dimAFT FLASHLIGHT DIM. R & R AFT F/A FLASHLIGHT ASSY IAW AMM 33-51-01. OPS CHECKED GOOD.SDR R61A201309250924Flashlight · inoperativeCREW REPORTED CAPTAINS FLASHLIGHT WAS NOT WORKING. MX R & R FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201307240659Rib · crackedDURING HEAVY CHECK, REPORTED SECOND INBD BRACKET ON LT HORIZONTAL STAB L/E CRACKED. MX REPAIRED RIB 5 ON LT HORZONTAL STAB L/E, PN 170-62334-001, RIB 5. ACFT REMAINS FOR COMPLETION OF HEAVY CHECK.SDR R61A201307180651Bolt · corrodedDURING HEAVY CHECK, FOUND AFT PASSENGER L2 DOOR EMERGENCY EVACUATION SLIDE MOUNTING HARDWARE CORRODED. MX R & R CORRODED HARDWARE IAW AMM 52-12-40.SDR R61A201307180650Bolt · corrodedDURING HEAVY CHECK, FOUND THE R2 EMERGENCY EVACUATION SLIDE MOUNTING HARDWARE CORRODED. MX R & R CORRODED HARDWARE IAW AMM 52-42-4, PN NAS6604012. ACFT STILL REMAINS FOR COMPLETION OF CHECK.SDR R61A201307180646Bracket · crackedDURING HEAVY CHECK, FOUND LEFT PACK DUCT BRACKET CRACKED FWD OF LT PACK ASSY. MX R & R BRACKET IAW SRM 51-40-02, 51-40-01.SDR R61A201307180645Bracket · crackedDURING HEAVY CHECK, FOUND AVIONICS COOLING HOSE SUPPORT, FWD OF FWD BULKHEAD AT FIRST POSITION RT OF CENTER HOSE CRADLE CRACKED. MX R & R HOSE CRADLE IAW SRM 51-40-01.SDR R61A201307170649Bolt · corrodedWHILE ACFT WAS IN HEAVY CHECK, FOUND L2 PASSENGER DOOR GIRT BAR HARDWARE CORRODED. MX R & R GIRT BAR HARDWARE IAW AMM 52-12-41, PN NAS6604-14. ACFT STILL REMAINS FOR COMPLETION OF CHECK.SDR R61A201307170648Bolt · corrodedWHILE ACFT WAS IN HEAVY CHECK FOUND L1 PASSENGER DOOR GIRT BAR HARDWARE CORRODED. MX R & R GIRT BAR HARDWARE IAW AMM 52-11-41, PN NAS6604-14, BOLT. ACFT REMAINS FOR COMPLETION OF CHECK.SDR R61A201307170647Service Panel · corrodedDURING HEAVY CHECK, FOUND LAVATORY SERVICE DOOR PANEL CORRODED AT HINGE. MX R & R LAVATORY SERVICE DOOR PANEL ASSY IAW AMM 20-10-01. APPLIED TOP COAT AND PLACARD IAW SRM 51-23-05, 51-23-05, 51-23-06 AND AMM 20-10-09, PN 170-86668-403. ACFT REMAINS FOR COMP
Back to N111HQ