N691CA
Service difficulty reports · 242
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 = 'N691CA' 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 = 'N691CA' 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 REXA2022092102124Stringer · corrodedCORROSION FOUND ON STRINGER 27 AFT BETWEEN F.S. 310.00 TO F.S. 319.00. REMOVED AND REPLACED STRINGER 27 AFT BETWEEN F.S. 295.00 TO F.S. 333.00 IAW CRJ900 SRM 51-42-06-001-001-A01 AND CRJ900 SRM 51-42-21-001-001-A01SDR REXA2022092102116None · corrodedLH SIDE SEAT RAIL BETWEEN FS847+14-907 HAS MULTIPLE SPOTS OF CORROSION REMOVED AND REPLACED LH SIDE SEAT RAIL BETWEEN FS847.00+14 TO FS907 WITH P/N SH670-37543-3, IAW CRJ900 AMM 53-00-49-400-801-A01SDR REXA2022092002111Stringer · corrodedSTRINGER 25R IS CORRODED BETWEEN FS 581.00 AND 597.00. REPAIRED STRINGER 25R BETWEEN FS 581.00 AND 597.00IAW EA# CRJ953-14334 DATED 08/06/2022.SDR REXA2022092102133Beam · corrodedFLOOR BEAM AT LBL9 HAS MULTIPLE SPOTS OF CORROSION FROM FS1000 TO FS1088. REPAIRED FLOOR BEAM IAW CRJ900 SRM 53-00-41-201-001-A03.SDR REXA2022092602141Intercostal · corrodedINTERCOSTAL DD6 AT AFT SIDE FOUND TO BE CORRODED. REMOVED AND REPLACED INTERCOSTAL DD6 AT AFT SIDE IAW CRJ 900 SRM 51-40-11-001-001-A01 AND 51-42-06-001-001-A01.SDR REXA2022092102128Intercostal · corrodedMID INTERCOSTAL AT DD6 FOUND TO BE CORRODED IN MULTIPLE LOCATIONS. REMOVED AND REPLACED INTERCOSTAL IAW CRJ 900 SRMS 51-40-11-001-001-A01, 51-42-06-001-001-A01, AND 51-42-21-001-001-A01.SDR REXA2022092102127Former · corrodedAFT FORMER ON PASS DOOR FOUND TO HAVE CORROSION IN MULTIPLE LOCATIONS. LOCATED, DRILLED, AND INSTALLED SERVICEABLE AFT FORMER IAW CRJ 900 SRM 51-40-11-001-001-A01 AND 51-42-06-001-001-A01.SDR REXA2022092102115Seat Track · corrodedCORROSION FOUND ON LBL 27 SEAT TRACK BETWEEN FS 364-485. REMOVED AND REPLACED SEAT TRACK AT LBL 27 BETWEEN F.S.364 TO F.S.485SDR REXA2022092102114Seat Track · corrodedCORROSION FOUND ON LBL 9 SEAT TRACK BETWEEN FS 379-485. REMOVED AND REPLACED SEAT TRACK AT LBL 9 BETWEEN F.S.379 TO F.S.485SDR REXA2022092002110Intercostal · corrodedPAX DOOR CENTER INTERCOSTAL DD7 IS CORRODED. REMOVED AND REPLACED INTERCOSTAL IAW CRJ 900 SRMS 51-40-11-001-001-A01 AND 51-42-06-001-001-A01.SDR REXA2022092002109Skin · corrodedPAX DOOR INNER SKIN IS CORRODED. REMOVED AND REPLACED INNER SKIN IAW CRJ 900 SRMS 51-40-11-001-001-A01, 51-42-06-001-001-A01, 51-42-13-001-001-A01, AND 51-42-22-001-001-A01.SDR REXA2022092202120Frame · crackedL/H AFT OVERWING EXIT (S/N SBO539) TOP EDGE MEMBER IS CRACKED COMPLIED WITH ENDEAVOR EA CRJ952-14340 REV IR DATED 8/26/22SDR REXA2022092002113Angle · corrodedFRAME (ANGLE) CORRODED AT FS265.00 BETWEEN STGR 26L AND 27 REMOVED AND REPLACED ANGLE IAW BOMBARDIER CRJ900 SRM 51-42-06-001-001-A01SDR REXA2022092002108Frame · crackedL/H FWD OVERWING EXIT DOOR (S/N SBO532) TOP EDGE MEMBER IS CRACKED. REPAIRED DAMAGE I.A.W. ENDEAVOR EA CRJ952-14342 REV.IR, DATED 08/26/2022SDR REXA2022091402066None · corrodedLH SIDE SEAT RAIL BETWEEN FS 670-720 HAS MULTIPLE SPOTS OF CORROSION INSTALLED NEW SIDE SEAT RAIL P/N SH690-36284-1 ON L/H BETWEEN FS670-FS720 WL 85.25 IAW CRJ 900 AMM 53-00-49-400-801-A01SDR REXA2022091402069Stringer · corrodedMULTIPLE AREAS OF CORROSION ON STRINGER 26L BETWEEN F.S. 310.00 TO F.S. 333.00. REMOVED CORRODED STGR 26L FROM FS 295 TO FS 333 IAW CRJ 900 SRM 51-42-06-001-001-A01 AND 51-42-21-001-001-A01. INSTALLED STGR 26L FROM FS 280 TO FS 333 IAW CRJ 900 SRM 51-42-06-001SDR REXA2022091402067None · corrodedL/H FLOOR SILL DRIP TRAY IS CORRODED AT RIVETS BETWEEN F.S.693 TO F.S.847. REMOVED AND REPLACED L/H FLOOR SILL DRIP TRAYS BETWEEN F.S. 693 AND F.S. 847 WITH NEW SERVICEABLE P/N'S SH670-36175-3, SH670-36171-3 AND SH670-36172-3 IAW ENDEAVOR EA CRJ953-14502 REV ASDR REXA2022091402065Seat Track · corrodedSEAT TRACK RBL 9 BETWEEN FS 681-836 HAS MULTIPLE SPOTS OF CORROSION. FABRICATED SEAT TRACK PART NUMBER BA690-30000-5979 OUT OF RAW STOCK PART NUMBER 20276-288-0-0A IAW CRJ900 SRM 53-00-49-201-002-A01, INSTALLED TRACK IAW CRJ900 AMM 53-00-49-000/400-801-A07.SDR REXA2022091402064Seat Track · corrodedSEAT TRACK LBL9 BETWEEN FS 661+32-681 HAS MULTIPLE SPOTS OF CORROSION. INSTALLED NEW SEAT TRACK @ LBL 9 BETWEEN FS 661.00+32 TO FS 681.00 IAW CRJ 900 AMM 53-00-49-400-801 (A07)SDR REXA2022091402063Stringer · corrodedSTRINGER 22L IS CORRODED BETWEEN FS 501.00 AND 517.00. COMPLIED WITH ENDEAVOR EA CRJ953-14312 REV IR DATED 8/10/22SDR REXA2022091402068Stringer · corrodedMULTIPLE AREAS OF CORROSION ON STRINGER 25L BETWEEN F.S.280 TO F.S.333 REMOVED AND REPLACED STRINGER 25L BETWEEN F.S.280 TO F.S.333.SDR REXA2022090902055Seat Track · corrodedCORROSION FOUND ON RBL 9 SEAT TRACK BETWEEN FS 349-485. REMOVED CORRODED SEAT TRACK RBL 9 F.S.349 TO F.S.485 AND INSTALLED NEW SERVICEABLE SEAT TRACK RBL 9 F.S. 349-485 IAW CRJ-900 -AMM 53-00-49-400-801-A07.SDR REXA2022090702027Seat Track · corrodedSEAT TRACK LBL9 BETWEEN FS 681-836 HAS MULTIPLE SPOTS OF CORROSION. REPLACED LBL9 SEAT TRACK BETWEEN FS681 AND FS836 IAW CRJ900 AMM 53-00-49-400-801-A07 AND SRM 51-40-11-001-001-A01SDR REXA2022090702031Intercostal · corrodedINTERCOSTAL DD2 AT FWD SIDE FOUND TO BE CORRODED ON PAX DOOR LOCATED, DRILLED AND INSTALLED INTERCOSTAL DD2 AT FWD SIDE ONTO PAX DOOR IAW CRJ900 SRM 51-40-11-001-001-A01 AND SRM 51-42-06-001-001-A01 P/N 601R318051-1SDR REXA2022090702030None · corrodedRH SIDE SEAT RAIL STRUCTURE AT FS 785.15-847+8 HAS MULTIPLE SPOTS OF CORROSION. REMOVED AND REPLACED RH SIDE SEAT RAIL STRUCTURE AT FS 785.15-847+8 CRJ 900 AMM 53-00-49-400-801-A07SDR REXA2022090702029None · corrodedRH SIDE SEAT RAIL AT FS 847+13-868 HAS MULTIPLE SPOTS OF CORROSION. REPLACED RH SIDE SEAT RAIL AT FS847+13-868 IAW CRJ900 AMM 53-41-49-400-801-A07SDR REXA2022090702028None · corrodedLH SIDE SEAT RAIL BETWEEN FS 785.15-847+14 HAS MULTIPLE SPOTS OF CORROSION. REMOVED AND REPLACED LH SIDE SEAT RAIL BETWEEN FS 785.15-847+14 CRJ 900 AMM 53-00-49-400-801-A07SDR REXA2022090702026Seat Track · corrodedSEAT TRACK LBL9 BETWEEN FS 581-661+32 HAS MULTIPLE SPOTS OF CORROSION. REMOVED AND INSTALLED NEW SERVICEABLE LBL9 SEAT TRACK P/N: SH690-33404-1 FROM FS581 TO FS661+32 IAW CRJ900 AMM 53-00-49-400-801-A07.SDR REXA2022090702025Stringer · corrodedSTRINGER 23R IS CORRODED BETWEEN FS 364.00 AND 379.00 REPLACED STGR23R FROM FS280 TO FS379 IAW CRJ900 SRM 51-42-06-001-001-A01 AND 51-42-20-001-001-A01SDR REXA2022090702024Angle · corrodedFWD NUT PLATE ANGLE FOR PANEL 542AZ IN WHEEL WELL IS CORRODED. REPLACED ANGLE P/N CC670-10338-1 IAW CRJ 900 SRM 51-42-21-001-001-A01SDR REXA2022090702023Angle · corrodedFWD NUT PLATE ANGLE FOR PANEL 642AZ IN RH WHEEL WELL IS CORRODED. REPLACED ANGLE P/N CC670-10338-2 IAW CRJ 900 SRM 51-42-21-001-001-A01SDR REXA2022090602016Splice · corrodedFWD BELLY FAIRING SUPPORT STRAP FOR PANEL 191AB IS CORRODED INSTALLED NEW SPLICE JOINT PLATE P/N SH670-39054-3 IAW CRJ900 SRM 51-42-06-001-001-A01 & 51-42-10-001-001-A01.SDR REXA2022090602015Intercostal · corrodedWHILE REMOVING INTERCOSTAL DD4 AT AFT SIDE FOUND THE CLEAT TO BE CORRODED IN MULTIPLE LOCATIONS. LOCATED DRILLED AND INSTALLED NEW SERVICEABLE INTERCOSTAL DD4 AT AFT SIDE CLEAT IAW CRJ 900 SRM 51-40-11-001-001-A01 AND 51-42-06-001-001-A01 PN: 600-31902-269SDR REXA2022090602014Intercostal · corrodedMID INTERCOSTAL AT DD4 FOUND TO BE CORRODED IN MULTIPLE LOCATIONS. LOCATED DRILLED AND INSTALLED NEW SERVICEABLE MID DD4 INTERCOSTAL IAW CRJ 900 SRM 51-40-11-001-001-A01 51-42-21-001-001-A01 AND 51-42-06-001-001-A01 PN: 601R318081-1SSDR REXA2022090602013Intercostal · crackedINTERCOSTAL DD1 AT AFT SIDE FOUND TO BE CRACKED. LOCATED DRILLED AND INSTALLED NEW SERVICEABLE INTERCOSTAL DD1 AT AFT SIDE IAW 51-40-11-001-001-A01 AND 51-42-06-001-001-A01 PN:601R31902-318SDR REXA2022090602012None · corrodedRH SIDE SEAT RAIL AT FS 744-752 HAS MULTIPLE SPOTS OF CORROSION. INSTALLED NEW SIDE SEAT RAIL P/N SH690-36285-1 ON R/H FS 744 - FS 752 WL 85.25 IAW CRJ 900 AMM 53-00-49-400-801(CONFIG 07)SDR REXA2022090602011None · corrodedRH SIDE SEAT RAIL AT FS 868-969 HAS MULTIPLE SPOTS OF CORROSION. FABRICATED NEW SIDE SEAT RAIL FROM MAT. EXTRUSION P/N 20276-288-0-0A P/O:W000077329 IAW CRJ 900 SRM 53-00-49-201-002-A01 STEP 3 (A,B,C AND D) TABLE 1 PAGE 206. INSTALLED NEW SIDE SEAT RAIL ON APPSDR REXA2022090602010None · corrodedLH SIDE SEAT RAIL BETWEEN FS 744-752 HAS MULTIPLE SPOTS OF CORROSION. REMOVED AND REPLACED LH SIDE SEAT RAIL BETWEEN FS 744.15 TO FS 761.85 WITH P/N SH690-36285-1 IAW CRJ900 AMM 53-00-49-400-801-A07SDR REXA2022090602009Seat Track · corrodedSEAT TRACK RBL9 BETWEEN F.S.661+32-681 HAS MULTIPLE SPOTS OF CORROSION REMOVED AND REPLACED RBL9 SEAT TRACK SEGMENTSDR REXA2022090602008Seat Track · corrodedSEAT TRACK RBL9 BETWEEN F.S.581-661+32 HAS MULTIPLE SPOTS OF CORROSION REMOVED AND REPLACED RBL9 SEAT TRACK SEGMENTSDR REXA2022090602007Seat Track · corrodedSEAT TRACK RBL9 BETWEEN F.S.485-581 HAS MULTIPLE SPOTS OF CORROSION REMOVED AND REPLACED RBL9 SEAT TRACK SEGMENTSDR REXA2022090602006Seat Track · corrodedR/H SIDE SEAT TRACK IS CORRODED BETWEEN F.S.549 AND F.S.565 REMOVED AND REPLACED RIGHT SIDE SEAT TRACK SEGMENTSDR REXA2022090602005Seat Track · corrodedR/H SIDE SEAT TRACK IS CORRODED AT F.S.613 REMOVED, FABRICATED, AND INSTALLED NEW RIGHT SIDE SEAT TRACK SEGMENTSDR REXA2022090602004None · corrodedL/H SIDE SEAT TRACK IS CORRODED BETWEEN F.S.693 AND F.S.708 REMOVED AND REPLACED LEFT SIDE SEAT TRACK SEGMENTSDR REXA2022090601995None · corrodedAFT CARGO DOOR FLOOR SILL IS CORRODED. REMOVED AND REPLACED AFT CARGO DOOR FLOOR SILLSDR REXA2022090101992Intercostal · corrodedPAX DOOR INTERCOSTAL DD4 AT AFT SIDE FOUND TO BE CORRODED LOCATED DRILLED AND INSTALLED NEW SERVICEABLE INTERCOSTAL DD4 AT AFT SIDE IAW CRJ 900 SRM 51-42-21-001-001-A01 AND 51-42-06-001-001-A01.SDR REXA2022082401949Frame · corrodedFRAME AT FS 927 CORRODED BETWEEN STRGR 24L AND 24R REMOVED AND REPLACED NEW FRAME P/N: SH690-37083-3 AT FS 927 BETWEEN STR 20L TO STR 23R IAW CRJ 900 SRM 53-00-06-201-001-A03SDR REXA2022082301940Channel · crackedAFT CARGO DOOR AFT TRACK LOWER FWD "U" CHANNEL IS CRACKED. REPLACED“U” CHANNEL P/N MM670-35552-005 IAW CRJ900 SRM 51-42-06-001-001-A01 AND CRJ900 SRM 51-42-21-001-001-A01.SDR REXA2022082401954Splice · corrodedGUSSET AT FS 379 AND STRINGER 21R IS CORRODED. REPLACED JOINT PIECE AT STRINGER 21R BETWEEN FS 379 TO 394 IAW CRJ900 SRM 51-42-06-001-001-A01 AND SRM 51-40-11-001-001-A01SDR REXA2022082401953Frame · corrodedFRAME 379 IS CORRODED BETWEEN STRINGERS 20R TO 21R REPLACED FS379 FRAME BETWEEN STRINGERS 20R TO 25R IAW CRJ900 SRM 51-42-06-001-001-A01 AND 51-40-11-001-001-A01
Back to N691CA