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 ASOA2015081613687Seat Track · corrodedLT SIDE SEAT RAIL AT FS 785.15-847.00 & 48 IS CORRODED IN MULTIPLE AREAS. BLENDED LT SIDE SEAT RAIL FS 785.15-847+48 IAW SRM 51-21-06-001-001-A01. FOUND TO BE OUT OF LIMITS IAW REO 670-53-00-013. REMOVED SEAT RAIL FROM LT SIDE RAIL AT FS 847.16-897 IAW AMM SDR ASOA2015081613686Seat Track · corrodedLT SIDE SEAT RAIL AT FS 847 & 897 IS CORRODED IN MULTIPLE AREAS. BLENDED LT SIDE SEAT RAIL FS 847.0016-897 IAW SRM 51-21-06-001-001-A01. FOUND TO BE IN LIMITS IAW REO 670-53-00-013. AFTER FURTHER EVALATUION FOUND SEAT RAIL TO BE OUT OF LIMITS AT FS847.16-897SDR ASOA2015081613685Seat Track · corrodedLT SIDE SEAT TRACK IS CORRODED IN MULTIPLE AREAS FS 897-1000. BEGAN TO BLEND CORROSION IAW SRM 51-21-06-001-001-A01. FOUND TO BE OUT OF LIMITS IAW REO 670-53-00-013. RECEIVED ECTC REO 670-53-00-343 COMPLIED WITH ECTC REO 670-53-00-343 AND GREO 670-53-00-343SDR ASOA2015081613684Seat Track · corrodedSEAT TRACK, LBL 9 AT FS 847-1000 IS CORRODED IN MULTIPLE AREAS. BLENDED SEAT TRACK LBL9 FS 847.100 IAW SRM 51-21-06-001-001-A01. FOUND TO BE IN LIMITS IAW REO 670-53-00-013. UPON FURTHER EVALATUION FOUND SEAT TRACK AT LBL9, FS 847-1000 TO BE CORRODED OUT OFSDR ASOA2015081613683Seat Track · corrodedSEAT TRACK, RBL 9 AT FS 847-1000 IS CORRODED IN MULIPLE AREAS. EVALUATED SEAT RAIL AT RBL 9, FS 847-FS 1000 & FOUND TO BE OUT OF LIMITS IAW REO 670-53-00-013. REMOVED SEAT TRACK AT RBL9, FS 847-1000 IAW AMM 53-00-49-000-801, A07. COMPLIED WITH EC/TC REO 670SDR ASOA2015081613682Seat Track · corrodedRT SIDE SEAT TRACK IS CORRODED IN MULTIPLE AREAS FS 485-581. EVALUATED SEAT RAIL AT RBL 9 BETWEEN FS 830.40 & 881 & FOUND TO BE OUT OF LIMITS IAW REO 670-53-00-013. REMOVED SEAT RAIL AT RBL9, FS 830.40-FS 881 IAW AMM 53-00-49-000-001-A07. REMOVED SEATRAIL ASDR ASOA2015081613681Seat Track · corrodedRT SIDE SEAT TRACK IS CORRODED IN MULTIPLE AREAS FS 865-977. NO ALLOWABLE LIMITS ON RT SIDE SEAT RAIL FS 865-977 IAW REO 670-53-00-013 & SRM SUPPLEMENT 53-51-49. REMOVED RT SIDE SEAT RAIL FS 865 977 IAW AMM 53-00-49-000-801-A07. COMPLIED WITH ECTC/REO 670-5SDR ASOA2015081613680Seat Track · corrodedRT SIDE SEAT TRACK IS CORRODED IN MULTIPLE AREAS FS 847 - 865. RT SIDE SEAT RAIL AT FS 847.00+16-865, FOUND TO BE OUT OF LIMITS IAW REO 670-53-00-013 & SRM SUPPLEMENT 53-51-49. REMOVED RT SEAT RAIL AT FS 847+16-864 IAW AMM 53-00-49-000-801-A07. COMPLIED WITSDR ASOA2015081613679Seat Track · corrodedSEAT TRACK RBL9 AT FS 349-485 IS CORRODED IN SEVERAL AREAS. REMOVED CORROSION ON SEAT TRACK RBL9 FS 349-485, SEAT TRACK FOUND TO BE OUT OF LIMITS IAW SRM 53-21-49-101-001-A01. REMOVED SEAT TRACK RBL9, FS349-485 IAW AMM 53-00-49-000-801-807. COMPLIED WITH ECSDR ASOA2015081513678Skin · corrodedPAX DOOR IS CORRODED UNDER PANEL 832AL, NUTPLATES. REMOVED OLD SKIN, LOCATED, DRILLED, INSTALLED NEW INNER SKIN IAW SRM 51-42-06-001-001, 51-42-13-001-001 & DWG 601R318024 & 601R31-702.SDR ASOA2015081513677Fastener · missingLEFT LOGO LIGHT IS MISSING 1 FASTENER, CAMLOCK. REMOVED LOGO LIGHT RETAINER IAW CMM 33-43-70 PGS, ITEM 4B. INSTALLED NEW LOGO LIGHT RETAINER RING IAW CMM 33-43-70, PG 6, ITEM 8, D, SS. THIS REPAIR IS CLASSIFIED AS A MAJOR/MINOR REPAIR IAW SOP 5702.SDR ASOA2015062513177Light · missingPHOTOLUMINESCENT EMERGENCY STRIP IS MISSING NEAR FOYER IN FRONT OF CATERING CARTS. INSTALLED MISSING PHOTOLUMINESCENT STRIP IN GALLEY IAW AMM 33-13-01. ACFT OK FOR SERVICE.SDR ASOA2015011612064Door · icedMAIN CABIN DOOR WAS STUCK CLOSED. COULD MOVE THE HANDLE ABOUT 1/3 OPEN AND PARTIALLY OPERATE THE CAM LOCKS BUT THEN IT WOULD JAM. REMOVED ICE FROM PASSENGER DOOR AND PERFORMED OPS CHECK IAW AMM 52-11-00 AND PERFORMED OPS CHECK GOOD.SDR ASOA2014062310716Handle · lack of lubeMAIN CABIN DOOR HANDLE IS BINDING WHEN F/A ATTEMPS TO OPEN OR CLOSE THE DOOR. LUBED PAX DOOR HANDLE, DOOR OPS CHECKED GOOD IAW AMM 52-11-00. ACFT OK FOR SERVICE.SDR ASOA2014050210461Megaphone · damagedMEGAPHONE DAMAGED. R & R MEGAPHONE IAW AMM25-61-19, REF AIPC 25-61-19, ITEM5.SDR ASOA2014010909739Acm · smokeSMOKE IN THE CABIN WHEN LT PACK CAME ON LINE AND TEMP SPIKED TO 99 AND LT PACK AUTO FAIL CAUTION MESSAGE, AIR CONDITIONING PACKS, BOTH PACKS. R & R LT ACM IAW AMM 21-51-08. OPS CHECKED IAW 21-51-08, FIG 1, ITEM 10.SDR ASOA2013100109134Handle · out of adjustFUNCTIONAL CHECK OF PAX DOOR FAILED. HANDLE EXCEEDED 16 POUNDS. ADJUSTED INNER HANDLE IAW AMM 52-11-02-820-801, STEPS 4B-3A-3E. OPS & FUNCTIONAL CHECKED GOOD.SDR ASOA2013100109133Support Angle · corrodedAFTER REMOVING SERVICE DOOR MOUNTING ANGLE DUE TO CORROSION, FOUND SILL ANGLE CORRODED. REMOVED SILL ANGLE PN SH 670-31986-1 IAW SRM 51-42-06-001-001-A01 & SRM 51-42-21-001-001-A01. DRILLED FASTENER LOCATIONS AND INSTALLED NEW SERVICABLE SILL ANGLE IAW SRSDR ASOA2013100109132Floorbeam · crackedLT COCKPIT FLOORBEAM CRACKED. REPAIRED IAW SRM 51-24-21-001-001-A01 AND REO 690-53-11-576. MAJOR REPAIR.SDR ASOA2013100109131Floorbeam · crackedRT COCKPIT FLOORBEAM CRACKED. FABRICATED REPAIR PARTS IAW SRM 51-24-21-001-001-A01. REPAIRED IAW ECTC REO 690-53-11-576. MAJOR REPAIR.SDR ASOA2013100109130Stringer · corrodedCORROSION FOUND ON STRINGER 26R BETWEEN BS 295 AND 310. REPAIRED IAW SRM 51-21-06-001-001-A01 & 63-21-03-201-002. MAJOR REPAIR.SDR ASOA2013100109129Frame · corrodedCORROSION FOUND ON FRAME FS 295 AT STRINGER 25R. REPAIRED IAW SRM 53-00-01-101-001-A01 AND REO 690-53-61-402.SDR ASOA2013100109128Sill · corrodedCORROSION FOUND ON PAX DOOR SILL BETWEEN BS 319 - 349. REMOVED PAX DOOR SILL IAW SRM 51-42-06-001-001-A01. REMOVED MID CAP ANGLE IAW SRM 51-42-06-001-001-A01. LOCATED AND DRILLED DEBURRED AND INSTALLED PAX DOOR SILL AND MIDCAP ANGLE IAW SRM 51-42-06-001-00SDR ASOA2013100109127Sill · corrodedCORROSION FOUND ON SERVICE DOOR SILL BETWEEN FS 319 - 349. REMOVED MOUNTING ANGLE AND LOWER SILL ANGLE IAW SRM 51-42-06-001-001-A01. DRILLED NEW SERVICEABLE MOUNTING ANGLE. INSTALLED NEW SERVICEABLE MOUNTING ANGLE IAW SRM 51-42-06-001-001-A01 & SRM 51-47-34-SDR ASOA2013100109126Frame · corrodedCORROSION AT BS 295 FRAME BETWEEN STRINGERS 26L AND 26R. REPAIRED IAW SRM 5-42-06-001-001-A01;51-21-06-001-001-A01;53-21-06-101-002-A02 AND REO 690-53-21-544.SDR ASOA2013100109125Frame · corrodedCORROSION AT FS 310, FRAME BETWEEN STRINGERS 26L AND 25R. REPAIRED IAW SRM 5-42-06-001-001-A01;51-21-06-001-001-A01;53-21-06-101-002-A02 AND REO 690-53-21-544.SDR ASOA2013100109124Frame · corrodedCORROSION AT FS 319 FRAME BETWEEN S26L AND 26R. REMOVED CORROSION IAW SRM 51-42-06-001-001-A01; 51-21-06-001-001-A01 AND 53-21-06-101-002-A02.SDR ASOA2013093009123Shear Tie · corrodedCORROSION AT FS 333 FRAME BETWEEN STRGS 27 AND 25R. THIS REPAIR IS CLASSIFIED AS A MAJOR REPAIR IAW ASA SOP 5702. REPAIRED IAW SRM 53-21-06-001-001-A01 AND REO 690-53-21-544.SDR ASOA2013093009122Frame · corrodedCORROSION AT FS 349 FRAME BETWEEN RT INTERCOSTALS AT S26R. REPAIRED IAW SRM 51-21-06-001-001-A01 AND REO 690-53-21-544.SDR ASOA2013093009121Frame · corrodedCORROSION AT FS 349, FRAME BETWEEN LT INTERCOSTALS AT S26L. REPAIRED IAW SRM 51-21-06-001-001-A01 AND REO 690-53-21-544. MAJOR REPAIR.SDR ASOA2013093009120Floor Support · corrodedPANEL 221ALF LT SIDE SUPPORT ANGLE IS CRACKED AT APPROX FS 278. THIS REPAIR IS CLASSIFIED AS A MAJOR REPAIR IAW ASA SOP 5702. REMOVED ANGLE IAW SRM 51-42-06-001-001-A01. LOCATED AND DRILLED UP NEW SUPPORT ANGLE IAW SRM 51-40-11. INSTALLED SERVICEABLE ANGLE SDR ASOA2013093009119Floor Support · crackedPANEL 221ALF RT SIDE SUPPORT ANGLE IS CRACKED AT APPROX FS 278. THIS REPAIR IS CLASSIFIED AS A MAJOR REPAIR IAW ASA SOP 5702. REMOVED RT SUPPORT ANGLE IAW SRM 51-42-06-001-001-A01. LOCATED AND DRILLED UP NEW SUPPORT ANGLE IAW SRM 51-40-11. INSTALLED SERVICSDR ASOA2013092709118Floorbeam · crackedRT FS 280 FLOORBEAM CORRODED AND CRACKED AT RBL 11.5. REMOVED FLOORBEAM IAW SRM 51-42-06-001-001-A01. INSTALLED FLOORBEAM IAW SB670BA-53-041. REPAIR CLASSIFIED AS MAJOR.SDR ASOA2013092709117Floorbeam · corrodedFS 280, FLOORBEAM CORRODED. REPAIRED IAW SRM 53-21-43-201-002-A01. REPAIR CLASSIFIED AS MAJOR.SDR ASOA2013092709116Post · corrodedRT BOTTOM DOOR POST SKIN AT FS 280 IS CORRODED. REPAIRED IAW SRM 51-21-06-001-001-A01, 53-00-00-101-001, AND REO 690-53-11-577. REPAIR CLASSIFIED AS MAJOR.SDR ASOA2013092709115Post · corrodedLT BOTTOM DOOR POST SKIN AT FS 280 IS CORRODED. REPAIRED IAW SRM 51-21-06-001-001-A01, SRM 53-00-00-101-001, AND REO 690-53-11-578. REPAIR CLASSIFIED AS MAJOR.SDR ASOA2013092709114Floorbeam · crackedFS 280 FLOORBEAM AT LBL 11.5 IS CRACKED. REMOVED LT FS 280 FLOORBEAM IAW SRM 51-42-06-001-001-A01 AND INSTALLED IAW SB670BA-53-041.SDR ASOA2013092709113Structure · chafedFUSELAGE HAS CHAFE DAMAGE AT APPROX BS 913.00 STR 27. REPAIRED IAW REO 670-53-00-290. REPAIR CLASSIFIED AS MAJOR.SDR ASOA2013092709112Floor Support · crackedFLOOR PANEL 195DL CHANNEL CRACKED, REMOVED CHANNEL IAW SRM 51-42-13-001-001-A01. LOCATED, DRILLED, DEBURED AND INSTALLED NEW SERVICEABLE CHANNEL IAW SRM 51-40-11-001-001-A01 AND DWG CC690-39302.SDR ASOA2013092709111Seat Track · corrodedRT FLOOR SEAT RAIL FROM BS 349 - 485 HAS SEVERAL SPOTS OF CORROSION, OUT OF LIMITS. REMOVED AND REPLACED SEAT TRACK IAW AMM 53-00-49-000-801.SDR ASOA2013092709110Seat Track · corrodedRIGHT SIDE SEAT TRACK AT BS 708 CORRODED. R & R SEAT TRACK IAW AMM 53-00-49-000-801, 53-00-49-400-801 AND ECTC REO 670-53-00-343, REV D.SDR ASOA2013092709109Seat Track · corrodedLEFT SEAT TRACK AT FS 708 CORRODED. REMOVED SEAT TRACK BETWEEN FS 672 - 722 IAW AMM 53-00-49-000-801-A07. INSTALLED NEW SEAT TRACK IAW AMM 53-00-49-400-801. REPAIR CLASSIFIED AS MAJOR.SDR ASOA2013100109135Frame · dentedFOUND DENT LOCATED ON THE AFT SIDE OF THE FRAME JUST ON FWD SIDE OF THE AFT EQUIP BAY DOOR OPENING. R & R DAMAGED FRAME FWD SIDE OF THE AFT EQUIP BAY DOOR AT FS 1108 IAW SRM 51-40-06, 51-42-11. REMOVED AND DRILLED ANGLE IAW SRM 51-42-06-001-001-A01 AND 51-4SDR ASOA2013092709108Floor Panel · crackedRT FWD ELECTRIC BAY FLOOR IS CRACKED BY ADG STOW PUMP. REPAIRED IAW GREO 670-53-11-509. REPAIR CLASSIFIED AS MAJOR.SDR ASOA2013041603381Lens · missingGALLEY EXIT LIGHT COVER MISSING ON REAR OF GALLEY. INSTALLED FLOODLIGHT LENS COVER IAW AMM 33-51-11. OPS CHECK GOOD. NEF CLEARED ACFT OK FOR SERVICE.SDR ASOA2012092802314Battery Pack · dischargedEMERGENCY OVERWING LIGHT INOPERATIVE ON RT AND LT SIDE AND SOME INTERIOR LIGHTS INOPERATIVE. CHARGED EMERGENCY LIGHT BATTERIES, PERFORMED AN OPS CHECK OF THE EMERGENCY LIGHTS IAW AMM 33-51-00 AND FOUND NO DEFECT.SDR ASOA2012092102256Data Plate · missingMEGAPHONE DATA PLATE IS MISSING. R & R THE MEGAPHONE IAW AMM 25-61-14. OPS CHECKED GOOD. SDR CLOSED.SDR COMA2012072490018Floorbeam · crackedFS 280 FLOORBEAM CRACKED AT LBL 9.0. REPAIRED LEFT FS 280 CROSSBEAM BY REPLACING BEAM IAW REO 690-53-11-092.SDR COMA2011072190015Warning System · false activationEN ROUTE FROM MIA TO DCA RECEIVED LEFT BLEED DUCT WARNING MSG. EMERGENCY DECLARED, A/C DIVERTED TO MCO LANDED SAFELY. INSPECTED LEFT BLEED DETECTION LOOPS IN AFT EQUIPMENT BAY. NO DEFECTS NOTED, OPS CHECK GOOD.SDR COMA2011040890005Floorbeam · corrodedFS 280 FLOORBEAM CORRODED LBL9 RBL 27. REMOVED AND REPLACED FS 280 FLOORBEAM IAW REO 690-53-11-092.
Back to N678CA