N102HQ
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 = 'N102HQ' 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 = 'N102HQ' 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 R61A201609060513Beam · corrodedFORWARD CARGO DOOR CUTOUT HORIZONTAL BEAM HAS CORROSION AS MARKED AT FRAME 27, STR 25R, Z=-1559. R & R FORWARD CARGO AFT FINGER DOUBLER AND APPLIED ALODINE AND TOPCOAT TO THE
SURFACE REF SRM 51-10-03, 51-23-04, 51-40-02, 51-43-02 AND 51-23-06. REFER TO WIP ESDR R61A20160903511Door Sill · corrodedDURING HEAVY CHECK, FOUND CORROSION IN RT OTBD SILL AT FRAME 84. INSTALLED NEW FLOOR SILL AT FRAME 84 RT OTBD. RESTORED ORIGINAL FINISH. REF SRM 51-23-04, 51-23-05, 51-23-06, 51-41-01, 51-41-02, 51-43-04, PO 205134, 214510, 215865, 20864, 210598. AIRCRAFT RSDR R61A201604290288Circuit Breaker · trippedCREW RECEIVED A STEER FAIL MESSAGE. AN EMERGENCY WAS DECLARED AND CREW LANDED WITHOUT INCIDENT. MAINTENANCE RESET THE STEERING SYS AND PLANE TAXIED TO GATE UNDER OWN POWER. MAINTENANCE DISCOVERED AN OPEN BREAKER DC 2 POWER ON THE RICC. MAINTENANCE RESET BRESDR R61A201510280770Windshield · smokeCREW REPORTED AN UNUSUAL ODOR AND SMOKE. CREW PUT ON MASKS, DECLARED AN EMERGENCY, DIVERTED, AND LANDED. MAINTENANCE TROUBLESHOT, R & R RT WINDSHIELD IAW AMM AND OPS CHECKED GOOD. ACFT IS GOOD FOR SERVICE.SDR R61A201412210022Uplock · corrodedDURING HEAVY CHECK, FWD CARGO DOOR UP LOCK ASSY HAS CORROSION. MAINTENANCE R & R FWD CARGO DOOR UPLOCK ASSY IAW AMM 52-31-24, PN 170-84599-407 LATCH ASSY.SDR R61A201412200018Plate · corrodedDURING HEAVY CHECK, LT PLATE AFT OF L1 DOOR BETWEEN FRAMES 20-21 IS CORRODED. MAINTENANCE R & R THE PLATE IAW SRM 51-40-02, 51-23-05.SDR R61A201412200017Plate · corrodedDURING HEAVY CHECK, WAS REPORTED THAT RT PLATE FWD OF R2 DOOR BETWEEN CROSSBEAMS 12 AND 15 IS CORRODED. MX REMOVED AND REPLACED THE RT PLATE IAW SRM 51-40-02, 51-23-05, PN 170-05663-003, SILL PLATE.SDR R61A201412200016Shear Plate · corrodedDURING HEAVY CHECK, LT SHEAR PLATE BETWEEN FRAMES 87-88 BY OTBD DOUBLER IS CORRODED. MX R & R LT SHEAR PLATE BETWEEN 87-88 BY OTBD DOUBLER IAW SRM 51-42-01, 51-43-03.SDR R61A201412200015Splice · corrodedDURING HEAVY CHECK, LT SHEAR PLATE TO SILL ATTACHMENT DOUBLER BETWEEN FRAMES 87-88 HAS COROSION. MAINTENANCE R & R LT FLOOR SPLICE BETWEEN FRAMES 87-88 IAW SRM 51-42-02, PN 170-65644-001, SPLICE.SDR R61A201412190020Rib · crackedDURING HEAVY CHECK , LT HORIZONTAL STAB L/E RIB FOUND CRACKED. REPAIRED IAW ETD 2014-170-107231.SDR R61A201412190019Firewall · crackedDURING HEAVY CHECK, APU FIREWALL HAS TWO CRACKS AT LOWER AND UPPER BENDS. MAINTENANCE REPAIRED THE FIREWALL IAW ETD2014-170-107391. TSDR R61A201412180021Support Bracket · crackedDURING HEAVY CHECK, LT PACK DUCT SUPPORT BRACKET IS CRACKED. R & R THE SUPPORT BRACKET IAW SRM 51-41-01AND AMM 20-10-01SDR R61A201410021087Light · missingCREW REPORTED THAT THE EMERGENCY LIGHT WAS MISSING IN FRONT OF SEAT 1D.SDR R61A201409151062Unknown · unknownCREW REPORTED CAPTAIN`S DV WINDOWN HAD A STRONG WIND NOISE AT 100 KNOTS AND MADE A LOUD BANGING NOISE. CREW DECLARED AN EMERGENCY AND RETURNED TO DEPARTURE WITHOUT INCIDENT. MAINTENANCE INSPECTED EXTERIOR OF ACFT, DV WINDOW, FRAME AND SEAL IAW AMM AN NO DEFECSDR R61A201407250925Glowstrip · looseMAINTENANCE REPORTED THAT THE PHOTO LUMINESCENT STRIP AT ROW 1 SLID OUT OF POSITION. MAINTENANCE REPOSITIONED PHOTO LUMINESCENT STRIP IAW EMB AMM AND OPS CHECKED GOOD.SDR R61A201406190767Light · missingCREW REPORTED THAT SECTION OF EMERGENCY LIGHT NEAR SEAT 2A MISSING.SDR R61A201406150765Light · looseCREW REPORTED THAT THE EMERGENCY LIGHT NEXT TO SEAT 1D WAS LOOSE. MAINTENANCE SECURED EMERGENCY LIGHT STRIP IAW AMM AND OPS CHECKED GOOD.SDR R61A201403240439Seal · splitCREW REPORTED THAT THE L1 DOOR HAD A WHISTLE. AN EMERGENCY WAS NOT DECLARED AND LANDED WITHOUT INCIDENT. MAINTENANCE INSPECTED AND FOUND THE L1 DOOR SEAL SPLIT. R & R THE DOOR SEAL IAW AMM. ACFT OPS CHECKED GOOD AND IS GOOD FOR SERVICE.SDR R61A201401030025Wire Harness · disconnectedCOCKPIT EMERGENCY LIGHT NOT WORKING DURING COCKPIT PREFLIGHT. FOUND HARNESS TO COCKPIT EMERGENCY LIGHT MISSING. FOUND HARNESS AND SECURED IAW AMM 33-50-03. OPS CHECKED GOOD.SDR R61A201308150734Flashlight · unknownCREW REPORTED THAT THE AFT F/A JUMPSEAT FLASHLIGHT WAS INOPERATIVE. MX INSPECTED IAW AMM AND FOUND NO DEFECTS WITH FLASHLIGHT OR CHARGER. OPS CHECKED GOOD.SDR R61A201304140371Glowstrip · looseCREW REPORTED THAT THE PHOTO LUMINESCENT STRIP BY THE FORWARD CLOSET CAME LOOSE. MAINTENANCE RESECURED STRIP PER EMB AMM AND OPS CHECKED GOOD.SDR R61A201303170280Indicator · out of adjustCREW REPORTED THAT THE L1 DOOR LOCK INDICATION WAS NOT WORKING PROPERLY. MAINTENANCE ADJUSTED DOOR LOCK INDICATOR PER EMB AMM 52-11-00. NO DEFECTS NOTED AND OPS CHECKED GOOD.SDR R61A201303070246Glowstrip · looseCREW REPORTED PHOTO LUMINESCENT STRIP IN AISLE AT SEAT 1D IS LOOSE. MAINTENANCE SECURED PHOTO LUMINESCENT STRIP PER EMB AMM 33-50-2 AND OPS CHECKED GOOD.SDR R61A201303060237Glowstrip · looseCREW REPORTED PHOTO LUMINESCENT STRIP AT SEATS 1 D & F IS LOOSE. MAINTENANCE RE-APPLIED PHOTO LUMINESCENT STRIP PER EMB AMM. OPS CHECKED GOOD.SDR R61A201303040215Glowstrip · looseCREW FOUND PHOTO LUMINESCENT STRIP LOOSE AT ROW 1DF. MAINTENANCE RE-SECURED PHOTO LUMINESCENT STRIP PER EMB AMM 33-50-21. OPS CHECKED GOOD.SDR R61A201303020210Slide · unlacedCREW REPORTED L1 DOOR JAMMED AND WILL NOT OPEN. MAINTENANCE INSPECTED AND FOUND THAT L1 DOOR SLIDE LACING CAME LOOSE. MAINTENANCE REMOVED AND REPLACED DOOR SLIDE ASSY PER EMB AMM AND OPS CHECKED GOOD.SDR R61A201303010209Handle · dirtyCREW DISCOVERED THAT L1 DOOR WOULD NOT OPEN UPON ARRIVAL. MAINTENANCE WAS ABLE TO OPEN THE DOOR WITH SOME DIFFICULTY. MAINTENANCE CLEANED AND LUBED DOOR HANDLE AND BELL CRANKS PER EMB AMM AND OPS CHECKED GOOD.SDR R61A20130104037Connector · disconnectedCREW REPORTS COCKPIT EMERGENCY LIGHT INOP. MX FOUND THE CONNECTOR NOT CONNECTED TO THE LIGHT ASSY. RE-SECURED CONNECTOR PER EMB AMM. OPS CHECK GOOD.SDR R61A201212120744Attach Bracket · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND PANEL 419ML ATTACH BRACKET LEFT PYLON OUTBOARD SIDE CRACKED. MAINTENANCE REMOVED AND REPLACED BRACKET IAW EMB 175 SRM 51-40-02, AND 51-42-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201212120721Pin · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE NOSE LANDING GEAR DRAG BRACE MIDDLE PIN (AXLE) INTERNAL THREADS HAVE CORROSION. MAINTENANCE REMOVED AND REPLACED THE NOSE LANDING GEAR DRAG BRACE MIDDLE PIN (AXLE) IAW EMB 175 AMM 32-21-03. THE AIRCRAFTSDR R61A201212100754Support · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RADAR LOWER SUPPORT CRACKED. MAINTENANCE REMOVED AND REPLACED THE RADAR LOWER SUPPORT IAW EMB 170 SRM 51-41-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201212100753Support · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE UPPER RADAR SUPPORT CRACKED. MAINTENANCE REMOVED AND REPLACED THE RADAR UPPER SUPPORT IAW EMB 170 SRM 51-41-01. "MAJOR REPAIR" THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201212100740Attach Angle · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE ATTACH ANGLE FOR RADAR CRACKED. MAINTENANCE REMOVED AND REPLACED ANGLE FOR RADAR ATTACHMENT IAW EMB 175 SRM 51-41-01. THE AIRCRAFT IS OUT OF SERVICE FOR HEAVY CHECK.SDR R61A201212100739Support Bracket · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LOWER RADAR SUPPORT BRACKET CRACKED. MAINTENANCE REMOVED AND REPLACED THE LOWER RADAR SUPPORT BRACKET IAW EMB 175 SRM 51-41-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201212100738Mount Bracket · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE UPPER RADAR MOUNT BRACKET CRACKED. MAINTENANCE REMOVED AND REPLACED THE RADAR UPPER MOUNT BRACKET IAW EMB 175 SRM 51-41-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201212090737Support · gougedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE NOSE LANDING GEAR ACTUATOR SUPPORT GOUGED FORWARD EDGE INBOARD SIDE. MAINTENANCE BLENDED OUT DAMAGE IAW EMB ETD 2012-170-018181 NOSE LANDING GEAR ACTUATOR SUPPORT FORWARD EDGE INBOARD SIDE. "MAJOR REPAISDR R61A201212090707Pin · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE NOSE LANDING GEAR ACTUATOR LOWER ROD END PIN CORRODED. MAINTENANCE REMOVED AND REPLACED NOSE LANDING GEAR LOWER ROD END PIN IAW EMB 175 AMM 32-21-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201212080741Pin · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT MAIN LANDING GEAR SIDESTAY LOWER ATTACHMENT PIN CORRODED. MAINTENANCE REMOVED AND REPLACED THE LEFT MAIN LANDING GEAR LOWER ATTACH PIN IAW EMB 175 AMM 32-11-05. THE AIRCRAFT IS OUT OF SERVICE IN HESDR R61A201212080720Pin · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT MAIN LANDING GEAR SIDESTAY LOWER PIN CORRODED. MAINTENANCE REMOVED AND REPLACED THE RIGHT MAIN LANDING GEAR SIDESTAY LOWER PIN IAW EMB 175 AMM 32-11-05. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHESDR R61A201212080714Pin · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT MAIN GEAR SIDE STAY LOWER ATTACH PIN CORRODED. MAINTENANCE REMOVED AND REPLACED THE LEFT MAIN GEAR SIDE STAY LOWER ATTACH PIN IAW EMB 175 AMM 32-11-05. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECKSDR R61A201212070717Floorbeam · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT FLOORBEAM CORRODED AT FRAMES 86 TO 87. MAINTENANCE REMOVED AND REPLACED THE LEFT FLOORBEAM AT FRAMES 86 TO 87 IAW EMB 175 SRM 41-41-42, 51-41-41, 51-41-01, 51-40-02, 51-42-01, AND 51-43-01. THE AIRSDR R61A201212070718Shear Plate · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT SHEAR PLATE BETWEEN FRAME 87 AND 88 CORRODED. MAINTENANCE REMOVED AND REPLACED THE LEFT SHEAR PLATE BETWEEN FRAME 87 AND 88 IAW EMB 175 SRM 51-42-02, AND 51-43-01. THE AIRCRAFT IS OUT OF SERVICE INSDR R61A201212060748Support · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENACE FOUND THE LEFT RAM AIR VALVE SUPPORT CRACKED. MAINTENANCE REMOVED AND REPLACED THE LEFT RAM AIR VALVE SUPPORT IAW EMB 175 SRM 51-41-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201212060747Profile · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE PROFILE FOR LEFT RAM AIR VALVE CRACKED. MAINTENANCE REMOVED AND REPLACED LEFT RAM AIR PROFILE IAW EMB 175 SRM 51-41-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201212060746Support · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE SUPPORT FOR THE LEFT RAM AIR VALVE CRACKED. MAINTENANCE REMOVED AND REPLACED THE LEFT RAM AIR VALVE SUPPORT IAW EMB 175 SRM 51-41-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201212060723Floorbeam · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT CENTER FLOORBEAM TRACK AT FRAME 18 CORRODED. MAINTENANCE REMOVED AND REPLACED THE LEFT CENTER FLOORBEAM TRACK AT FRAME 18 IAW EMB 175 SRM 51-43-01, 51-41-00, AND 51-43-03. THE AIRCRAFT IS OUT OF SESDR R61A201212060722Beam · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT CENTER FLOOR TRACK BEAM AT FRAME 18 HAS CORROSION. MAINTENANCE REMOVED AND REPLACED THE RIGHT CENTER FLOOR TRACK BEAM IAW EMB 175 SRM 51-40-02, 51-44-01, 51-41-02, AND 51-43-03. THE AIRCRAFT IS OUSDR R61A201212060709Bushing · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT PYLON AFT FAIRING QUICK RELEASE PIN OUTBOARD AFT BUSHING CORRODED. MAINTENANCE REMOVED AND REPLACED BUSHING IAW EMB 175 AMM 20-10-08. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201212060708Bushing · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LEFT ENGINE PYLON FAIRING INBOARD AFT QUICK RELEASE PIN BUSHING CORRODED. MAINTENANCE REMOVED AND REPLACED BUSHING IAW EMB 175 AMM 21-10-08. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201212050713Stop Fitting · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND RUST ON L2 DOOR STOP PADS 3 EACH ON AFT SIDE. MAINTENANCE REMOVED AND REPLACED L2 DOOR STOP PADS 3 EACH ON AFT SIDE IAW EMB 175 AMM 53-23-21. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.
Back to N102HQ