Boeing DHC-8-102
Service difficulty reports · 9,272
Newest first. General aviation reporting is voluntary.
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 aircraft_model_key = 'DHC8102' 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 aircraft_model_key = 'DHC8102' 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 QXEA9902641Clip · corrodedPDX - CLIP CORROSION BETWEEN RIGHT-HAND STRINGER 32 AND 33 AT FRAME STATION 467. REPAIRED IAW DHC-8 SRM 53-20-21, FIGURE 1.SDR QXEA9902640Seat Track · chafedPDX - RIGHT-HAND INBOARD SEAT TRACK CHAFED AND NICKED AT APPROXIMATELY STATION 456. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902605Seat Track · chafedPDX - RIGHT-HAND INBOARD SEAT TRACK CHAFED IN BOTTOM OF TRACK APPROXIMATELY 10 FROM STATION 436. REPAIRED IAW DHC08 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902604Seat Track · chafedPDX - RIGHT-HAND INBOARD SEAT TRACK CHAFED AND NICKED AT APPROXIMATELY STATION 456. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902603Seat Track · chafedPDX - RIGHT-HAND INBOARD SEAT TRACK CHAFED FROM APPROXIMATELY STATION 500 TO 520. REPAIRED IAW DHC-8 SRM 51-20-36 AND SRM 51-20-16.SDR QXEA9902602Seat Track · chafedPDX - LEFT-HAND INBOARD SEAT TRACK CHAFED AT APPROXIMATELY STATION 500 TO 520 AND 545. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902601Seat Track · chafedPDX - LEFT-HAND INBOARD SEAT TRACK CHAFED AT STATION 488 AND LUG LIP WORN. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9902600Seat Track · chafedPDX - LEFT-HAND INBOARD SEAT TRACK CHAFED AT APPROXIMATELY STATION 445, 456 AND 470. REPAIRED IAW DHC-8 SRM 51-20-16 AND 51-21-36.SDR HNAA9900167Line · leakingAFTER REAR RETRACTION LOUD RUSHING AIR NOISE, BURNING SMELL AND NOTICED SMOKE UNDER RIGHT C/B PNL. FOUND HYD LEAK IN NLG DOWN LINE UNDER COCKPIT FLOOR. INSTALLED SPLICE IN LINE USING QUICK FIT HYD REPAIR KIT LEAK AND OPS CHECK GOOD.SDR HNAA9900166Harness · failedFIRST THREE WHITE FLOOR EMERGENCY LIGHTS INOP. INSPECTED EMERGENCY LIGHT AND FOUND BROKEN WIRE AT LIGHT SOCKET. ALSO, FOUND LOOSE PIN AT 3352 P-1. RE-SECURED PIN, OPS CHECK GOOD.SDR QXEA9902592Light · malfunctionedPDX- COCKPIT EMERGENCY LIGHT ILLUMINATED WHEN EMERGENCY LIGHTS WERE ARMED. REPLACED COCKPIT LIGHT ASSEMBLY, OPERATIONAL CHECKS GOOD.SDR CA991209047Control Head · failed(CAN) DURING PRE-FLIGHT INSPECTION, MAINTENANCE PERSONNEL NOTICED A BURNING SMELL COMING FROM THE RIGHT AUDIO PANEL. INVESTIGATION REVEALED THAT THE LIGHTING CIRCUIT IN THE SUBJECT CONTROL HEAD HAD SHORTED DUE TO WATER CONTAMINATION. THE SUBMITTER DETERMINEDSDR CA991230035Stud · leaking(CAN) AFTER SHUTDOWN, OIL WAS FOUND LEAKING FROM THE NR 2 ENGINE. MAINTENANCE FOUND THE OVERSPEED GOVERNOR LEAKING AT A STRIPPED STUD. THE STUD WAS LOOSE IN THE PUMP BODY.SDR CA991230036Line · leaking(CAN) DURING A PREFLIGHT INSPECTION, HYDRAULIC FLUID WAS NOTICED DRIPPING FROM THE RT ENGINE NACELLE. A PINHOLE WAS FOUND IN THE PRESSURE LINE FOR THE FORWARD GEAR DOOR ACTUATOR.SDR CA991229007Support Bracket · cracked(CAN) THE BRACKET WHICH SUPPORTS THE DUAL SKID CONTROL VALVE, IN THE LEFT ENGINE NACELLEWAS FOUND CRACKED.SDR CA000327006Bracket · cracked(CAN) DURING FLEET CAMPAIGN TO INSPECT ALL ANTI- SKID VALVE MOUNTING BRACKETS, THE LT AND RT BRACKETS WERE FOUND CRACKED.SDR CA000327005Bracket · cracked(CAN) DURING FLEET CAMPAIGN TO INSPECT ALL ANTI-SKID VALVE MOUNTING BRACKETS, THE RT BRACKET WAS FOUND CRACKED.SDR CA000327003Bracket · cracked(CAN) DURING FLEET CAMPAIGN TO INSPECT ALL ANTI-SKID VALVE MOUNTING BRACKETS, THE LT BRACKET WAS FOUND CRACKED.SDR CA991229003Boot · delaminated(CAN) # 1 ENGINE INTAKE DEICE BOOT FOUND DELAMINATING FROM ENGINE INTAKE.SDR HNAA9900162Unknown · odorHEAVY FUEL ODOR IN LAV. INSPECTED AND FOUND UNIDENTIFIED FLUID IN LAV. DRAINED LAV AND PLACED ON MEL 25-7 (INOP AND NO USE).SDR CA991208026Harness · damaged(CAN) DURING SCHEDULED MAINTENANCE, THE NOSE GEAR ALTERNATE INDICATION LIGHT WAS FOUND TO BE INOPERATIVE. THE LIGHT HARNESS HAD BEEN DAMAGED IN THE AREA OF THE NOSE GEAR STRUT. THE HARNESS WAS REPLACED.SDR CA991208017Deice Boot · leaking(CAN) FLIGHT CREW REPORTED THAT THE RIGHT NR 3 LEADING EDGE DEICE BOOT WOULD NOT INFLATE. MAINTENANCE FOUND THE DEICE BOOT TO BE INTERNALLY CONTAMINATED WITH WATER. SUBMITTER SUGGESTED WATER ENTERED THROUGH A NUMBER OF HOLES INCLUDING ONE HOLE WHICH HAD BEENSDR QXEA9902444Switch · failedSEA- EMERGENCY LIGHTS CIRCUIT BREAKER POPS EVEN WITH SWITCH IN OFF POSITION. REMOVED AND REPLACED FLIGHT ATTENDENTS EMERGENCY LIGHTING SWITCH AND EMERGENCY LIGHTING CONTROL BOX, OPERATIONAL CHECKS GOOD.SDR CA991208039Seal · leaking(CAN) DURING CRUISE FLIGHT, THE INFLATABLE DOOR SEAL STARTED TO LEAK. MAINTENANCE REPLACED THE DOORSEAL.SDR CA991229002Blade · cracked(CAN) NICKEL LEADING EDGE SHEATH CRACK PROPAGATED BEYOND ALLOWABLE LIMITS.SDR CA991229001Support Bracket · cracked(CAN) THE BRACKET WHICH SUPPORTS THE DUAL SKID CONTROL VALVE, IN THE LEFT ENGINE NACELLE WAS FOUND CRACKED. THE RIGHT SIDE BRACKET WAS CHECKED AND ALSO FOUND CRACKED.SDR CA991208016Terminal Block · loose(CAN) CREW REPORTED AN INTERMITTENT NR 2 AC GENERATOR FAIL SNAG. WHILE TROUBLESHOOTING, A PIN WAS FOUND TO BE NOT LOCKED IN TERMINAL BLOCK 2422-TB2. THE TERMINAL BLOCK WAS REPLACED.SDR CA991208033Bracket · cracked(CAN) DURING AN INSPECTION REQUIRED BY SB 8-57-7, A CRACK WAS FOUND IN THE RIGHT AILERON TAB ACTUATOR ARM BRACKET. A REPLACEMENT TRIM TAB WAS INSTALLED.SDR CA991208025Power Supply · failed(CAN) DURING SCHEDULED MAINTENANCE, AN EMERGENCY LIGHTING POWER SUPPLY WAS FOUND TO BE UNSERVICEABLE.SDR HNAA9900161Cable · loosePAX DOOR WILL NOT OPEN. FOUND LOWER CABLE OFF PULLEY. REPOSITIONED CABLE ON PULLEY, OPS CHECK GOOD.SDR CA991208015Line · chafed(CAN) HYDRAULIC LINE CHAFED.SDR QXEA9902346Cable · out of positionYYJ- UNABLE TO OPEN MAIN CABIN DOOR. INSPECTED AND FOUND CABLE OFF PULLEY. DISCONNECTED DOOR CABLE. DOOR COUNTER BALANCE INOPERATIVE. FERRIED AIRCRAFT TO PDX. REMOVED AND REPLACED BOTH LEVER CABLES, OPERATION CHECKS GOOD.SDR HNAA9900159unknownAFT INTERIOR EMERGENCY LIGHTS INTERMITTENT. REPLACED EMERGENCY LIGHTS BATTERIES, POSITION 5/6 (PS3 AND PS4). OPS. CHECK GOOD.SDR HNAA9900157Skin · dentedC/W REPAIR TO DENT AND STRUCTURE BELOW F/O WINDSCREEN (DENT ON SKIN TO NOSE BAY STRAP) 6 ABOVE PANEL 212BL. THIS DMT IS CLEARED PER EO8-53-99-394.SDR HNAA9900156Skin · damagedSKIN BURNED AND RIVET BURNED 3 LEFT OF CENTER STA X203. DRILLED OUT AND INSTALLED NEW RIVET. CHECK INSTALLATION OF NEW RIVET FOR ANY PTTING. IF AREA IS PIT FREE, ALODINE, PRIME AND PAINT. C'D/W ABOVE DISPOSITION.SDR HNAA9900155Skin · damagedSKIN BURNED 1 LEFT OF CENTER, 3 FROM EDGEOF SKIN JOINT STA X181.7. BLEND AREA UP TO .006 DEEP. ALODINE, PRIME, AND PAINT. C'D/W ABOVE DISPOSITION.SDR HNAA9900154Skin · damagedSKIN BURNED ON CENTER LINE, STA X165 (BETWEEN RIVETS). BLEND OUT PIT TO MAX .006, ALODINE PRIME AND PAINT. C'D/W ABOVE DISPOSITION.SDR HNAA9900153Skin · damagedSKIN SPLICE ON BELLY HAS BURN MARK AT FRAME NR 2. BLEND BURN AREA LEAVING ED ON RIVETS. ALODINE PRIME, PAINT AND SEAL. C'D/W ABOVE DISPOSITION.SDR HNAA9900152Skin · damagedSKIN BURNED AT STA X615 I/B OF STR 31 NEXT TO RIVET. BLEND OUT BURN AND REPAIR PER ESR8-53-92-025. C'D/W ABOVE DISPOSITION.SDR HNAA9900151Skin · damagedSKIN JOINT BURNED ON EDGE AT STA X531 BETWEEN STR 31P AND 32P. BLEND OUT BURNED AREA MAINTAIN ED ON RIVETS, ALODINE, PRIME, AND PAINT. C'D/W ABOVE DISPOSITION.SDR HNAA9900150Skin · damagedSKIN BURNED AT STA X615 I/B OF STR 31. DAMAGE PARTIALLY BLENDED .008 DEEP, PIT STILL VISABLE. INFO SENT TO ENGINEERING. BLEND OUT BURN AND REPAIR PER ESR8-53-92-025. C'D/W ABOVE DISPOSITION.SDR HNAA9900149Skin · damagedBELLY SKIN SPLICE BURNED AT STA X575. BLENDED OUT BURN MARK. VERIFIED ON RIVETS. VERIFIED STRAP WAS CRACK FREE. PERFORMED EDDY CURRENT INSP, DAMAGED AREA SHOWS INDICATION OF POSSIBLE CRACK OR A DEEP PIT. SEE SEQ 67 (END RESULT WAS ONLY A PIT).SDR HNAA9900148Skin · damagedBELLY SKIN SPLICE BURNED BY LIGHTNING. PIT BLENDED .005 DEEP AND PIT REMAINS. INFO SENT TO ENGINEERING. VERIFIED BETWEEN BLEND AND RIVETS. ALODINE, PRIME AND PAINT AND SEAL. C'D/W ABOVE DISPOSITION.SDR HNAA9900147Skin · damagedSKIN BURNED 6.5 RIGHT OF CENTER, STA X215. REPAIRED IAW EO8-53-99-397.SDR HNAA9900146Skin · damagedSKIN BURNED 4 RIGHT OF CENTER, STA X213.5. REPAIRED IAW EO8-53-99-397.SDR HNAA9900145Skin · damagedSKIN BURNED 3.5 LEFT OF CENTER, STA X220. REPAIRED IAW EO8-53-99-397.SDR HNAA9900144Skin · damagedSKIN BURNED 2 RIGHT OF CENTER, STA X210. REPAIRED IAW EO8-53-99-397.SDR HNAA9900143Skin · damagedSKIN BURNED .5 LEFT OF CENTER, STA X212.5. REPAIRED IAW E08-53-99-397.SDR HNAA9900141Skin · damagedSKIN BURNED.5 LEFT OF CENTER STA X212.7. REPAIRED IAW EO8-53-99-397.SDR HNAA990014Skin · damagedSKIN BURNED 4.75 RIGHT OF CENTER STA X214. REPAIRED IAW EO8-53-99-397.
Back to Boeing DHC-8-102