N505DA, cancelled Mar 21, 2013
Service difficulty reports · 66
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 = 'N505DA' AND deregistration_id = 'N505DA-2013-03-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 = 'N505DA' AND deregistration_id = 'N505DA-2013-03-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 DL72L954059Pump · leakingTHE B-SYS HYDRAULIC IND SHOWED ZERO IN FLT, SYS-A SHOWS 2.1 GAL AND IS STEADY. LOSS OF INDICATION IN B-SYS WENT FROM FULL TO ZERO IN ABOUT 1 HOUR. FOUND NR 2 B-PUMP LEAKING, REPLACED AND LEAK CHECK OK. REPLACED BOTH B-SYS CASE DRAIN AND PRESS FILTER, RAN ALSDR DL72L953596Window · brokenPREFLIGHT CHECK, FOUND LEFT FORWARD OVERWING EMERGENCY EXIT HATCH WINDOW OUTER PANE BROKEN. REPLACED WITH SERVICEABLE DOOR FOR RETURN TO SERVICE. SDR UNDER INVESTIGATION.SDR DL72L953492Eel Battery Pack · dischargedDURING LAYOVER C-2, CARGO EMERGENCY LIGHT INOP. REPLACED BATTERY PACK, OPERATION NORMAL.SDR DL72L953443Eel Assy · inopOVERHEAD EMERGENCY LIGHT IN FWD CABIN INOP. REPLACED LIGHT ASSEMBLY, OPERATION NORMAL.SDR DL72L953354Skin · corrodedDURING CV-2 INSPECTION, TWO CUTOUTS WERE MADE IN THE BELLY SKIN AFT OG THE SKIN SPLICE AT STA 1010. THE RT CUTOUT IS O/B OF STR 28R AND MEASURES 3.5 BY 4.5. THE LT CUTOUT EXTENDS FROM STR 30 TO SEVERAL INCHES O/B OF STR 29L AND MEASURES 4.75 BY 8 AND WILL RESDR DL72L953361Skin · crackedFOUND ON CV2 CHECK, .5 CRACK AT NR 3 SLAT INNER SKIN BELOW THERMAL ANTI-ICE TUBE. REPAIRED PER M/M 57-54-0 PG 807A.SDR DL72L953304Floorbeam · corrodedFOUND ON CV2 CORROSION AT FLOORBEAM STA 344 BL 0 THROUGH LBL 60. REPAIRED PER SRM 53-10-8 FIG 10, ID AS PERMANENT REPAIR PER PS 902-5-1 NR 4.SDR DL72L953312Balance Board · damagedFOUND ON CV2 CHECK, LT ELEVATOR OUTBOARD MOST BALANCE BOARD BAY UPPER BONDED RIB HAS HOLE IN DOUBLER AT O/B END. REPAIRED PER SRM 55-20-3 FIG 3.SDR DL72L953311Rib · crackedFOUND ON CV2 CHECK, CRACK FOUND INSIDE VERTICAL STABILIZER, 2 BULKHEADS UP FROM ACCESS HOLE AT LT SIDE 2ND RIB UP. CRACKED AT BOLT ATTACHED TO BULKHEAD. REPAIRED PER M/M 55-30-0 PG 803.SDR DL72L953310Rib · crackedFOUND ON CV2 CHECK, CRACK FOUND INSIDE VERTICAL STABILIZER, 2 BULKHEADS UP FROM ACCESS HOLE AT LT SIDE 3RD RIB UP. CRACKED AT RIB TO BULKHEAD ATTACH POINT. REPAIRED PER M/M 55-30-0 FIG 803.SDR DL72L953309Rib · crackedFOUND ON CV2 CHECK, CRACK FOUND INSIDE VERTICAL STABILIZER, 2 BULKHEADS UP FROM ACCESS HOLE ON RT SIDE 2ND RIB UP. CRACKED AT RIB TO BULKHEAD ATTACH POINT. REPAIRED PER M/M 55-30-0 FIG 803.SDR DL72L953308Rib · crackedFOUND ON CV2 CHECK, CRACK FOUND INSIDE VERTICAL STABILIZER, 4 BULKHEADS UP FROM ACCESS HOLE ON LT SIDE 5TH RIB UP. CRACKED AT RIB TO BULKHEAD ATTACH POINT. REPAIRED PER M/M 55-30-0 FIG 803.SDR DL72L953307Rib · crackedFOUND ON CV2 CRACK, FOUND INSIDE VERTICAL STABILIZER, 5 BULKHEADS UP FROM ACCESS HOLE 4TH RIB UP. CRACKED AT RIB TO BULKHEAD ATTACH POINT RT SIDE. REPAIRED PER M/M 55-30-O.SDR DL72L953306Rib · crackedFOUND ON CV2 CHECK, CRACK FOUND INSIDE VERTICAL STABILIZER, 5 BULKHEADS UP FROM ACCESS HOLE 4TH RIB UP. CRACKED AT RIB BULKHEAD ATTACH POINT LT SIDE. REPAIRED PER M/M 55-30-0 FIG 803.SDR DL72L953305Tq Box · crackedFOUND ON CV2 CHECK, LIGHTENING HOLE CRACKED AT 48 SEC, TORQUE BOX STA 1235 LT SIDE. REPAIRED PER M/M 53-11-0 NR 16 PG 828.SDR DL72L953176Window · missingMOMENTARY SHUDDER AT FL 350 IN CRZ. SUSPECT NR 1 ENG COMPRESSOR STALL. CHECKED INLET AND EXHAUST. BORESCOPED NR 1 ENG PER MM. RAN ALL 3 ENGS PER PFHB, OPERATION NORMAL. POST-INSPECTION FOUND THE LEFT SIDE OVERWING AFT EMERGENCY EXIT DOOR WITH THE OUTER PAN
Back to N505DA, cancelled Mar 21, 2013