N515DA, cancelled Feb 13, 2003
Service difficulty reports · 81
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 = 'N515DA' AND deregistration_id = 'N515DA-2003-02-13' 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 = 'N515DA' AND deregistration_id = 'N515DA-2003-02-13' 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 DL72S953626Frame · misdrilledWHILE ACCOMPLISHING EO 4-61904-3AD AT HMV IN ATL, 2 OVERSIZED HOLES WERE DISCOVERED IN THE RT OVERWING EXIT FRAME AT STA 784. THE DOUBLER WAS MODIFIED TO REMOVE THE TWO HOLES FROM THE MODIFICATION, IN ACCORDANCE WITH BACO TWX DAL-ATL-95-0883RR DTD 8-31-95.SDR DL72S953885Beam · crackedTHE LOWER TRAILING EDGE BEAM ON THE RT HORIZONTAL STABILIZER WAS FOUND CRACKED APPROXIMATELY 2 INCHES FROM THE OUTBOARD END OF THE BEAM. ACCOMPLISHED REPAIRS PER ERA 302395-14.SDR DL72S953575Blkhd · crackedCRACK INSIDE VERTICAL STABILIZER AT STA 1303 BULKHEAD LOWER RT CORNER, VENTRAL WALL ABOVE S-DUCT HAS CRACK. CRACK WAS FOUND AT HMV, REPAIRED BY INSTALLING DOUBLER PER SRM 53-10-4 FIG 17.SDR DL72S953573Bulkhead · crackedINSIDE VENTRAL STABILIZER AT STA 1303, BULKHEAD LOWER VERTICAL WALL ABOVE S-DUCT HAS CRACK AT LT CORNER. CRACK WAS FOUND AT HMV, REPAIRED PER SRM 53-10-4 FIG 17.SDR DL72S953560Frame · misdrilledDURING HMV IN ATL, SEVERAL HOLES IN THE INBOARD FRAME FLANGE WERE OVERSIZED AT FS 760.95 AND FS 783.95, IN BOTH RT AND LT SIDE WHILE ACCOMPLISHING EO 4-61904-3AD. THE HOLES WERE AUTHORIZED OVERSIZED PER S/B 727-53-0197 REV 2.SDR DL72S953574Angle · corrodedANGLE CORRODED, A/C BAY DOOR ATTACH TEE FROM STA 740 TO 780 CORRODED WHERE HINGES ATTACH FOR PANEL NR 3448. CORROSION WAS FOUND AT HMV, REPAIRED PER M/M 53-30-1 PG 807 AND 808.SDR DL72S953539Angle · corrodedANGLE CORRODED, A/C BAY DOOR ATTACH TEE FROM STA 740 TO 780, CORRODED WHERE HINGES ATTACH FOR PANEL 3348L. FOUND DURING HMV AND REPAIRED PER MM 53-30-1 PG 807 TO 808.SDR DL72S953516Skin · creasedAT HMV, FOUND RT ELEVATOR LOWER SKIN PANEL NR 4 FROM THE I/B END WITH CREASE. REPAIRED PER SRM 55-20-3 FIG 5.SDR DL72S953507S-Duct · crackedFWD EDGE OF UPPER S-DUCT INNER SKIN CRACKED AT APPROX 6 O'CLOCK POSITION. REPAIRED PER SRM 54-10-3 FIG 9.SDR DL72S953484Attach Fitting · corrodedDURING HMV, FOUND NOSE LANDING GEAR LT PIVOT ATTACH POINTS CORRODED ON MATING FLANGES AND INSIDE OF HOLES. REPAIRED PER SRM 53-40-1.SDR DL72S953483Attach Fitting · corrodedDURING HMV, FOUND NOSE LANDING GEAR RT PIVOT ATTACH POINT FITTINGS CORRODED ON MATING FLANGES AND INSIDE OF HOLES. REPAIRED PER SRM 53-40-1.SDR DL72S953482Trunnion · crackedDURING HMV, FOUND I/B TRUNNION MOUNT BRACKET CRACKED ON NR 6 FLAP ACTUATOR. REPAIRED PER M/M 57-20-21.SDR DL72S953481Bracket · crackedDURING HMV, FOUND I/B MOUNT BRACKET CRACKED FOR THE NR 5 L/E FLAP ACTUATOR. REPAIRED PER 57-20-21.SDR DL72S953480Trunnion · corrodedDURING HMV, FOUND RT MLG TRUNNION FITTING CORRODED INSIDE HOLES. REPAIRED PER M/M 57-43-0.SDR DL72S953479Stringer · crackedDURING HMV, FOUND STRINGER CRACKED RT WING STA 686 FWD STRINGER. REPAIRED PER M/M 57-13-0 PG 808.SDR DL72S953476Angle · crackedAT HMV, FOUND ANGLE CRACKED INBD LWR CORNER OF INBD GRND SPOILER MOUNT BOX. REPAIRED PER MM 57-55-0 PG 805.SDR DL72S953886Bulkhead · fastener subWHILE ACCOMPLISHING EO 4-40130-3AD, AFT ENTRY DOORWAY AND BODY STATION 1183 BULKHEAD REINFORCEMENT, SEVERAL FASTENERS CALLED FOR BY THE DRAWING, COULD NOT BE INSTALLED DUE TO FRAME INTERFERENCE. THESE FASTENERS WILL BE SUBSTITUTED TO FACILITATE THE MODIFICATISDR DL72S953475Bushing · misalignedAT HMV, FOUND LT FITTING FOR NR 4 FLAP TRACK MISALIGNED. REPLACED BUSHING PER MM 57-42-0 PG 814.SDR DL72S953512Stringer · crackedLT WING UPPER STR TO RIB WS 686.5 STR NR 10 CRACKED. REPAIRED PER MM 57-13-0 PG 802. FOUND AT HMV.SDR DL72S953511Bracket · crackedNR 2 KRUEGER FLAP ACTUATOR BRACKET CRACKED AT RADIUS. REPAIRED PER 57-20-21 PG 811. FOUND AT HMV.SDR DL72S953510S-Duct · crackedINNER SKIN OF THE FWD SECTION OF S-DUCT IS BENT AND CRACKED AT APPROX 12 O'CLOCK POSITION. REPAIRED PER SRM 54-10-3.SDR DL72S953508Stringer · crackedLT WING UPPER STRINGER TO RIB STA 686.5 STR NR 13 CRACK INDICATION HFEC. REPAIRED PER MM 57-13-0 PG 808. FOUND AT HMV.SDR DL72S953609Frame · crackedDURING HMV, FOUND L2 DR FRAME CRACKED IN LWR RADIUS OF UPPER HINGE CUTOUT. FABRICATED AND INSTALLED REPAIR DOUBLER PER SRM 52-40-2.SDR DL72S953509Angle · crackedI/B LWR CORNER OF I/B GROUND SPOILER MOUNT BOX, ANGLE IS CRACKED. REPAIRED PER MM 57-55-0 PG 805.SDR DL72S953474Trunnion · corrodedAT HMV, LEFT MLG FWD TRUNNION FTG CORRODED IN HOLES. REWORKED PER MM 57-43-0 AND PS 900-4 NR 5.SDR DL72S953540Rib · crackedCRACK INSIDE VERTICAL STABILIZER, RIGHT SIDE 4TH BAY UP, 7TH RIB FROM TOP. CRACK FOUND AT HMV, REPAIRED PER MM 53-30-0 PG 802.SDR DL72S953478Inlet · crackedDURING HMV, FOUND NR 2 INLET DUCT, DOGHOUSE CRACKED AT THE 12 O'CLOCK POSITION. REPAIRED PER SRM 54-10-3 FIG 13.SDR DL72S953795Spar · crackedDURING SHOP VISIT, FOUND THE NR 2 MIDFLAP AFT SPAR RAIL CRACKED 21 INCHES AND 56 INCHES FROM I/B END OF FLAP. REPAIRED PER M/M57-52-0.SDR DL72S953419Frame · corrodedTHE UPPER LEG OF THE C-3 DOOR CUTOUT FORWARD FRAME WAS FOUND CORRODED AT STA 1090, OUTBOARD OF STRINGER 27R. THE DAMAGE WAS REMOVED AND REPAIRED PER B727 SRM 51-40-3, FIGURE 1.SDR DL72S953754Panel · crackedTHE INBOARD AFT PUSHROD CUT-OUT HAS A CRACK AT INBOARD AFT CORNER. REPAIRED PER M/M 57-52-0, PAGE 819. FOR NR 3 MID-FLAP PANEL DURING SHOP INSPECTION.SDR DL72S950066Bulkhead · crackedDURING LETTER CHECK, FOUND A .75 INCH CRACK IN FS 1183 BULKHEAD WEB AT UPPER EDGE OF HORIZONTAL STIFFENER AT WL 168 AT RBL 25. REPAIRED PER SRM 53-10-9 FIG 6.
Back to N515DA, cancelled Feb 13, 2003