N494DA, cancelled Jun 22, 2000
Service difficulty reports · 88
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 = 'N494DA' AND deregistration_id = 'N494DA-2000-06-22' 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 = 'N494DA' AND deregistration_id = 'N494DA-2000-06-22' 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 DL72S951574Firewall · crackedAT HMV, FOUND NR 2 FIREWALL UPPER LT SECTION CRACKED AT OVERLAP AT INLET DUCT. FABRICATED AND INSTALLED REPAIR PER SRM 54-10-3 PG 2.SDR DL72S951624Frame · crackedDURING INSPECTIONS PER E.O. 4-52217-3AD, THE STA 1090 FRAME (0.080 INCH 7075-T6) WAS FOUND CRACKED ABOVE STR 27R. REPAIR/ MODIFICATION PER E.O. 4-52217-03AD WILL BE INCORPORATED. FOUND AND REPAIRED AT HMV.SDR DL72S952103Spar · crackedNR 2 MID-FLAP DURING HMV SHOP WAS FOUND TO HAVE CRACK IN THE AFT SPAR RAIL AT THREE SPOTS, AT 19, 33, AND 50 FROM I/B END. REPAIRED PER SRM 57-52-0.SDR DL72S952102Fitting · corrosionNR 2 MID-FLAP DURING HMV SHOP INSPECTION WAS FOUND TO HAVE CORROSION IN THE O/B CARRIAGE SUPPORT FITTING, IN THE TOP I/B AND O/B THRUST RETAINER BOLT HOLES. REPAIRED PER SRM 57-50-4.SDR DL72S952101Thrust Bearing · corrosionNR 2 MID-FLAP DURING HMV SHOP INSP WAS FOUND TO HAVE CORROSION IN THE I/B THRUST BEARING TOP I/B AND O/B RETAINER BOLT HOLES. REPAIRED PER SRM 57-50-4.SDR DL72S951553Skin · wornAT HMV, FOUND RT WING O/B AILERON WITH LOOSE FASTENERS ON LOWER SKIN. REPAIRED PER SRM 57-51-00.SDR DL72S951690Spar · crackedAT HMV, FOUND VERTICAL STAB RT FRONT SPAR HAS CRACK STOP DRILLED. MANF, REPAIR DOUBLER, REMOVED DAMAGE, AND INSTALLED PER SRM 55-30-3.SDR DL72S951565Clip · crackedDURING HMV, FOUND SKIN ATTACH CLIP CRACKED AT STA 1070 STR 29R. REPAIRED PER MM 53-11-0 PG 825.SDR DL72S951492Te Skin · crackedDURING SHOP INSPECTION, THE LEFT ELEVATOR WAS FOUND WITH CRACKS IN THE TRAILING EDGE. REPAIRS ACCOMPLISHED PER SRM 55-20-3.SDR DL72S951490Skin · crackedAT HMV, LEFT ELEVATOR WAS FOUND WITH CRACKED SKIN AT THE TRAILING EDGE. REPAIRED PER SRM 55-20-3.SDR DL72S952107Chord · crackedLOWER AFT CHORD IS CRACKED 55 INCHES FROM IB END OF NR 3 MID-FLAP. CHORD WAS REPAIRED PER MM 57-52-0. DAMAGE FOUND AND REPAIRED AT HMV SHOP VISIT.SDR DL72S952105Skin · crackedAT HMV, SHOP INSPECTION, NR 3 MID-FLAP WAS FOUND WITH LOWER AFT SKIN PANEL (COVE SKIN) CRACKED AT CUT-OUT 32 INCHES FROM THE IB END. REPAIR DOUBLER WAS INSTALLED AND REPAIR WAS ACCOMPLISHED PER MM 57520, PAGE 819.SDR DL72S951695Frame · crackedAT HMV, FOUND NR 2 SLAT O/B END 2ND FRAME FROM END CRACKED. REPAIRED PER M/M 57-54-0 FIG 814.SDR DL72S951694Frame · crackedAT HMV, FOUND NR 3 L/E SLAT NR 7 FRAME CRACKED INSIDE L/E. REPAIRED PER M/M 57-54-0 FIG 814.SDR DL72S951692Frame · crackedAT HMV, FOUND NR 3 L/E SLAT OB FRAME CRACKED. REPAIRED PER M/M 57-54-0 FIG 805.SDR DL72S951564Frame · corrodedDURING HMV, FOUND STA 380 FRAME AT R-1 DOOR CORRODED AT Z ANGLE JOINT. REPAIRED PER SRM 53-10-4 FIG 23.SDR DL72S951561Rib · crackedDURING HMV, FOUND NR 1 SLAT I/B END 2ND FRAME CRACKED. REPLACED RIB PER MM 57-54-00.SDR DL72S951826Stringer · crackedDURING HMV, FOUND STR 8L CRACKED 3RD BAY UP FROM ACCESS HOLE INSIDE VERT STAB. REPAIRED PER M/M 55-30-00 PG 803.SDR DL72S951825Web · crackedDURING HMV, FOUND WEB CRACKED STA 1303 LWR RT CORNER INSIDE VERT STAB. REPAIRED PER SRM 53-10-4 FIG 16.SDR DL72S951765Stringer · crackedDURING HMV, FOUND STRINGER CRACKED AT VERT STAB INTERIOR STR 7L, CRACKED LOC 3RD BAY UP FROM ACCESS HOLE. REPAIRED PER M/M 55-30-0 PG 803.SDR DL72S951764Web · crackedDURING HMV, FOUND STA 1303 WEB CRACKED IN LOWER LT CORNER, INSIDE VERT STAB. REPAIRED PER M/M 53-11-0 PG 856.SDR DL72S951760Former · damagedDURING HMV, FOUND FS 560 FORMER UPPER RAIL BENT/DAMAGED ABOVE STR 25L TO STR 24L. REMOVED DAMAGE, REPAIRED PER SRM 53-10-4 PG 107.SDR DL72S951759Skin · gougedDURING HMV, FOUND EXTERIOR SKIN GOUGED AT STR 20R, STA 1343. REMOVED DAMAGE, REPAIRED PER SRM 54-30-3 FIG 7.SDR DL72S951758Support · corrodedDURING HMV, FOUND CENTER FLOOR SUPPORT CORRODED BETWEEN STA 700 TO 720 IN FWD B/B. REMOVED DAMAGE, REPAIRED PER SRM 53-10-5.SDR DL72S951697Hinges · corrodedAT HMV, FOUND HEAVY CORROSION BEHIND HINGES FOR ACCESS DOOR 3348L AC BAY. INSTALLED NEW REPAIR AND SPLICE PER M/M 53-30-1.SDR DL72S951648Floor Beam · corrodedFOUND AT HMV. FLOOR BEAM CORRODED AT STA 360 BETWEEN RBL AND LBL 25 AT FLOOR MOUNT HOLES. REPAIRED PER SRM 53-10-8 FIG 3.SDR DL72S951563Floorbeam · corrodedDURING HMV, FOUND FLOORBEAM CAP CORRODED STA 400 FROM LBL 10 THROUGH RIGHT DOOR OPENING. REPAIRED PER SRM 53-10-8.SDR DL72S951560Seat Track · crackedDURING HMV, FOUND LT O/B SEAT TRACK CRACKED IN VERTICAL SUPPORT WEB CUTOUT 3 INCHES FWD OF STA 760 FLOORBEAM. REPAIRED PER SRM 53-10-8.SDR DL72S951691Skin · damagedAT HMV, FOUND UNIDENTIFIED REPAIR ON TOP SKIN OF RT ELEV BETWEEN NR 5 AND NR 6 HINGE. INSTALLED PERMANENT REPAIR PER SRM 55-20-3 FIG 4.SDR DL72S951573Stringer · crackedAT HMV, FOUND STRINGER CRACKED AT RT LE FLOODLIGHT HOUSING. FABRICATED AND DRILLED REPAIR PER SRM 53-10-3 FIG 1.SDR DL72S951572Stringer · crackedAT HMV, FOUND STRINGER CRACKED AT FWD AND AFT SIDE OF L/E FLOODLIGHT HOUSING. DRILLED AND INSTALLED REPAIR PER SRM 53-10-3 FIG 2.SDR DL72S951645Beam · crackedFOUND AT HMV. UPPER T/E SUPPORT BEAM CRACKED AT NR 8 SPOILER ACTUATOR CUTOUT. REPAIRED BEAM PER MM 57-20-22 FIG 809.SDR DL72S951562Stringer · crackedDURING HMV, FOUND STR 26L CRACKED AT FASTERNER HOLE STA 481. REPAIRED PER SRM 53-10-3 FIG 1.SDR DL72S951647Frame · crackedAT HMV FROM SCHEDULED MTC SHEET. COMPLY WITH PERMANENT REPAIR PER 53-11-0 STA 913 AFT RT WHEEL WELL. REPAIRED PER MM 53-11-0 PG 814.SDR DL72S951646Frame · crackedAT HMV, COMPLIED WITH SCHEDULED PERMANENT REPAIR TO RT MLG UPLOCK ATTACH FRAME AT FS 910. INSTALLED REPAIRS PER MM 53-11-0 PG 814.SDR DL72S950455Stiffener · crackedFOUND ON F1 LETTER CHECK 1. 2 IN CRACK IN WING FWD SPAR VERTICAL STIFFENER AT NR 7 SLAT OUTBD TRACK INBD ANGLE LOWER END 2. 1 .5 INCH CRACK IN WING FWD SPAR VERTICAL STIFFENER AT NR 7 SLAT OUTBD TRACK OUTBD ANGLE LOWER END, REPAIR - 1. REPLACED STIFFENER PER SDR DL72S950454Stiffener · crackedFOUND ON F1 LETTER CHECK, 1. 3 IN CRACK IN WING FWD SPAR VERTICAL STIFFENER AT NBR 7 SLAT INBD TRACK INBD ANGLE LOWER END 2. 3 IN CRACK IN WING FWD SPAR VERTICAL STIFFENER AT NBR7 SLAT INBD TRACK OUTBD ANGLE LOWER END, REPAIRED PER MM 57-20-21 PG 813.SDR DL72S950451Stiffener · crackedFOUND ON F1 LETTER CHECK, 3 IN CRACK IN WING FWD SPAR VERTICAL STIFFENER AT NR 6 SLAT OUTBD TRACK INBD ANGLE LOWER END, REPAIR. INSTALLED NEW ANGLE PER M/M 57-20-21 PG 813.
Back to N494DA, cancelled Jun 22, 2000