N371CA
Service difficulty reports · 205
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 = 'N371CA' 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 = 'N371CA' 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 ASOA201706261710Fairing · crackedLT ENGINE UPPER AFT HINGE LINE FAIRING HAS A CRACK IN THE MOST AFT SCREW HOLE. COMPLIED WITH EC/TC REO 670-78-33-998 AND REO 670-78-33-998 REV A, DATED 08/04/2015 AS WRITTEN.SDR ASOA201706251706Skin · gougedFUSELAGE AFT LOWER SKIN GOUGED AT FS 977.00 STR 27. COMPLIED WITH EC/TC REO 670-53-00-290-01 REV C AND REO 670-53-00-290 REV D DATED 9/10/2015 AND COMPLIED WITH MODSUM IS670538200021 MODIFICATION OF AFT FAIRING PANEL "C"CHANNEL.SDR ASOA201706211702Seat Track · corrodedSEAT FLOOR TRACK AT FS976-1004 RBL9 IS CORRODED. REMOVED AND REPLACED SEAT FLOOR TRACK AT FS976-1004 RBL9 WITH NEW SERVICEABLE SEAT FLOOR TRACK.SDR ASOA201706191721Intercostal · corrodedSERVICE DOOR INTERCOSTAL AT STRINGER 20R, RBL 42 HAS CORROSION. REMOVED AND REPLACED THE INTERCOSTAL.SDR ASOA201706191704Fitting · corrodedASD AFT HAND RAIL CUP HAS CORROSION. REMOVED AND REPLACED ASD AFT HAND RAIL CUP.SDR ASOA201706181701Seat Track · corrodedSEAT FLOOR TRACK AT FS987-1004 LBL9 IS CORRODED. REMOVED AND REPLACED CORRODED FLOOR SEAT TRACK AT FS987 - 1004, LBL9 IAW AMM
53-00-49-000-802-A02 & 53-00-49-400-802-A02. ALL DEFECTS CORRECTED.SDR ASOA201706171700Seat Track · corrodedLT SIDE RAIL SEAT TRACK SEGMENT FROM FS 675 TO 712 HAS CORROSION AT FS 708. REMOVED SEAT TRACK, FABBED NEW TRACK AND INSTALLED PER AMM 53-00-49-000/400-801-803 AND ECTC REO 670-53-00-343.SDR ASOA201706171699Seat Track · corrodedLT SIDE RAIL SEAT TRACK SEGMENT FROM FS 570 TO 675 HAS CORROSION AT FS 581 AND FS 613. REMOVED SEAT TRACK, FABBED NEW TRACK AND INSTALLED PER AMM 53-00-49-000/400-801-803 AND ECTC REO 670-53-00-343.SDR ASOA201706171688Seat Track · corrodedRT SIDE SEAT RAIL SEAT TRACK SEGMENT FROM FS 570 TO 675 HAS CORROSION AT FS 613. REMOVED AND REPLACED LT SEAT TRACK IAW AMM 53-00-49-000-801 A03 & AMM 53-00-49-400-801 A03. COMPLIED WITH EC/TC REO 670-53-00-343 & GENERIC REO670-53-00-343 REV M AS WRITTEN: FABRSDR ASOA201706171687Seat Track · corrodedRT SIDE SEAT RAIL SEAT TRACK SEGMENT FROM FS 570 TO 675 HAS CORROSION AT FS 613. REMOVED AND REPLACED LT SEAT TRACK IAW AMM 53-00-49-000-801 A03 & AMM 53-00-49-400-801 A03. COMPLIED WITH EC/TC REO 670-53-00-343 & GENERIC REO670-53-00-343 REV M AS WRITTEN: FABRSDR ASOA201706171686Seat Track · corrodedLT FLOOR SEAT TRACK CORRODED AT FS 677-830. REMOVED AND REPLACED LT SEAT TRACK IAW AMM 53-00-49-000-801 A03 & AMM 53-00-49-400-801 A03. COMPLIED WITH EC/TC REO 670-53-00-343 & GENERIC REO670-53-00-343 REV M AS WRITTEN: FABRICATED NEW SEAT TRACK FROM EXTRUSION SDR ASOA201706171685Seat Track · corrodedLT FLOOR SEAT TRACK CORRODED AT FS 581-677. REMOVED AND REPLACED LT SEAT TRACK IAW AMM 53-00-49-000-801 A03 & AMM 53-00-49-400-801 A03. COMPLIED WITH EC/TC REO 670-53-00-343 & GENERIC REO670-53-00-343 REV M AS WRITTEN: FABRICATED NEW SEAT TRACK FROM EXTRUSION SDR ASOA201706171684Seat Track · corrodedLT FLOOR SEAT TRACK CORRODED AT FS 501-581. REMOVED AND REPLACED LT SEAT TRACK IAW AMM 53-00-49-000-801 A03 & AMM 53-00-49-400-801 A03. COMPLIED WITH EC/TC REO 670-53-00-343 & GENERIC REO670-53-00-343 REV M AS WRITTEN: FABRICATED NEW SEAT TRACK FROM EXTRUSION SDR ASOA201706141727Intercostal · corrodedBS 349 - 364 INTERCOSTAL AT STRINGER 26R HAS CORROSION. REMOVED AND REPLACED THE INTERCOSTAL IAW SRM 51-42-06-001-001-A01, 51-40-11-001-001-A01, 51-42-21-001-001-A01 AND DRAWING SH670-32077.SDR ASOA201706131705Retainer · corrodedAVIONICS BAY DOOR FWD PRESSURE SEAL RETAINER CORRODED.
REMOVED AND REPLACED AVIONICS BAY DOOR FWD PRESSURE SEAL RETAINER.SDR ASOA201706131703Skin · corrodedAVIONICS BAY DOOR SURROUND INTERNAL SKIN LANDING IS CORRODED. COMPLIED WITH EC/TC REO 670-53-21-242 AND REO 670-53-21-242 REV C DATED 7-24-2015.SDR ASOA201702225013Bulb · blownDURING MX INSPECTION THE RIGHT SIDE EXTERIOR EMERGENCY LIGHT WAS INOPERATIVE. MX REMOVED AND REPLACED THE BULB WITH OPS CHECKED GOOD. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA2016081415244Battery Pack · inoperativeFA MEGAPHONE INOPERATIVE. REMOVED AND REPLACED THE BATTERIES. OPS CHECK GOOD.SDR ASOA2016061714940Light · inoperativeROW 18 OVERHEAD EMERGENCY LIGHT INOPERATIVE. RE-INSTALLED ROW 18 OVERHEAD EMERGENCY LIGHT BULB IAW AMM 33-51-09. OPS CHECK GOOD.SDR ASOA2015121114216Bracket · crackedFOUND BRACKET WITH STRESS CRACKD BETWEEN BS 349 TO 364 AT LBL 27. REMOVED BRACKET, PN SH670-33339-1 IAW SRM REF 51-42-006-001-001-A01. INSTALLED NEW BRACKET IAW SRM REF 51-42-006-001-001-A01 & 51-40-11-001-001-A01. FABRICATED NEW BRACKET IAW DWG SH670-33339SDR ASOA2015091513832Seat Track · corrodedLEFT SIDE SEAT RAIL SEGMENT BS 785-860 HAS CORROSION IN SEVERAL AREAS. CORRODED BEYOND LIMITS IAW SRM 53-41-49-101-001-A01. R & R THE SEAT TRACK IAW AMM 53-00-49-000-801-A03 & AMM 53-00-49-400-801-A03.SDR ASOA2015091513831Seat Track · corrodedRIGHT SIDE SEAT TRACK SEGMENT HAS COROSION BETWEEN BS 785 AND 797. FOUND CORRODED BEYOND LIMITS IAW SRM 53-41-49-101-001-A01. R & R THE SEAT TRACK IAW AMM 53-00-49-000-801, A03 & AMM 53-00-49-400-801, A03.SDR ASOA2015091513797Seat Track · corrodedLT SIDE SEAT RAIL SEGMENT FORM FS 672-722 HAS CORROSION AT FS 708. FABRICATED SERVICEABLE SEAT RAIL REF REO 670-53-00-343 AND DWG NR SH670-36255 AND SRM 51-40-11-001-001-A01. REMOVED DAMAGED SEAT RAIL LT SIDE FROM FS 675-FS 713 REF AMM 53-00-49-000-801-A03. SDR ASOA2015091513796Seat Track · corrodedLH SIDE SEAT RAIL SEGMENT FROM FS 715-761 HAS CORROSION IN SEVERAL AREAS. FABRICATED AND INSTALLED NEW SEAT RAIL REF COMPLIED WITH EC/TC REO 670-53-00-343 AND GREO 670-53-00-343, REV L AS WRITTEN AMM 53-00-49-400-801-A03. FOUND SEAT RAIL FROM FS 715-761, TO SDR ASOA2015091513795Seat Track · corrodedRT SIDE SEAT RAIL SEGMENT FROM FS 477-573 HAS CORROSION AT FS 521. REMOVED RT SEAT RAIL FROM FS 485.00-FS 581 REF AMM 53-00-49-000-801 A03. INSTALLED NEW SERVICEABLE SEAT RAIL IAW AMM 53-00-49-400-801(A03) AND COMPLIED WITH EC/TC REO 670-53-00-343 AND GREO 6SDR ASOA2015091513794Seat Track · corrodedRT SIDE SEAT RAIL SEGMENT FROM FS 672-722 HAS CORROSION AT FS 708. FABRICATED SERVICEABLE SEAT RAIL REF REO 670-53-00-343 AND DWG SH670-36255 AND SRM 51-40-11-001-001-A01. REMOVED DAMAGED SEAT RAIL RT SIDE FROM FS 675-FS 713. INSTALLED SERVICEABLE SEAT RAIL SDR ASOA2015091513793Seat Track · corrodedRT SIDE SEAT RAIL SEGMENT FROM FS 715-761 HAS CORROSION AT FS 736. FABRICATED AND INSTALLED NEW SEAT RAIL REF COMPLIED WITH EC/TC REO 670-53-00-343 & GREO 670-53-00-343, REV L AS WRITTEN AMM 53-00-49-400-801-A03. FOUND SEAT RAIL FROM FS 715-761 RT TO BE OUT SDR ASOA2015091413830Door Sill · corrodedPAX DOOR SILL, FWD CLOSING FITTING CORRODED. R & R UNSERVICEABLE PAX DOOR CLOSING FITTING WITH NEW SERVICEABLE CLOSING FITTING IAW SRM 51-42-06-001-001 A01.SDR ASOA2015091413792Seat Track · corrodedSIDE SEAT RAIL BETWEEN BS 485 - 573, STR 15L HAS CORROSION AT 7 AREAS. COMPLIED WITH SRM SUPPLEMENT 53-31-49 & EC/TC REO 670-53-000-013 AND GREO 671-53-00-013, REV J.SDR ASOA2015091413790Seat Track · corrodedSIDE SEAT RAIL BETWEEN FS 379.00 TO FS 485.00, STGR 15L HAS CORROSION IN 2 PLACES. AREAS ARE MARKED. COMPLIED WITH SRM SUPPLEMENT + JET 53-31-49 + EC/TC REO 670-53-00-013 AND GREO 370-53-00-013, REV 5.SDR ASOA2015091413789Floor Support · corrodedPAX DOOR SILL, LOWER FLOOR SUPPORT, L-ANGLE, CORRODED. EVALUATED CORROSION ON PAX DOOR SILL LOWER SUPPORT ANGLE AND FOUND TO BE OUT OF LIMITS IAW SRM 51-21-23-001-001 A01. REMOVED LOWER KICKPLATE ANGLE FROM PAX DOOR IAW SRM 51-42-06-001-001-A01 & FWD & AFT HSDR ASOA2015091313829Bracket · corrodedSERVICE DOOR LOWER BRACKET AFT & FWD ARE CORRODED. BLENDED CORROSION ON WEB FLOOR PROTECTORS IAW SRM 51-21-06-001-001-A01, FOUND TO BE OUT OF LIMITS IAW SRM 53-21-23-101-002-A01, 100 PERCENT MATERIAL LOSS. REMOVED 4 EA WEB FLOOR PROTECTORS AND 4 EA L-ANGLES SDR ASOA2015091313788Seat Track · corrodedSEAT TRACK AT LBL 9 AND AT FS 613 IS CORRODED. SEAT RAIL AT LBL9, AT FS 565-661+8.40 IS CORRODED BEYOND LIMITS IAW REO 670-53-00-013. R & R SEAT RAIL AT LBL9, FS 565-661+8.40 IAW AMM 53-00-49-000-801-A03 & AMM 53-00-49-400-801-A03.SDR ASOA2015091313787Seat Track · corrodedSEAT TRACK AT RBL 9 AND AT FS 613 IS CORRODED. SEAT RAIL AT RBL9, RS565-FS661-+8.40 IS CORRODED BEYOND LIMITS IAW REO 670-53-00-013. REMOVED & INSTALLED SERVICABLE SEAT RAIL AT RBL9 AT FS 613 IAW AMM 53-00-49-000-801-A03 & 53-00-49-400-801 A03 IPC REF 53-00-SDR ASOA2015091313786Seat Track · corrodedSEAT RAIL AT RBI 9 AND BEWTEEN FS 349 AND FS 364 IS CORRODED. SEAT RAIL CORRODED AT FS 349-FS 485, RBL 9 BEYOND LIMITS IAW REO 670-53-00-013. REMOVED SEAT RAIL IAW AMM 53-00-49-000-801-A03. INSTALLED NEW SEAT RAIL AT FS 349-FS 485, RBL9 IAW AMM 53-00-49-400SDR ASOA2015091313785Angle · corrodedSERVICE DOOR MID CAP ANGLE FS 319-349 CORRODED IN MULTIPLE AREAS. BLENDED CORROSION ON LWR SILL ANGLE IAW SRM 51-21-06-001-001-A01. FOUND TO BE OUT OF LIMITS IAW SRM 53-21-23-101-002-A01, 100 PERCENT MATERIAL LOSS. R & R SERVICE DOOR CAP ANGLE IN REF SRM 51SDR ASOA2015091313784Floor Support · corrodedRT FLOOR SILL FS 280-319.70 IS CORRODED IN MULTIPLE AREAS. BLENDED CORROSION ON FLOOR SILL RT FROM FS 280-319.70 IAW SRM 51-21-06-001-001-A01 100 PERCENT MATERIAL LOSS. R & R FLOOR SILL AT RT SIDE BETWEEN FS 280-319 AS NEEDED REF: SRM 51-42-06-001-001-A01 ANSDR ASOA2015091213854Floorbeam · corrodedTHE FLOORBEAM IN THE AVIONICS BAY BS 280 IS CORRODED. R & R IAW SRM 51-42-06-001-001-A01 & SRM 51-42-21-001-001-A01.SDR ASOA2015091213783Door · lack of lubeGALLEY SERVICE DOOR FAILED FUNCTIONAL CHECK AT 40LBF TO DISENGAGE DETENT ROLLER AND 63LBF TO COMPLETE UNLATCH CYCLE. CLEANED AND GREASED GALLEY SERVICE DOOR IAW AMM 12-20-52-640-801-A01. PERFORMED FUNCTIONAL TEST IAW AMM 52-41-00-720-802-A01. DOOR FOUND TO SDR ASOA2015091013834Frame · damagedAFT CARGO DOOR, AFT RAIL IS DAMAGED. SUBMITTED TO ENGINEERING FOR PERMANENT DISPOSITION. RECEIVED AND COMPLIED WITH EA 32-2015-366. COMPLIED WITH EC/TC EA 32-2015-366.SDR ASOA2015091013782Door Sill · corrodedSERVICE DOOR SILL PLATE CORRODED. REPLACED SERVICE DOOR SILL PLATE. TRANSFERRED ALL EXISTING FASTENER LOCATIONS TO SERVICEABLE SILL PLATE, PN SH670-31407-3 AND INSTALLED 7 EA DOMENUTS IAW SRM 51-40-11-001-001-A01 AND 51-45-00-001-001-A01.SDR ASOA2015090813867Link · deterioratedLT AND RT REAR SPAR LINK TILTED/CONTRACTING CONDITION IAW EC/TC REO 670-53-41-177, ITEM 5. COMPLIED WITH ECTC REO 670-53-41-17701 PERMANENT DISPOSITION. LT AND RT REAR SPAR LINKS R & R IAW SB670BA-57-016. REFERENCE ECTC REO 670-53-41-177-01 FOR PERMANMENT DSDR ASOA2015080813458Bulb · burned out12 CD LOWER SIDEWALL EXIT SIGN HAVE 2 LIGHT BULBS BURNED. REMOVED BURNED OUT BULBS AT 12CD LOWER EXIT SIGN AND REPLACED WITH NEW IAW AMM 33-51-11. OPS CHECK GOOD.SDR ASOA2015051212795Bulb · burned out12 CD LOWER EXIT SIGN, HAD ONE LIGHT BULB BURNED OUT. R & R THE BULB IAW AMM 33-51-05.SDR ASOA2015010712017Floor Support · crackedLEFT COCKPIT FLOOR SUPPORT CRACKED. R & R LT COCKPIT FLOOR SUPPORT IAW SRM 51-42-06-001-001-A01 & DWG CC670-33199.SDR ASOA2015010712016Floorbeam · corrodedFLOORBEAM HAS CORROSION AT FS 280.00 AT RBL 45. REMOVED CORROSION IAW SRM 51-21-06-001-001-A01. COMPLIED WITH EC/TC REO 670-53-00-390.SDR ASOA2015010712015Stringer · crackedCRACKED STRINGER ON LT 280 BULKHEAD SUPPORT. REMOVED STRINGER IAW SRM 51-42-06-001-001-A01. INSTALLED NEW STRINGER IAW SRM 51-42-06-001-001-A01, DM 84398 12/27/14 & DWG CC670-34117.SDR ASOA2015010712014Stringer · crackedCRACKED STRINGER ON RT BS 280 BULKHEAD SUPPORT. REMOVED STRINGER IAW SRM 51-42-06-001-001-A01. INSTALLED NEW STRINGER IAW SRM 51-42-06-001-001-A01 & DWG CC670-34117.SDR ASOA2015010712013Bulkhead Web · corrodedRT SIDE BULKHEAD WEB AT BS 280 CORRODED. COMPLIED WITH EC/TC REO 670-53-11-594 AND GREO 670-53-11-594 REV.SDR ASOA2015010712012Bulkhead Web · corrodedLT SIDE BULKHEAD WEB AT BS 280 CORRODED. COMPLIED WITH EC/TC REO 670-53-11-594 01 AND GREO 670-53-11-594, REV.
Back to N371CA