N538CA
Service difficulty reports · 219
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 = 'N538CA' AND registry_match = 'registration' 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 = 'N538CA' AND registry_match = 'registration' 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 ASOA2014011709776Skin · chafedFS 913 - 927 ROW OF SIX CHAFED RIVETS AT STRINGER 27. REPAIRED DAMAGE IAW REO 670-53-00-290. REPAIR CLASSIFIED AS MAJOR.SDR ASOA2014011709775Floor Support · crackedAFT CHANNEL OF FLOOR PANEL 195DL IS CRACKED AT AFT SECTION. R & R CHANNEL IAW SRM 51-42-13-001-001-A01 AND DWG PL CC690-39302.SDR ASOA2014011709774Stringer · corrodedCORROSION FOUND ALONG STRINGER 26L BETWEEN BS 364 & 349. REPAIRED IAW SRM 51-42-06-001-001-A01 AND SRM 51-42-03-001-001-A01. REPAIR CLASSIFIED AS MAJOR.SDR ASOA2014011709773Intercostal · corrodedCORROSION FOUND ALONG INTERCOSTAL BETWEEN STRINGERS 26 & 27L, AND ALONG BS 349. R & R INTERCOSTAL IAW SRM 53-21-23-101-003, SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01 AND DWG SH670-32050.SDR ASOA2014012309795Handle · out of adjustDURING FUNCTIONAL TEST OF THE PAX DOOR INNER HANDLE, HANDLE FAILED FOLLOW UP PULL TEST, 16 MAX. ACTUAL 25 LBS. CLEANED, LUBED AND ADJUSTED INNER HANDLE DETEAT AT 12 LBF IAW AMM 52-11-02-400-801. COMPLIED WITH FUNCTIONAL TEST OF PAX DOOR IAW AMM 52-11-00-720-SDR ASOA2014020709920Skin · dentedSMALL DENT ON INBD UNDER-SIDE OF LT INBD FLAP NEAR T/E. CUT OUT DAMAGED SKIN AND FABRICATED DOUBLER AND FILLER IAW SRM 57-52-01-201-001. COMPLIED WITH SRM 57-52-01-201-001-A1. MAJOR REPAIR.SDR ASOA2013120609593Light · inoperativeEMERGENCY LIGHTS WILL NOT TURN ON FOR FIRST FLT TEST. TESTED LIGHTS IAW AMM 33-51-00 OK FOR SERVICE.SDR ASOA2013121909661Warning Message · false activationWING OVERHEAT WARNING MESSAGE IN FLIGHT, COMPLIES WITH QRH, MESSAGE EXTINGUISHED FOR A FEW MINUTES AND THEN CAME BACK. ACFT RETURNED TO DEPARTURE. EMERGENCY DECLARED. COMPLIED WITH FIM 30-12-00 AND AMM 30-12-00, OPS CHECKED GOOD, NO DEFECTS NOTED.SDR ASOA2013111909417Light · deterioratedAFT EMERGENCY LIGHT AT ROW 12AB DEGRADED AND WORN. R & R LIGHT IAW AMM 33-51-01.SDR ASOA2013111809413Floor Panel · deterioratedFLOOR PANEL SPONGY AFT OF CENTER CONSOLE IN FLIGHT COMPARTMENT. REPAIRED IAW GREO 670-53-00-365, REV A. MAJOR REPAIR IAW GMM5-3.SDR COMA2012051590009Detector · failedON DESCENT INTO BOS RECEIVED FLAPS FAILED CAUTION MSG, FAILED AT 6 DEG. QRH FOLLOWED. EMERGENCY DECLARED, A/C LANDED SAFELY IN BOS. REMOVED AND REPLACED RIGHT FLAP I/B SKEW DETECTOR. OPS CHECK GOOD.SDR COMA2011121990041Pressure Switch · intermittentON CLIMBOUT FROM JFK UPON GEAR RETRACTION, RECEIVED NOSE GEAR DISAGREE THAT DID NOT REMAIN. EMERGENCY DECLARED, A/C LANDED SAFELY IN CVG. FOUND LEFT MLG PRESSURE SWITCH TO BE AT FAULT. REMOVED AND REPLACED LEFT PRESSURE SWITCH. OPS CHECK GOOD.SDR COMA2011121290040Sill · corrodedRT FLOOR SILL BETWEEN FS 280 AND FS 319.7 UPPER SURFACE CORRODED. REMOVED AND REPLACED SILL SECTION FROM FS 280- FS 319 IAW SRM 51-42-06, 51-42-13 AND 51-42-21.SDR COMA2011121290039Crossbeam · corrodedFS 280 CROSS BEAM CORRODED ALONG TOP SURFACE OF UPPER ANGLE. REMOVED AND REPLACED FS 280 FLOORBEAM IAW TASK CARD REO-B-53R0005.SDR COMA2011092390028Proximity Sensor · out of adjustON CLIMBOUT FROM CVG TO LGA RECEIVED MLG FAULT STATUS MSG, GEAR DISAGREE. GEAR CYCLED DOWN NORMAL. EMERGENCY DECLARED, A/C RETURNED TO CVG LANDED SAFELY. INSPECTED A/C, FOUND PROX SENSORS PX 03 AND PX11 (NLG W OFF W SENSORS) TO BE OUT OF ADJUSTMENT. ADJUSTSDR COMA2010081790010Blanket · out of positionEN ROUTE FROM DTW TO MCI RECEIVED LEFT BLEED DUCT WARNING MSG, FOLLOWED BY LOSE OF PRESSURIZATION. EMERGENCY DECLARED, A/C DIVERTED TO ORD LANDED SAFELY. INSPECTED A/C FOUND LEFT BLEED SOV BLANKET TOUCHING LOOP MT137. REPOSITIONED BLANKET, OPS CHECK GOOD.SDR COMA2009090890015Unknown · smokeAFT LAV SMOKE WARNING MSG CAME ON AFTER T/O FROM CVG WITH SMOKE IN CABIN AND COCKPIT. EMERGENCY DECLARED, A/C RETURNED TO CVG LANDED SAFELY. RAN A/C ENGINES ISOLATED PACKS, OPENED ALL CABIN GASPERS SMELL DISSIPATED TO CLEAN AIR AND NO DEFECTS NOTED. SUSPECTSDR COMA2009072290012Riser · crackedPAX DOOR FWD STEP RISER CRACKED UNDER RAIL SUPPORT FITTING. REPAIRED IAW BOMBARDIER REO 670-52-11-104.SDR COMA2009022590005Window · crackedEN ROUTE FROM IAH TO JFK - F/O'S SIDE WINDOW SHATTERED (MULTIPLE CRACKS) WHILE LEVEL AT 35,000 FT. EMERGENCY DECLARED, A/C DIVERTED TO CVG LANDED SAFELY. REPLACED F/O'S SIDE WINDOW.
Back to N538CA