N489DA, cancelled Aug 16, 2000
Service difficulty reports · 63
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 = 'N489DA' AND deregistration_id = 'N489DA-2000-08-16' 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 = 'N489DA' AND deregistration_id = 'N489DA-2000-08-16' 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 DL72S953047Skin · damagedAT HMV, FOUND TIME LIMITED REPAIR ON FUSELAGE SKIN AT RT FWD CORNER OF VENTRAL STAIR CUTOUT. INSTALLED NEW REPAIR PER MM 53-30-0 PG 803-804 FIG 802.SDR DL72S953046Skin · gougedSKIN GOUGED FS 682 BETWEEN STR 21R AND 22R. REPAIRED PER SRM 53-30-3 FIG 3A.SDR DL72S952961Skin · crackedSKIN CRACKED, .50 INCH CRACK IN VERT STAB SKIN RT SIDE AT FRONT SPAR AREA BELOW PANEL 9501. REPAIRED PER SRM 55-30-3 FIG 2, AT HMV.SDR DL72S952907Stringer · crackedDURING HMV, FOUND AFT TAB OF VENT BOX STR 11 CRACKED AT WS 519.00. REPAIRED PER M/M 57-13-0.SDR DL72S952869Skin · damagedAT HMV, FOUND TIME LIMITED REPAIR RT SIDE VERTICAL STAB SKIN AT TORQUE BOX AREA. INSTALLED PERMANENT REPAIR PER MM 55-30-0 FIG 801.SDR DL72S952868Skin · damagedREPAIR UNIDENTIFIED RT O/B AILERON UPPER SKIN HAS PREVIOUS TIME LIMITED REPAIR. INSTALLED PERMANENT REPAIR PER SRM 57-50-5 PG 2.SDR DL72S953050Stringer · corrodedCORROSION ON STR 28R STA 495 FWD B/B. REPAIRED PER SRM 53-10-3 PG 3. FOUND AT HMV.SDR DL72S953590Spar Rail · crackedFASTENER ELONGATED ON LOWER SURFACE T/E SEAL RETAINER ATTACH ANGLE, LOWER AFT SPAR ANGLE. REPAIR DOUBLER CRACKED, APPROX 2 INCH CRACK IN AFT SPAR RAIL, 56 INCHES FROM I/B END OF FLAP. ALL THREE AREAS WERE REPAIRED BY REPLACING SPLICING IN NEW SPAR RAIL AS PESDR DL72S953430Spar · crackedTHE NR 2 MIDFLAP AFT LOWER SPAR RAIL CRACKED 56 FROM I/B END OF FLAP. REPAIRED PER M/M 575200 P807, SPLICED IN NEW SECTION OF SPAR RAIL. FOUND AT SHOP VISIT.SDR DL72S950943Spar Stiffener · crackedFOUND DURING F-1 LETTER CHECK, NR 6 SLAT I/B TRACK I/B AND O/B SPAR STIFFENER ANGLES CRACKED 2 INCHES. REPLACED STIFFENERS PER MM 57-20-21 PG 813.SDR DL72S950942Stiffener · crackFOUND DURING F-1 LETTER CHECK, NR 6 L/E SLAT O/B TRACK I/B AND O/B SPAR STIFFENER ANGLES CRACKED. REPLACED STIFFENERS PER MM 57-20-21 PG 813.SDR DL72S950938Web · crackFOUND DURING F-1 LETTER CHECK, .75 INCH CRACK IN LT TORQUE BOX WEB FROM FWD LWR LIGHTENING HOLE STA 1227. REPAIRED PER MM 53-11-0 PG 828.SDR DL72S950931Fairing · crackedFOUND ON F-1 LETTER CHECK, CRACK AT NR 5 SLAT INBD TRACK FAIRING. REPAIRED PER MM 57-40-0 PG 820-821.
Back to N489DA, cancelled Aug 16, 2000