N678CA
Service difficulty reports · 214
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 = 'N678CA' 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 = 'N678CA' 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 ASOA201710063289Angle · corrodedPAX DOOR SILL ANGLE HAS CORROSION AROUND SCREW HOLES. MAINTENANCE REPLACED SILL ANGLE.SDR ASOA201710063291Seat Track · corrodedCABIN SEAT TRACK SEGMENT CORRODED, STRINGER 15R, BS 485 - 571. MAINTENANCE REPLACED THE SEAT TRACK IAW EC/TC 670-53-00-343.SDR ASOA201710063290Seat Track · corrodedCABIN SEAT TRACK SEGMENT, STRINGER 15R, BS 785.15 - 844 FOUND CORRODED. MAINTENANCE REPLACED THE SEAT TRACK SEGMENT IAW EC/TC 670-53-00-343.SDR ASOA201710063288Seat Track · corrodedSEAT TRACK SEGMENT, LBL 9, BS 379 - 485 FOUND CORRODED. MAINTENANCE REPLACED THE SEAT TRACK SEGMENT IAW EC/TC 670-53-00-343.SDR ASOA201710063287Seat Track · corrodedCABIN SEAT TRACK SEGMENT, STRINGER 15L, BS 785.15 - 844 CORRODED. MAINTENANCE REPLACED THE SEAT TRACK IAW EC/TC 670-53-00-343.SDR ASOA201710063286Seat Track · corrodedSEAT TRACK SEGMENT, LBL 9, BS 485 - 581 CORRODED. MAINTENANCE REPLACED THE SEAT TRACK SEGMENT IAW EC/TC 670-53-00-343.SDR ASOA201710063285Stringer Splice · corrodedSTRINGER SPLICE 25R, BS 329 - 327 FOUND CORRODED. MAINTENANCE REPLACED THE STRINGER SPLICE.SDR ASOA201710063284Seat Track · corrodedSEAT TRACK SEGMENT, STRINGER 15R, BS 661+16 - 661.90 CORRODED IN SEVERAL AREAS. MAINTENANCE REPLACED THE SEAT TRACK SEGMENT IAW EC/TC 670-53-00-343.SDR ASOA201710063283Angle · corrodedFLOORBEAM ANGLE AT BS 280 IS CORRODED. MAINTENANCE REPLACED THE FLOORBEAM ANGLE.SDR ASOA201710063282Seat Track · corrodedCABIN SEAT TRACK SEGMENT, LBL 9, BS 661+32 - 693 CORRODED IN SEVERAL AREAS. MAINTENANCE REPLACED THE SEAT TRACK IAW EC/TC670-53-00-343.SDR ASOA201710063281Seat Track · corrodedCABIN SEAT TRACI SEGMENT, STRINGER 15R, BS 744.15 - 761.85 CORRODED IN SEVERAL AREAS. MAINTENANCE REPLACED THE SEAT TRACK SEGMENT IAW EC/TC 670-53-00-343.SDR ASOA201710063280Seat Track · corrodedCABIN SEAT TRACK SEGMENT, STRINGER 15L FROM BS 744.15 - 761.85 CORRODED IN SEVERAL AREAS. MAINTENANCE REPLACED THE SEAT TRACK SEGMENT IAW EC/TC 670-53-00-343.SDR ASOA201710063279Seat Track · corrodedCABIN SEAT TRACK SEGMENT, STRINGER 15L FROM BS 744.15 - 761.85 CORRODED IN SEVERAL AREAS. MAINTENANCE REPLACED THE SEAT TRACK SEGMENT IAW EC/TC 670-53-00-343.SDR ASOA201710063277Seat Track · corrodedCABIN SEAT TRACK SEGMENT, STRINGER 15L, BS 673 - 720.85 CORRODED AT SEVERAL AREAS. MAINTENANCE REPLACED THE SEAT TRACK SEGMENT IAW EC/TC 670-53-00-343.SDR ASOA201710053276Seat Track · corrodedCABIN SEAT TRACK SEGMENT STRINGER 15 FROM BS 673 - 720.85 FOUND CORRODED AT SEVERAL AREAS. MANTENANCE REPLACED THE SEAT TRACK IAW EC/TC 670-53-00-343SDR ASOA201710033275Seat Track · corrodedCABIN SEAT TRACK SEGMENT, LBL 9, BS 581 - 661+32 FOUND CORRODED IN SEVERAL AREAS. MAINTENANCE REPLACED THE SEAT TRACK SEGMENT IAW EC/TC 670-53-00-343.SDR ASOA201710033274Seat Track · corrodedCABIN SEAT TRACK SEGMENT RBL 9, FROM BS 661+32 - 693 CORRODED IN SEVERAL AREAS. MAINTENANCE REPLACED THE SEAT TRACK SEGMENT IAW EC/TC 670-53-00-343.SDR ASOA201710033273Intercostal · corrodedCORRODED INTERCOSTAL AT RBL2 BETWEEN FRAMES 349 & 364. MAINTENANCE REPLACED INTERCOSTAL.SDR ASOA201710033272Intercostal · corrodedCORRODED INTERCOSTAL AT LBL2 BETWEEN FRAMES 349 & 364. MAINTENANCE REPLACED INTERCOSTAL BETWEEN FRAMES 349 AND 364.SDR ASOA201710033271Seat Track · corrodedCABIN SEAT RAIL SEGMENT LBL 27 AND FROM FS 364-485 CORRODED IN SEVERAL AREAS. MAINTENANCE REPLACED SEAT RAIL SEGMENT WITH A NEW FABRICATED ONE IAW EC/TC 670-53-00-343.SDR ASOA201710033270Floor Support · corrodedCORRODED FLOOR SUPPORT LBL 2, BS 394 AND 409. MAINTENANCE REPLACED THE FLOOR SUPPORT.SDR ASOA201704141442Skin · crackedA/C EXTERNAL POWER RECEPTACLE BRACKET ASSY AND SURROUNDING STRUCTURE REQUIRES PERMANENT REPAIR. C/W EC/TC REO 670-53-11-029 01 AND EC/TC REO 670-53-11-844.SDR ASOA2016080115157Megaphone · inoperativeMEGAPHONE INOPERATIVE. R & R MEGAPHONE IAW AMM 25-61-14, REF IPC 25-61-14, FIG 1, ITEM 5.SDR ASOA2015102713978Light · inoperativeDURING CRJ LINE CHECK FOUND LT AFT OVERWING EMERGENCY LIGHT INOPERATIVE. EXTERIOR EMERGENCY LIGHTS, ACFT NOT OPERATED AT NIGHT. LEFT AFT OVERWING EVERGENCY LIGHT OPS CHECKS GOOD IAW MM 33-51-00 PLACARD REMOVED.SDR ASOA2015092413825Battery Pack · inoperativeMEGAPHONE DOES NOT WORK. R & R BATTERY IAW AMM 25-61-05.SDR ASOA2015091013734Door · lack of lubePAX DOOR HARD TO OPERATE. LUBED AND OPS CHECKED PAX DOOR, OK FOR SERVICE, IAW AMM 52-11-00.SDR ASOA2015090613711Lens · crackedSERVICE DOOR EMERENCY EXIT LENS CRACKED. R & R EMERGENCY EXIT LENS ON SERVICE DOOR BY UNSNAPPING OLD LENS AND SNAPPING ON NEW LENS.SDR ASOA2015082413710Skin · corrodedEXTERNAL FUSELAGE SKIN CORRODED AT LOWER TCAS MOUNT AREA. REMOVED CORROSION AT LOWER TCAS ATENNA MOUNT AREA, FS 302 IAW SRM 51-21-06-001-001-A01. BLEND AREA IN A DAMAGE ALLOWED AREA REF SRM 53-21-01-101-002-A02, FIG 53-21-01-991-854. SUBMITTED TO STS ENGINESDR ASOA2015082213709Nut Plate · damagedPANEL 323 AT HAS 2 DAMAGED NUTPLATES, AT THE AIR INLET. R & R 2 EA NUTPLATES AT THE AIR INLET IAW SRM 51-42-06-001-001-AO1 AND SRM 51-42-15-001-001-AO1. THIS REPAIR IS CLASSIFIED AS MAJOR/MINOR REPAIR IAW SOP 5702.SDR ASOA2015082013708Support Angle · corrodedPAX DOOR FWD FRAME, SUPPORT ANGLE, CORRODED AT UPPER & LOWER CAM RECEPTACLES. REMOVED CORROSION FOUND TO BE OUT OF LIMITS IAW SRM 51-21-06-001-001. REMOVED CORRODED FRAME IAW SRM 551-42-06-001-001. LOCATED, DRILLED AND INSTALLED NEW FRAME IAW SRM 51-42-06-00SDR ASOA2015081913707Intercostal · corrodedCORROSION AT NUMEROUS POINTS ON INTERCOSTAL FROM BS 310-349 AND STR 20R. BLENDED CORROSION ON INTERCOSTAL FROM FS 310 TO FS 349 ON STR 20R IN REF TO SRM 51-21-06-001-001-A01. REMOVED INTERCOSTAL AND FWD GUSSET IAW SRM 51-42-06-001-001-A01 AND SRM 51-42-21-00SDR ASOA2015081913706Angle · corrodedCORROSION ON MOUNTING ANGLE FOR PANEL 141ALF AT FS 280. BEYOND ALLOWABLE LIMITS IAW SRM 53-00-00-101-001-A01. REPLACED MOUNT ANGLE.SDR ASOA2015081913705Floorbeam · corrodedCORROSION ON CROSSBEAM AT FS 349 AND RBL9. R & R CORRODED PACKER C, FS349, RBL9 IAW SRM 51-42-06-001-001-A01.SDR ASOA2015081913704Floor Support · corrodedCORROSION ON RT FLOOR SILL BETWEEN FS349-364 AT THE FOLLOWING LOCATIONS: FS349, FS360 AND FS364. BLENDED CORROSION AT FS 349 -FS 360 + FS 364 IAW GREO 670-53-390. BLENDED AREA IS OUT OF ALLOWABLE LIMIT IAW REO 670-53-00-390. COMPLIED WITH EC/TC REO 670-53-0SDR ASOA2015081713703Door · no testRIGHT AFT OVERWING EMERGENCY EXIT FAILED FUNCTIONAL TEST. CLEANED AND LUBED RT AFT OVERWING EMERGENCY EXIT DOOR IAW AMM 12-20-52-640-815 A01. COMPLIED WITH FUNCTIONAL TEST OF THE RT AFT OVERWING EMERGENCY EXIT DOOR IAW AMM 52-21-00-720-803-A01.SDR ASOA2015081713702Door · no testRIGHT FWD OVERWING EMERGENCY EXIT FAILED FUNCTIONAL TEST. CLEANED AND LUBED RT FWD OVERWING EMERGENCY EXIT DOOR IAW AMM 12-20-52-640-815 A01. COMPLIED WITH FUNCTIONAL TEST OF THE RT FWD OVERWING EMERGENCY EXIT DOOR IAW AMM 52-21-00-720-803-A01.SDR ASOA2015081713701Door · no testLEFT AFT OVERWING EMERGENCY EXIT FAILED FUNCTIONAL TEST. CLEANED AND LUBED LT AFT OVERWING EMERGENCY EXIT DOOR IAW AMM 12-20-52-640-815-A01. COMPLIED WITH FUNCTIONAL TEST OF THE LT AFT OVERWING EMERGENCY EXIT DOOR IAW AMM 52-21-00-720-803-A01, FUNCTIONAL TSDR ASOA2015081713700Door · no testLEFT FWD OVERWING EMERGENCY EXIT FAILED FUNCTIONAL TEST. CLEANED AND LUBED LT FWD OVERWING EMERGENCY EXIT DOOR IAW AMM 12-20-52-640-815 A01. COMPLIED WITH FUNCTION TEST OF THE LT FWD OVERWING EMERGENCY EXIT DOOR IAW AMM 52-21-00-720-803-A10. FUNCTIONAL TESTSDR ASOA2015081613699Seat Track · corrodedSEAT TRACK AT LBL9 IS CORRODED IN MULITIPLE AREAS FS 785-15 - 847+16. BLENDED CORROSION IAW SRM 51-21-06-001-001-A01, FOUND TO BE OUT OF LIMITS IAW REO 670-53-00-013. REMOVED SEAT TRACK AT LBL9 FS 693-835 IAW AMM 53-00-49-000-801-A07. INSTALLED NEW SERVICEASDR ASOA2015081613698Seat Track · corrodedRT SIDE SEAT RAIL IS CORRODED IN MULITIPLE AREAS FS 785-15 - 847+16. CORROSION OUT OF LIMITS ON SIDE SEAT RAIL RT BS 785.15-847+16 IAW SUPPLEMENT 53-31-49. REMOVED SIDE SEAT RAIL AT RT FS785.15-FS847+16 IAW AMM 53-00-49-000-801A-07. COMPLETED INSTALLATION OSDR ASOA2015081613697Seat Track · corrodedSEAT TRACK, RBL9 AT FS 693.00-847 IS CORRODED IN MULITIPLE AREAS. BLENDED CORROSION IAW SRM 51-21-06-001-001-A01, FOUND TO BE OUT OF LIMITS IAW REO 670-53-00-013. REMOVED SEAT TRACK RBL 9 FS 593-847 IAW AMM 53-00-49-000-801-A07. INSTALLED NEW SEAT RAIL AT RSDR ASOA2015081613696Seat Track · corrodedRT SEAT TRACK IS CORRODED IN MULITIPLE AREAS FS 661.00+90-720.85. BLENDED CORROSION IAW SRM 51-21-06-001-001-A01. FOUND TO BE OUT OF LIMITS IAW REO 670-53-00-013. R & R SEAT TRACK ON RT SIDE BETWEEN FS 661.00+90 TO 720.85 IN REF TO AMM 53-00-49-000-801-A07 SDR ASOA2015081613695Seat Track · corrodedSEAT TRACK IS CORRODED IN MULITIPLE AREAS RBL9 AT FS 581-661.00+62. BLENDED CORROSION AT RBL 9, BS 581-661.00+62, FOUND TO BE OUT OF LIMITS IAW SRM SUPPLEMENT 53-31-49. REMOVED SEAT TRACK AT RBL9, FS 581-661.00+62, REF: AMM 53-00-49-000-801-A07. COMPLIED WISDR ASOA2015081613694Seat Track · corrodedRT SEAT TRACK RAIL IS CORRODED IN MULITIPLE AREAS FS 581-661.00+16. CORROSION OUT OF LIMITS ON SEAT RAIL SIDE AT BS 581-661.00+16 IAW SRM SUPPLEMENT 53-31-49. REMOVED SIDE SEAT RAIL IAW AMM 53-00-49-000-801, CONFIG A07. COMPLIED WITH EC/TC 670-53-00-343 ANDSDR ASOA2015081613693Seat Track · corrodedSEAT TRACK IS CORRODED IN MULTIPLE AREAS RBL9 AT FS 485-581. BLENDED CORROSION AT RBL9 BS 485-581 FOUND TO BE OUT OF LIMITS IAW SRM SUPPLEMENT 53-31-49. REMOVED SEAT TRACK RBL9 AT FS 485-581 IAW AMM 53-00-49-000-801. FABRICATED SERVICEABLE SEAT RAIL IAW REOSDR ASOA2015081613692Seat Track · corrodedLT SIDE SEAT RAIL AT FS 485-581 IS CORRODED IN MULTIPLE AREAS. BLENDED IAW SRM 51-21-06-001-001-A01. FOUND TO BE OUT OF LIMITS IAW REO 670-53-00-013. REMOVED SIDE SEAT RAIL AT FS485-581 IAW AMM 53-00-49-000-801. REMOVED SIDE SEAT RAIL AT FS485-581 IAW AMM SDR ASOA2015081613691Seat Track · corrodedLT SIDE SEAT TRACK AT FS 597.00-661.00 IS CORRODED IN MULTIPLE AREAS. BLENDED LT SIDE SEAT RAIL AT FS597.00-661, FOUND TO BE OUT OF LIMITS IAW REO 670-53-000-013. REMOVED SEAT RAIL LT FS 597.00-661 IAW AMM 53-00-49-000-801. REMOVED AND INSTALLED NEW SERVICESDR ASOA2015081613690Seat Track · corrodedLT SIDE SEAT RAIL AT FS 661-00-661.00174 IS CORRODED IN MULTIPLE AREAS. BLENDED LT SIDE SEAT RAIL AT FS 661-661.00+74 AREA FOUND TO BE OUT OF LIMITS IAW REO 670-53-00-013. RECEIVED ECTC/REO 670-53-00-343 AND COMPLIED WITH ECTC REO 670-53-00-343 AND GREO 670-SDR ASOA2015081613689Seat Track · corrodedLT SIDE SEAT TRACK AT FS 785.15-820 IS CORRODED IN MULTIPLE AREAS. BLENDED LT SEAT RAIL AT FS 785.15-820, FOUND TO BE OUT OF LIMITS IAW REO 670-53-000-013. DAMAGE IS OUT OF LIMITS OF ECTC REO 670-53-00-013. REMOVED LT SIDE SEAT RAIL AT FS 785.15-820 IAW AMMSDR ASOA2015081613688Seat Track · corrodedLT SIDE SEAT AT FS 744.15-761.85 IS CORRODED IN MULTIPLE AREAS. BLENDED LT SIDE SEAT RAIL FS 744.15-761.85 IAW SRM 51-21-06-001-001-A01 FOUND TO BE OUT OF LIMITS IAW REO 670-53-00-013. REMOVED LT SEAT RAIL AT FS 744-761 IAW AMM 53-0-49-000-801, A07. INSTALLE
Back to N678CA