N6815, cancelled Jun 21, 2006
Service difficulty reports · 67
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 = 'N6815' AND deregistration_id = 'N6815-2006-06-21' 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 = 'N6815' AND deregistration_id = 'N6815-2006-06-21' 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 EISA97061Angle · crackedWING CENTER SECTION INTERIOR FS 740, ANGLE ON TOP OF VERTICAL BEAM CRACKED IN RADIUS AT LBL 20. FABRICATED AND INSTALLED NEW 'L' ANGLE PER SRM 51-10-1. (M)SDR EISA97060Seat Track · corrodedEXFOLIATED CORROSION ON SEAT TRACK, FS 680 RBL 45.5. REPLACED SEAT TRACK FROM FS 640 TO 680 PER SRM 51-30-02. (M)SDR EISA97059Skin · crackLEFT INBOARD FORE FLAP LOWER SURFACE CRACKED APPROXIMATELY 57 INCHES OUTBOARD OF INBOARD END. REPAIRED FORE FLAP LOWER SURFACE PER 51-00-4 AND 51-40-6. (M)SDR EISA97058Skin · crackedLEFT INBOARD FORE FLAP HAS SURFACE CRACK 46 INCHES OUTBOARD OF INBOARD END. REPAIRED FORE FLAP LOWER SURFACE PER SRM 51-00-4 AND 51-40-6. (M)SDR EISA97057Stringer · crackedFOUND STRINGER 28R CRACKED AT FS 490. REMOVED AND REPLACED STRINGER SECTION FROM FS 480 TO 530 PER SRM 53-10-3. (M)SDR EISA97055Bulkhead Angle · crackedAFT AIRSTAIR AFT BULKHEAD, LEFT LOWER AT STATION 1183, CRACK JUST LEFT OF ENTRY DOOR. FABRICATED AND INSTALLED NEW ANGLE PER SRM 51-10-2. (M)SDR EISA97054Skin · delaminationRIGHT WING INBOARD FLAP, OUTBOARD END HAS CORROSION AND DELAMINATION. INSTALLED FIBER GLASS OVERLAY PER SRM 51-40-6. (M)SDR EISA97053Pin · pittedRIGHT FORWARD BOTTLE BIN PITTED AND SCRATCHED, ON LT WING. REPLACED WITH NEW BOTTLE PIN PER MM 57-41-1. (M)SDR EISA97052Pin · bad platingRIGHT AFT BOTTLE PIN, PLATING MISSING IN SEVERAL PLACES. REPLACED WITH NEW BOTTLE PIN PER MM 57-41-1. (M)SDR EISA97051Pin · corrosionRIGHT AFT BOTTLE PIN OUT OF LIMITS PER MM 57-41-11, ON RIGHT WING. REPLACED RIGHT AFT BOTTLE PIN PER MM 57-41-1. (M)SDR EISA970505Flange · crackedNR 1 KRUEGER FLAP OUTBOARD OF UPPER MIDDLE FLANGE ATTACHMENT CRACKED. STOP DRILLED CRACK. FABRICATED AND INSTALLED REPAIR PER SRM 51-40-2. (M)SDR EISA97049Angle · crackedFS 360 LBL 6 BELOW FLOOR, AFT OF PULLEYS ATTACHMENT ANGLE CRACKED. FABRICATED AND INSTALLED NEW ANGLE PER SRM 51-40-3. (M)SDR EISA97048Fitting · brokenRIGHT WING OUTBOARD END OF OUTBOARD FORE FLAP BROKEN OFF. REMOVED AND REPLACED END FITTING PER SRM 51-10-1. (M)SDR EISA97047Angle · crackedLEFT WING UNDER PANEL 6401, 3RD AFT VERTICAL ANGLE CRACKED AT LOWER FASTENER APPROXIMATELY WS 92.8. FABRICATED AND INSTALLED DOUBLER PER SRM 51-10-2. (M)SDR EISA97045Clip · crackedSTRINGER TIE CLIP AT FS 440 STRINGER 2L CRACKED. REMOVED AND REPLACED TIE CLIP PER SRM 51-10-1. (M)SDR EISA97043Frame · crackBS 940 FRAME HAS 2 INCH CRACK AT STRINGER 14L. FABRICATED AND INSTALLED DOUBLER PER SRM 53-10-04. (M)SDR EISA97042Skin · crackedFORWARD CARGO DOOR AFT LOWER CORNER SKIN CRACKED. STOP DRILLED CRACK. FABRICATED AND INSTALLED DOUBLER PER SRM 52-00-07. (M)
Back to N6815, cancelled Jun 21, 2006