N137HQ
Service difficulty reports · 91
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 = 'N137HQ' 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 = 'N137HQ' 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 R61A201501150043Skin · gougedDURING HEAVY CHECK, DAMAGE TO CFLLL LT LOWER SKIN REQUIRES COLD WORKING AND BLENDING. MAINTENANCE HAS PERFORMED THE COLD FORMING OF DAMAGED AREAS, PERFORMED HFEC TO ENSURE THERE ARE NO CRACKS, BLENDED OUT GOUGE AND DAMAGE AND THICKNESS REDUCTION HAS BEEN RECSDR R61A201501150041Skin · gougedDURING HEAVY CHECK, DAMAGE TO CFLLL LT LOWER SKIN REQUIRES COLD WORKING AND BLENDING. MAINTENANCE HAS PERFORMED THE COLD FORMING OF DAMAGED AREAS PERFORMED HFEC TO ENSURE THERE ARE NO CRACKS, BLENDED OUT GOUGE AND DAMAGE AND THICKNESS REDUCTION HAS BEEN RECOSDR R61A201412071223Light · unsecureCREW REPORTED THAT THE EMERGENCY LIGHT STRIP NEAR THE AFT GALLEY WAS MISSING. MAINTENANCE SECURED THE LIGHT STRIP IAW AMM AND OPS CHECKED GOOD.SDR R61A201408150996Flashlight · inoperativeCREW REPORTED THAT THE F/O FLASHLIGHT RED CHARGING LIGHT WAS INOPERATIVE. MAINTENANCE R & R F/O FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201407280937Light · missingCREW REPORTED THAT 10 INCHES OF EMERGENCY LIGHT AT ROW 21 LT IS MISSING. REPLACED IAW AMM.SDR R61A201407110871Flashlight · inoperativeCREW REPORTED THAT THE CAPTAIN`S FLASHLIGHT WAS INOPERATIVE.SDR R61A201406110753Fuel Line · corrodedDURING HEAVY CHECK, RT WING FUEL LINE CORRODED. MX R & R RT WING FUEL LINE IAW AMM 20-10-03.SDR R61A201406080764Fitting · damagedDURING HEAVY CHECK, RT UPPER RETRACTION/EXTENSION ACTUATOR FITTING ATTACHED TO RIB 6 FOUND DAMAGED. MX REPAIRED RT MLG FITTING AND SUPPORT FITTING IAW ETD 2014-170-048534 REV D AND ETD 2014-170-046173.SDR R61A201406060752Fuel Line · corrodedDURING HEAVY CHECK, RT WING FUEL LINE AND CLAMPS ARE CORRODED. MX R & R FUEL LINE AND THE CLAMPS, SWAPPED OVER FLOAT ACTUATED DRAIN VALVE IAW AMM 28-12-03. REPLACED ADJOINING TUBE SECTION DUE TO SURFACE DEGRADUATION IAW AMM 20-13-21, 20-10-13, 20-10-03.SDR R61A201406060751Diffuser · corrodedDURING HEAVY CHECK, PANEL DEFUSSER AND CLAMP ARE CORODED. MAINTENANCE R & R PANEL DEFUSSER AND CLAMP IAW AMM 20-10-13.SDR R61A201406060750Line · corrodedDURING HEAVY CHECK, RT WING FUEL LINE FOUND CORRODED. R & R RT WING FUEL LINE IAW AMM 20-10-13.SDR R61A201406060749Fuel Line · corrodedDURING HEAVY CHECK, RT WING FUEL LINE AND CLAMP CORRODED. MX R & R FUEL LINE AND CLAMP IAW AMM 20-10-13.SDR R61A201406060748Fuel Line · corrodedDURING HEAVY CHECK, RT WING FUEL LINE IS CORRODED. MX R & R FUEL LINE IAW AMM 20-10-13.SDR R61A201406060747Fuel Line · corrodedDURING HEAVY CHECK, RT WING FUEL LINE AND CLAMP CORRODED. MX R & R FUEL LINE AND CLAMP IAW AMM 20-10-13.SDR R61A201406060746Fuel Line · corrodedDURING HEAVY CHECK, RT WING FUEL LINE AND CLAMP CORRODED. MX R & R FUEL LINE AND CLAMP IAW AMM 20-10-13.SDR R61A201406060745Clamp · corrodedDURING HEAVY CHECK, RT WING FUEL LINE CLAMP CORRODED. MAINTENANCE R & R CLAMP IAW AMM 20-10-13.SDR R61A201406060744Fuel Line · corrodedDURING HEAVY CHECK, RT WING FUEL LINE AND CLAMPS CORRODED. MX R & R RT WING FUEL LINE AND CLAMPS IAW AMM 20-10-03, 20-10-13.SDR R61A201406060743Fuel Line · corrodedDURING HEAVY CHECK, FUEL LINE AND CLAMP CORRODED. MX R & R FUEL LINE AND CLAMP IAW AMM 20-10-03.SDR R61A201406060738Firewall · crackedWHILE IN HEAVY CHECK, APU RT FIRE WALL PANEL AT TOP AND BOTTOM OF THE ANGLE BEND IS CRACKED. MX REPAIRED CRACKED RT APU FIRWALL PANEL IAW SRM 53-31-21, C1 FOR WORK DETAILS PLACED ON NON MEL DMI 494621/1 FOR EXTERNAL DET INTERVAL OF 10000 F/C TIME COUNTED SINSDR R61A201406060723Seal Rest · corrodedDURING HEAVY CHECK, FWD CARGO DOOR SCUFF PLATE ON FUSELAGE SIDE HAS SCREW HOLES CORRODED. MX R & R LOWER CENTER FWD CARGO DOOR SEAL REST IAW SRM 51-41-01 REF CONTINUATION CARDS C1, C2 FOR WORK DETAILS FCBS 53-21-00-006, PN 170-668804-401 SEAL REST.SDR R61A201406050754Fuel Line · degradedDURING HEAVY CHECK, LT WING FUEL LINE HAS SURFACE DEGRADATION. MX R & R LT WING FUEL LINE IAW AMM 20-10-13.
SDR R61A201406040720Support · crackedDURING HEAVY CHECK, FWD CARGO DOOR SEAL METAL PROFILE HAS SEVERAL DENTS AND LOWER RADIUS IS CRACKED. MX R & R FWD CARGO DOOR SEAL METAL PROFILE WORKED DENTS TO ORIGINAL CONTOUR COMMON TO FWD LOWER RADIUS IAW SRM 52-00-02, 51-40-02,51-41-02 FOR WORK DETAILS SESDR R61A201403310471Light · missingCREW REPORTED PART OF EMERGENCY LIGHT WAS MISSING. MAINTENANCE REPLACED LIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201311191222Flashlight · missingCREW REPORTED THAT THE FORWARD F/A FLASHLIGHT WAS MISSING. INSTALLED A NEW FLASHLIGHT.SDR R61A201307100591Pin · dislodgedCREW REPORTED THAT THE L2 DOOR SLIDE BUSTLE PIN FELL OUT. MX REINSTALLED PIN IAW AMM AND OPS CHECKED GOOD. ACFT IS GOOD FOR SERVICE.SDR R61A201306140539Duct · delaminatedDURING CRUISE, F/A REPORTED A LOUD VIBRATION NOISE BETWEEN ROWS 1 AND 4. NOISE COULD NOT BE HEARD IN COCKPIT. CAPTAIN MADE DECISION TO DIVERT AND DECLARED AN EMERGENCY. LANDED WITHOUT INCIDENT. MX FOUND THE RT AIR DUCT B WAS DELAMINATED AND THE RAM AIR DUCTSDR R61A201303280325Battery · dischargedCREW REPORTED THAT THE FORWARD CABIN EMERGENCY LIGHTS WERE INOPERATIVE. ON CALL MAINTENANCE SWAPPED POWER SUPPLIES WITH NO FIX. AIRCRAFT WAS FLOWN TO PHL ON A MAINTENANCE FERRY PERMIT WHERE MAINTENANCE REPLACED THE LEFT EMERGENCY BATTERIES PER THE EMB AMM ANSDR R61A201303080262Door Seal · dirtyCREW REPORTS THAT THE R1 DOOR IS MAKING A LOUD SQUEAL IN FLIGHT. MAINTENANCE CLEANED, INSPECTED AND PERFORMED A PRESSURE CHECK PER EMB AMM 21-31-0. NO SQUEAL NOTED, OPS CHECKED GOOD.SDR R61A201303050220Door Seal · obstructedFLIGHT ATTENDANT REPORTED THAT THE R1 DOOR WAS MAKING A LOUD NOISE IN FLIGHT AND THAT IT STARTED AND STOPPED GOING THRU ABOUT 10,000 FT. CREW DID NOT DECLARE AN EMERGENCY AND LANDED WITHOUT INCIDENT. UPON LANDING, MAINTENANCE INSPECTED R1 DOOR SEAL AND FOUNDSDR R61A201303030213Door · dirtyR1 DOOR WAS SQUEALING INFLIGHT. MAINTENANCE INSPECTED R1 DOOR, FOUND NO DEFECTS. MAINTENANCE CLEANED & LUBED PER EMB AMM 52-41-2. OPS CHECKED GOOD.SDR R61A201302240183Door Seal · dirtyCREW REPORTED R1 DOOR LEAKING AIR AND SQUEALING LOUDLY DURING FLIGHT. AIRCRAFT HAD TROUBLE MAINTAINING NORMAL PRESSURE. EMERGENCY WAS NOT DECLARED AND AIRCRAFT LANDED WITHOUT INCIDENT. MAINTENANCE INSPECTED R1 DOOR AND FOUND DEBRIS IN SEAL. MAINTENANCE CLESDR R61A201301190067Retainer · gougedWHILE AIRCRAFT WAS IN HEAVY CHECK, MAINTENACE FOUND L1 DOOR AFT SEAL REST GOUGED. MAINTENANCE REMOVED AND REPLACED L1 DOOR AFT SEAL REST IAW SRM 51-40-02, 51-41-01, AND 51-43-01. MAJOR REPAIR.SDR R61A2013011900Seal Seat · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE L1 DOOR AFT SEAL REST GOUGED. MAINTENANCE REMOVED AND REPLACED THE L1 DOOR AFT SEAL REST IAW EMB 175 SRM 51-40-02, 51-41-01, AND 51-43-01. "MAJOR REPAIR" THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201207310397Unknown · malfunctionedCREW REPORTED FWD AISLE EMERGENCY LIGHT INOP. MX REPORTS ITS AN EMERGENCY BATTERY PACK. FOLLOWED FIM, RESET, OPS CHECK GOOD.SDR R61A20110224Switch · malfunctionedCREW REPORTED FWD EMERGENCY LIGHTS WERE INOP. MAINTENANCE CYCLED EMERGENCY LIGHT SWITCH PER EMB AMM, AND OPS CHECK GOOD.SDR R61A20110139Module · failedCREW REPORTED EMERGENCY FUNCTION OF INTERPHONE WAS INOP. MAINTENANCE REMOVED AND REPLACED NIM 1 PER EMB AMM, OPS CHECK GOOD.SDR R61A20100115Battery · dischargedCREW REPORTED 2 EMERGENCY LIGHTS IN THE CABIN WOULDN'T TEST. MAINTENANCE REMOVED AND REPLACED THE NR 2 ELPU PER EMB AMM AND TIGHTENED THE CP FOR THE NR 3 EMERGENCY LIGHT. A/C WAS THEN RETURNED TO SERVICE.SDR R61A20100107Pin · out of positionCREW REPORTED THE PIN TO THE SLIDE OF THE L-1 DOOR IS HANGING OUT. MAINTENANCE RE-STOWED THE PIN PER EMB AMM, OPS CHECK GOOD.SDR R61A20090054Button · inoperativeCREW REPORTED FLIGHT ATTENDANT COCKPIT DOOR CONTROL PANEL EMERGENCY CALL PUSH BUTTON INOP AND WAS PLACED ON MEL. MAINTENANCE PERFORMED OPERATIONAL CHECK OF COCKPIT DOOR CONTROL PANEL, NO FAULTS FOUND PER EMB AMM, WHICH CLEARED THE MEL.SDR R61A20090008Fan Blade · damagedON CLIMBOUT OF CLE CREW RECEIVED A RIGHT ENG VIB EXCEEDANCE OF 4.0. CREW FOLLOWED QRH AND SHUTDOWN ENGINE, DECLARED EMERGENCY INTO CMH. CMH MAINTENANCE FOUND SEVERAL FAN BLADES DAMAGED UPON INITIAL INSPECTION. ENGINE WAS BOROSCOPED, AND SEVERAL BLADE SETS RSDR R61A20090004Connector · burnedCREW REPORTED SMELL OF SMOKE IN CABIN AND COCKPIT. CREW FOLLOWED QRH PROCEDURES, DECLARED EMERGENCY AND LANDED WITHOUT INCIDENT. MAINTENANCE WAS DISPATCHED TO AC AND FOUND CONNECTOR FOR TAT NR 2 BURNT. REPLACED CONNECTOR PER AMM. RETURNED AC BACK TO SERVIC
Back to N137HQ