N391CA
Service difficulty reports · 270
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 = 'N391CA' 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 = 'N391CA' 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 ASOA2013091909040Seat Track · corrodedSEAT TRACK CORRODED MULTIPLE SPOTS, BS 677-830.4 RBL 9. FABRICATED NEW SEAT TRACK IAW REO 670-53-00-343 REV D. REMOVED CORRODED SEAT TRACK IAW AMM 53-00-49-000-801 (CONFIG A03). INSTALLED NEW FABRICATED SEAT TRACK IAW AMM 53-00-49-400-801.SDR ASOA2013091909039Web · corrodedRT WEB AT FS 280 AND RBL 9 CORRODED. REPLACED WEB IAW SRM 51-1200-001-001: 51-21-02-001-001.SDR ASOA2013091909038Floorbeam · crackedRT FS 280 FLOORBEAM CRACKED AND CORRODED. REMOVED FLOORBEAM IAW SRMS 51-42-06-001-001-A01, 51-42-10-001-001-A01, AND 51-42-21-001-001-A01. LOCATED & DRILLED REPLACEMENT FLOORBEAM IAW SRM 51-42-06-001-001-A01 & 51-42-21-001-001-A01. INSTALLED NEW SERVICEABLESDR ASOA2013091909037Web · corrodedLT WEB AT FS 280 AND LBL 9.0 IS CORRODED. REMOVED DAMAGED WEB IAW DWG 670-53-11-594. FABRICATED A REPLACEMENT WEB IAW DWG 670-53-11-594. INSTALLED WEB IAW DWG 670-53-11-594.SDR ASOA2013091909036Floorbeam · corrodedFS 280 FLOORBEAM CORRODED. REMOVED FLOORBEAM IAW SRM 51-42-21-001-001-A01. LOCATED & DRILLED REPLACEMENT FLOORBEAM IAW SRM 51-42-06-001-001-A01 & 51-42-21-001-001-A01.SDR ASOA2013091909035Floor Support · corrodedFLOOR PANEL 221ALF AFT FLOOR SUPPORT ANGLE WHICH ATTACHES TO FS280, FRAME IS CORRODED. LOCATED AND DRILLED THE AFT SUPPORT ANGLE IAW SRM 51-40-11-001-001-A01. THIS REPAIR IS CLASSIFIED AS A MAJOR REPAIR IAW ASA SOP 5702.SDR ASOA2013091909034Sill · corrodedAFT CARGO DOOR SILL CORRODED. REPAIRED IAW OF REO 670-53-61-913.SDR ASOA2013091909033Floor Support · corrodedLEFT FLOOR SUPPORT CORRODED BETWEEN FS 985 AND 1000. REMOVED CORROSION IAW SRM 53-61-58-101-001-A01. REPAIRED IAW REO 670-53-61-990. MAJOR REPAIR.SDR ASOA2013091909032Floor Support · corrodedRT FLOOR SUPPORT CORRODED BETWEEN BS 1051.3 AND 1070.7. REMOVED CORROSION & FOUND OUT OF LIMITS IAW SRM 53-61-43-201-001. REPAIRED IAW REO 670-53-61-993.SDR ASOA2013091709025Floor Support · corrodedRT FLOOR SUPPORT CORRODED BETWEEN FS 1051.3 - 1031. REPAIRED IAW SRM 53-61-43-201-001 AND REO 670-53-61-989. MAJOR REPAIR.SDR ASOA2013091709024Floor Support · corrodedRT FLOOR SUPPORT CORRODED BETWEEN FS 1000 AND 1015. REPAIRED IAW REO 670-53-61-993 IAW NDTM PT.1, 51-20-006. MAJOR REPAIR.SDR ASOA2013082908931Floor Support · corrodedRT FLOOR SUPPORT CORRODED BETWEEN FS 1015 AND 1031. REPAIRED IAW REO 670-53-61-993, REPAIR CLASSIFIED AS MAJOR.SDR ASOA2013082808920Seat Track · corrodedSEAT TRACK CORRODED MULTIPLE SPOTS FS 485-581 AND RBL 9. REPLACED SEAT TRACK IAW AMM 53-00-49-000-801 A03 AND AMM 53-00-49-400-801-A03.SDR ASOA2013082808919Seat Track · corrodedSEAT TRACK CORRODED MULTIPLE SPOTS FS 485-581 AND LBL 9. REPLACED SEAT TRACK IAW AMM 53-00-49-000-801-A03 AND AMM 53-00-49-400-801-A03.SDR ASOA2013082808918Seat Track · corrodedSIDEWALL SEAT TRACK CORRODED MULTIPLE SPOTS AT FS 708-761.85 AND S15L. REMOVED SEAT TRACK IAW AMM 53-00-49-000-801. INSTALLED SERVICABLE SEAT TRACK IAW AMM 53-00-49-400-801-A03.SDR ASOA2013082808917Seat Track · corrodedSIDEWALL SEAT RAIL CORRODED MULTIPLE SPOTS AT FS 708-761.85 AND S15L. REMOVED AND INSTALLED SERVICABLE SIDEWALL SEAT TRACK IAW AMM 53-00-49-000-801-A03 AND 53-00-47-400-801-A03.SDR ASOA2013082808916Seat Track · corrodedSIDEWALL SEAT TRACK CORRODED MULTIPLE SPOTS AT FS 863-976 AND S15L. REMOVED SEAT TRACK IAW AMM 53-00-49-000-801. INSTALLED NEW SEAT TRACK IAW AMM 53-00-49-400-801.SDR ASOA2013082808915Seat Track · corrodedSEAT TRACK CORRODED MULTIPLE SPOTS FS 379-485 AND LBL 9. REMOVED SEAT TRACK IAW AMM 53-00-49-000-801-A03. INSTALLED SERVICEABLE SEAT TRACK IAW AMM 53-00-49-400-801.SDR ASOA2013082808914Seat Track · corrodedSIDE WALL, SEAT RAIL, CORRODED MULTIPLE SPOTS AT FS 785.15-863 AND S15R. CORRODED BEYOND LIMITS IAW SRM 53-41-49-101-001-A01. REMOVED SEAT TRACK IAW AMM 53-00-49-000-801. INSTALLED SEAT TRACK IAW AMM 53-00-49-400-801.SDR ASOA2013082208892Seat Track · corrodedSIDE SEAT TRACK CORRODED MULTIPLE SPOTS AT FS 581 -677. R & R PASSENGERS SEAT TRACK IAW AMM 53-00-49-000-801 AND 53-00-49-400-801.SDR ASOA2013091909031Skin · chafedSKIN BS 977.00 UNDER PANEL 195DL HAVE CHAFED, STRINGER 27. REPAIRED IAW REO 670-53-61-994 AND REO 670-53-00-290, REV C.SDR ASOA2013091709023Sill · corrodedGALLEY SERVICE DOOR SILL IS CORRODED. REMOVED LOWER SILL STRIKER FROM SERVICE DOOR IAW SRM TASK 51-42-06-001-001-A01. REMOVED SERVICE DOOR PROTECTOR PLATE FOR ACCESS TO REMOVE LOWER SEAL STRIKER IAW AMM TASK 53-21-23-000-801. INSTALLED SERVICE DOOR PROTECTOSDR ASOA2013091709022Mount · corrodedBELLY FAIRING PANEL 193AB HAS CORROSION DAMAGE ALONG THE FWD MOUNTING FLANGE. R & R LT AND RT FWD FLANGES ON PANEL 193AB IAW SRM 51-42-13-001-001-A01.SDR ASOA2013091709021Channel · crackedC-CHANNEL LOCATED UNDER PANEL 195DL IS CRACKED. REMOVED CHANNEL IAW SRM 51-42-06-001-001-A01. INSTALLED NEW CHANNEL IAW SRM 51-42-13-001-001-A01.SDR ASOA2013082908930Structure · crackedFORWARD EQUIPMENT COMPARTMENT, RT SIDE AFT CORNER, CRACKED, GOING UNDER ADG HYD PUMP. REPAIRED IAW AMM 24-23-19-000-801 AND REO 670-53-11-509.SDR ASOA2013050603476Lens · loosePLASTIC EXIT LENS COVER ON BULKHEAD IN FRONT OF SEAT 1A WILL NOT STAY SECURED. LENS IS CRACKED IN SEVERAL PLACES. RESECURED PLASTIC EXIT COVER IAW AMM 33-51-05. NO FURTHER ISSUES AT THIS TIME.SDR COMA2012062970024Reservoir · failedON APPROACH INTO BOS HYDRAULIC SYSTEM NR 3 QTY 10 PERCENT AND BOTH 3A AND 3B PUMPS INOP. EMERGENCY DECLARED, A/C LANDED SAFELY AT BOS. REMOVED AND REPLACED NR 3 HYDRAULIC RESERVOIR. OPS CHECK GOOD.SDR COMA2011061770036Angle · corrodedSERVICE DOOR SILL ANGLE CORRODED. REMOVED CORRODED SILL ANGLE AND INSTALLED REPLACEMENT ANGLE PER SRM 51-42-06.SDR COMA2011061670035Sill · corrodedFLOOR SILL FWD OF SERVICE DOOR HAS CORROSION. REPAIRED FLOOR SILL P/N SH670-32172 FWD OF SERVICE DOOR BY CUTTING AWAY DAMAGE AND INSTALLING DOUBLER IAW REO 670-53-21-713.SDR COMA2011061570033Angle · corrodedPAX DOOR THRESHOLD "L" ANGLE UNDER CAP ANGLE IS CORRODED. REMOVED AND REPLACED "L" ANGLE P/N SH670-31875-7 UNDER CAP ANGLE AT PAX DOOR THRESHOLD AREA IAW SRM 51-42-06 AND 51-42-21.SDR COMA2011061470032Fitting · corrodedPAX DOOR FWD HANDRAIL CUP FITTING IS CORRODED. INSTALLED SERVICABLE FWD CUP FITTING IAW CRJ-SRM 51-42-20.SDR COMA2011061470031Angle · corrodedPAX DOOR SILL ANGLE HAS CORROSION. INSTALLED SERVICEABLE PAX DOOR SILL ANGLE IAW CRJ-SRM 51-42-06.SDR COMA2011061470030Crossbeam · corrodedLEFT CROSSBEAM AT FS 280 CORRODED. REMOVED AND REPLACED CROSSBEAM IAW CRJ REO 670-53-11-265 AND REO 670-53-11-047.SDR COMA2011061470029Crossbeam · corrodedRIGHT CROSSBEAM AT FS 280 CORRODED. REMOVED AND REPLACED CROSSBEAM IAW CRJ REO 670-53-11-265 AND REO 670-53-11-047.SDR COMA2011061370028Seat Track · corrodedFWD MOST SEAT TRACK JUST TO THE RIGHT OF THE AISLE IS CORRODED. REPLACED SEAT TRACK IAW CRJ AMM 53-00-49.SDR COMA2010060270009Control Unit · malfunctionedON DESCENT INTO DCA RECEIVED O/B SPOILERONS AND O/B SPOILERS CAUTION MSG'S. EMERGENCY DECLARED, A/C DIVERTED TO IAD AND LANDED SAFELY. PERFORMED RESET OF SSCU'S AND SELF TEST. MSG'S CLEARED, NO FURTHER DEFECTS NOTED.SDR COMA2010060270008Control Unit · malfunctionedON DESCENT INTO DHN RECEIVED I/B SPOILERS AND I/B SPOILERONS CAUTION MSG. EMERGENCY DECLARED, A/C LANDED SAFELY. PERFORMED RESET OF SSCU'S, MSG CLEARED. NO FURTHER DEFECTS NOTED.SDR COMA2009052870019Crossbeam · crackedFS 280 CRACKED AT RBL 9.00 FLOOR SUPPORT CROSSBEAM. REPAIRED CRACK AT FS 280 RBL 9.00 FLOOR SUPPORT CROSSBEAM IAW REO 670-53-11-045.SDR COMA2009052870018Crossbeam · crackedFS 280 CRACKED AT LBL 9.00 FLOOR SUPPORT CROSSBEAM. REPAIRED CRACK AT FS 280 LBL 9.00 FLOOR SUPPORT CROSSBEAM IAW REO 670-53-11-045.SDR COMA2009031750097Transducer · failedRECEIVED ANTI SKID CAUTION MSG ON TAKEOFF FROM PHL, AND REMAINED ON THROUGHOUT FLT. EMERGENCY DECLARED, A/C LANDED SAFELY IN CVG. REMOVED AND REPLACED LEFT I/B WHEEL SPEED TRANSDUCER.SDR COMA2009021970015Windshield · crackedEN ROUTE FROM CVG TO EWR LEFT WINDSHIELD CRACKED. EMERGENCY DECLARED, A/C LANDED SAFELY IN EWR. REMOVED AND REPLACED LEFT WINDSHIELD.SDR COMA0870013Element · faultyFLIGHT 5100 - EN ROUTE PIT-CVG RECEIVED AN ANTI-ICE DUCT WARNING MESSAGE, CREW DECLARED EMERGENCY AND FLIGHT LANDED WITHOUT INCIDENT. REPLACED THE LEFT WING INBOARD LEADING EDGE WING SENSING ELEMENT.SDR COMA0870012Element · faultyFLIGHT 5100 - EN ROUTE PIT-CVG RECEIVED AN ANTI-ICE DUCT WARNING MESSAGE, CREW DECLARED EMERGENCY AND FLIGHT LANDED WITHOUT INCIDENT. REPLACED THE LEFT WING CENTER LEADING EDGE WING SENSING ELEMENT.SDR COMA0770078A/C Pack · malfunctionedFLIGHT 5420 - DURING TAXI OUT IN DFW PASSENGERS WERE EVACUATED DUE TO SMOKE IN CABIN ROWS 8.9 AND 10. FOUND RIGHT PACK TO BE THE CAUSE OF THE SMOKE. DEFERRED TIGHT PACK PER MEL 21-51-04-2.SDR COMA0770068Skin · damagedWORKING RIVETS AND DAMAGED TOP WING SKIN O/B OF LEFT MULTI-FUNCTION SPOILERS. REPAIRED DAMAGED AREA IAW REO 670-51-73-002 AND EA 70-5557-01885.SDR COMA0770067Floor Support · corrodedPAX DOOR SURROUND MID CAP FLOOR EXTRUSION CORRODED. REPLACED FLOOR SUPPORT MID CAP EXTRUSION IAW SRM 51-21-33.SDR COMA0770066Structure · dentedRIGHT I/B FLAP HAS A 1 INCH DENT. REPAIRED FLAP IAW SRM 57-52-01.SDR COMA0770065Bulkhead · corrodedFS 280 BULKHEAD AND CROSSBEAM CORRODED. BLENDED OUT CORROSION IAW SRM 53-21-43, 51-21-11, 51-25-06, 51-42-13 AND 53-11-10.SDR COMA0770064Skin Panel · gougedFUSELAGE SKIN GOUGED BELOW SERVICE DOOR. REPAIRED DAMAGED AREA IAW REO 670-53-21-312.SDR COMA0770063Mount · corrodedAFT INBOARD MOUNT FOR GALLEY NR 1 IS CORRODED. REPLACED MOUNT IAW SRM 51-42-21.
Back to N391CA