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 ASOA2016081515245Cover · missingEXIT SIGN ON FORWARD BULKHEAD IS MISSING THE COVER. INSTALLED A NEW COVER. OPS CHECKED GOOD IAW AMM 33-51-05.SDR ASOA2015112514130Charger · failedINTERIOR EMERGENCHY LIGHT FWD EXIT LOCATOR LT AND RT, EXTERNAL LIGHT FWD PASSENGER DOOR AND FWD SERVICE DOOR INOPERATIVE. R & R 31 EPSUU BATTERY CHARGER IAW AMM 33-51-17. IPC REF 33-51-177, FIG 1, ITEM 8. OPS CHECK GOOD.SDR ASOA2015082513589Bulb · burned out12 AB LOWER EXIT SIGN HAS ONE BULB BURNED OUT. R & R THE BULB. OPS CHECKED GOOD IAW AMM 33-51-00.SDR ASOA2015082513588Bulb · burned outGALLEY AFT LOWER EXIT SIGN HAS ONE BULB BURNED OUT. R & R THE BULB. OPS CHECKED GOOD IAW AMM 33-51-00.SDR ASOA2015072113371Battery Pack · dischargedSEVERAL EMERGENCY LIGHTS NOT WORKING AFT SECTION OF ACFT INSIDE AND OUTSIDE. TAIL STROBE AND NAVIGATION LIGHTS INOPERATIVE. REMOVED EPSU BATTERY PACK NR 4, AMM TASK 33-51-17-000-801, A01. INSTALLED SERVICEABLE EPSU BATTERY PACK NR 4 IAW AMM 33-51-17-400-801SDR ASOA2015071413346Lens · missingWHITE LENS CAP IS MISSING FROM CEILING PANEL 263ELC'S EMERGENCY EXIT SIGN CALL LIGHTS. REMOVED AND INSTALLED NEW EMERGENCY EXIT SIGN CALL LIGHTS LENS ON CEILING PANEL 263ELC IAW AMM 33-51-01-000-400-801-A01.SDR ASOA2015071413345Skin · corrodedSKIN ON PAX DOOR UNDER PANEL 832AL CORRODED AND CRACKED. REMOVED CORROSION ON THE PAX DOOR INNER SKIN UNDER PANEL 332AL IN REF TO SRM 51-21-06-001-001-A01. BLENDED AREA IS OUT OF LIMITS IAW SRM 52-11-01-101-001-A01. PERFORMED EDDY CURRENT INSPECTION OF INNESDR ASOA2015071413337Angle · crackedBS 280 RT LOWER BULKHEAD WEB ANGLE WAS FOUND CRACKED. R & R THE ANGLE IAW SRM 51-42-06-001-001-A01.SDR ASOA2015071413336Angle · crackedBS 280 LT SIDE LOWER WEB ANGLE CRACKED. R & R THE ANGLE IAW SRM 51-42-06-001-001-A01.SDR ASOA2015071413344Angle · corrodedSERVICE DOOR FLOOR TOP ANGLE OTBD SIDE HAS CORROSION. BLENDED CORROSION TO THE SERVICE DOOR TOP ANGLE IN REF TO SRM 51-21-06-001-001-A01. FOUND TO BE 100 PERCENT MATERIAL LOSS IN REF TO SRM 51-21-23-11-002-A01. R & R DOOR TOP ANGLE IN REF TO SRM 51-42-06-00SDR ASOA2015071413343Angle · corrodedSERVICE DOOR FLOOR TOP ANGLE HAS CORROSION ON TOP SIDE. R & R SERVICE DOOR TOP ANGLE IN REF TO SRM 51-42-06-001-001-A01 & 51-42-21-001-001-A01.SDR ASOA2015071413335Bulkhead Web · corrodedRT SIDE LOWER BS 280 BULKHEAD WEB CORRODED. COMPLIED WITH ECTC REO 670-53-11-594 AND GREO 670-53-11-594, REV A.SDR ASOA2015071413334Bulkhead Web · corrodedLT SIDE LOWER FS 280.00 BULKHEAD WEB CORRODED. COMPLIED WITH ECTC REO 670-53-11-594 AND GREO 670-53-11-594, REV A DATED 4-27-11.SDR ASOA2015071413333Floor Support · corrodedRT FLOOR SUPPORT JUST AFT OF SERVICE DOOR CORRODED. REMOVED CORROSION IAW SRM 51-21-06-001-001-A01. APPLIED CHEMICAL CONVERSION COATING TO BLENDED AREA IAW SRM 51-21-11-001-001-A01. COMPLIED WITH ECTC REO 670-53-00-390 AND REO 670-53-00-390, REV.SDR ASOA2015071413342Seat Track · corrodedLT SIDE SEAT TRACK CORRODED BS 485 - 576. FOUND TO BE OUT OF LIMITS IAW REO 670-53-00-013. R & R THE SEAT TRACK IAW AMM 53-00-49-000-801-A03 AND AMM 53-00-49-400-801-A03.SDR ASOA2015071413341Seat Track · corrodedLT SIDE SEAT TRACK CORRODED BS 677 - 703. FOUND TO BE OUT OF LIMITS IAW REO 670-53-00-013. R & R THE SEAT TRACK IAW AMM 53-00-49-000-801-A03 AND AMM 53-00-49-400-801-A03.SDR ASOA2015071413340Seat Track · corrodedRT SIDE SEAT TRACK CORRODED FROM BS 576 - 705. REMOVED CORROSION IAW SRM 51-21-06-001-001-A01. FOUND TO BE OUT OF LIMITS IAW SRM SUP 53-31-49. COMPLIED WITH ECTC REO 670-53-00-343 AND GREO 670-53-00-343, REV L.SDR ASOA2015071413339Seat Track · corrodedRT SIDE SEAT TRACK CORRODED FROM BS 485 - 576. REMOVED THE TRACK IAW AMM 53-00-49-000-801-A03 AND INSTALLED A NEW SEAT TRACK IAW AMM 53-00-49-400-801-A03.SDR ASOA2015071413338Seat Track · corrodedRT SIDE SEAT TRACK CORRODED AT APPROXIMATELY BS 437. THE SEAT TRACK WAS FOUND TO BE OUT OF LIMITS IAW SRM 53-31-49-101-001-A01 AND 51-21-06-001-001-A01. REMOVED AND REPLACED THE SEAT TRACK IAW AMM 53-00-49-000-801-A03, ECTC REO 670-53-00-343, REV J, AND AMMSDR ASOA2015071413332Floorbeam · corrodedFWD CENTER FLOORBEAM CORRODED. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-00-101-001-A01. R & R THE FLOORBEAM ANGLE IAW SRM 51-40-11-001-001-A01, 51-42-06-001-001-A01, 51-42-21-001-001-A01, 51-25-06-001-001-A01, 51-25-16-001-001-A01, AND 51-21-11-001-001-A01 ASDR ASOA2015042412643Bulb · inoperative12AB LOWER SIDEWALL EXIT SIGN HAD ONE BULB BURNED. R & R THE BULB AT 12AB SIDEWALL EXIT LIGHT IAW AMM 33-51-05.SDR ASOA2015042412642Bulb · inoperativeGALLEY AFT LOWER EXIT SIGN HAD ONE BULB OUT. R & R THE BULB AT GALLEY AFT EXIT SIGN IAW AMM 33-51-05.SDR ASOA2014050910472Lens · brokenRIGHT SIDE EXTERNAL FUSELAGE EMERGENCY LIGHT LENS ASSY BROKEN. R & R RT SIDE SERVICE DOOR EMERGENCY LIGHT COVER IAW AMM 33-51-15.SDR ASOA2013103009294Switch · malfunctionedEMERGENCY LIGHTS WILL NOT TURN OFF. RESET EMERGENCY LIGHT SWITCH. CHECKED GOOD IAW AMM 33-50-00.SDR ASOA2013092009070Skin · corrodedSKIN CORRODED UNDERNEATH ADF ANTENNA AT S27, FS 506 - 524. REPAIRED IAW SRM 57-42-06-001-001 & SRM 51-21-06-001-001 AND REO 670-53-31-297.SDR ASOA2013092009067Skin · corrodedFOUND EXTERNAL SKIN CORRODED AROUND TCAS ANTENNA CUTOUT S27, FS 302. REPAIRED IAW SRM 51-42-06-001-001 & SRM 51-21-06-001-001 AND REO 670-53-21-1001.SDR ASOA2013092009069Frame · corrodedFRAME BS 333 CORRODED FWD SIDE AT S37. REPAIRED IAW SRM 52-21-06-001-001-A01 AND RECEIVED REO 670-53-21-990.SDR ASOA2013092009066Angle · corrodedSERVICE DOOR SILL INBD MOUNTING ANGLE IS CORRODED. REMOVED MOUNTING ANGLE IAW SRM 51-42-06-001-001-A01. INSTALLED SERVICEABLE MOUNTING ANGLE IAW SRM 51-40-11-001-001-A01 AND SRM 51-42-06-001-001-A01. COMPLIED WITH RIGGING AND OP CHECKED IAW AMM 52-41-00-SDR ASOA2013092009065Frame · corrodedFRAME BS 333 CORRODED AFT SIDE AT S26-27R. BLENDED FRAME IAW SRM 51-21-06-001-001-A01. REPAIR CLASSIFIED AS MAJOR.SDR ASOA2013092009064Frame · corrodedFWD & AFT SIDE OF FRAME BS 295 CORRODED AT S27. REMOVED CORROSION IAW SRM 51-21-06-001-001-A01.SDR ASOA2013092009063Support Bracket · corrodedSERVICE DOOR THRESHOLD SUPPORT BRACKET CORRODED. REMOVED SUPPORT BRACKET IAW SRM 51-42-06-001-001-A01. DRILLED AND INSTALLED SERVICEABLE SUPPORT BRACKET IAW SRM 51-43-11-001-001-A01, 51-42-06-001-001-A01, 51-25-16-001-001-A01.SDR ASOA2013092009062Skin · dentedEXTERNAL SKIN DENTED AT BS 297, S26L. REPAIRED IAW REO 670-53-21-987. REPAIR CLASSIFIED AS MAJOR.SDR ASOA2013092009061Longeron Splice · corrodedLONGERON SPLICE 25R FS 333. REMOVED LONGERON SPLICE IAW SRM 51-42-06-001-001-A01. INSTALLED LONGERON SPLICE IAW SRM 51-42-06-001-001-A01, DWG SH670-32420. REPAIR CLASSIFIED AS MAJOR.SDR ASOA2013092009060Angle · corrodedSERVICE DOOR SILL PLATE ANGLE IS CORRODED. REMOVED ANGLE IAW SRM 51-42-06-001-001-A01. REPLACED SILL ANGLE IAW SRM 51-40-11-001-001-A01 AND SRM 51-42-06-001-001-A01. REPAIR CLASSIFIED AS MAJOR.SDR ASOA2013092009059Longeron · corrodedLONGERON 25R CORRODED BS 342. REPAIRED IAW SRM 53-21-23-001-003-A01.SDR ASOA2013092009058Intercostal · corrodedINTERCOSTAL CORRODED AT BS 364 S26L. REPAIRED IAW SRM 53-21-101-003-A01 AND 53-21-03-101-006-A01 AND REO 670-53-21-995.SDR ASOA2013092009057Intercostal · corrodedINTERCOSTAL CORRODED AT BS 364 S27L. REMOVED INTERCOSTAL AT FS 364-351 IAW SRM 53-21-23-101-003-A01 & 51-42-21-001-A01 & 51-42-06-001-001-A01. LOCATED & DRILLED NEW SERVICEABLE INTERCOSTAL IAW SRM 51-40-11-001-001-A01 & DWG SH670-32075. INSTALLED INTERCOSDR ASOA2013092009056Intercostal · corrodedINTERCOSTAL CORRODED AT BS 364 S27R. REMOVED INTERCOSTAL IAW SRM 53-21-33-101-003-A01 & 51-42-21-001-A01 & 51-42-06-001-001-A01. LOCATED & DRILLED NEW SERVICEABLE INTERCOSTAL IAW SRM 51-40-11-001-001-A01 & DWG SH670-32075. INSTALLED INTERCOSTAL IAW DWGSDR ASOA2013092009055Intercostal · corrodedINTERCOSTAL CORRODED AT BS 364, S26R. REMOVED INTERCOSTAL IAW SRM 53-21-23-101-003-A01 & 51-42-06-001-001-A01. LOCATED & DRILLED NEW SERVICEABLE INTERCOSTAL IAW SRM 51-40-11-001-001-A01 & DWG SH670-32077.SDR ASOA2013092009054Frame · corrodedFRAME BS 349 CORRODED AT S27. REPAIRED IAW SRM 53-12-06-101-006-A01.SDR ASOA2013091909050Stringer · corrodedSTRINGER 26R CORRODED AT BS 342. R & R STRINGER AND STRINGER SPLICE FROM BS 333-364 IAW SRM 51-42-06-001-001-A01. REPAIR CLASSIFIED AS MAJOR.SDR ASOA2013091909049Skin · corrodedCIRCUMFERENTIAL JOINT AT FRAME BS 333, INTERNAL SKIN CORRODED AT S27. REMOVED CORROSION IAW SRM 51-21-06-001-001-A01.SDR ASOA2013091909048Frame · corrodedFRAME BS 319.7, FWD SECTION CORRODED FROM S26L TO 26R. REMOVED CORROSION IAW SRM 51-21-06-001-001-A01. COMPLIED WITH GREO REO 670-53-21-799. REV, DATED 2012-01-30.SDR ASOA2013091909047Frame · corrodedFWD & AFT SIDE OF FRAME BS 295 CORRODED STRINGER 27. REMOVED CORROSION IAW SRM 51-21-06-001-001-A01.SDR ASOA2013091909046Stringer · corrodedSTRINGER 26R CORRODED AT BS 280. REPAIRED IAW SRM 51-21-06-001-001-A01, 57-42-06-001-001-A01, 51-42-06-001-001-A01, DWG SH670-31634 AND REO 670-53-21-996.SDR ASOA2013091909045Floor Support · corrodedCRAWLWAY FLOOR PANEL 141ALF FWD FLOOR SUPPORT ANGLE CORRODED. REMOVED FLOOR SUPPORT IAW SRM 51-42-06. LOCATED, DRILLED & DEBURRED HOLES IAW SRM 51-40-11-001-001-A01. INSTALLED NEW FLOOR SUPPORT ANGLE IAW SRM 51-42-06-001-001-A01.SDR ASOA2013091909044Doubler · corrodedTCAS DOUBLER CORRODED AT STRINGER 27 BETWEEN BS 295 & 310. REPAIRED IAW SRM 51-42-06-001-001-A01 AND 51-23-00-001-001-A01. MAJOR REPAIR.SDR ASOA2013091909043Seat Track · corrodedSIDEWALL SEAT RAIL CORRODED MULTIPLE SPOTS AT BS 677-708 AND S15R. 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 SERVICEABLE SEAT TRACK IAW AMM 53-00-49-400-801.SDR ASOA2013091909042Seat Track · corrodedSIDEWALL SEAT TRACK CORRODED MULTIPLE SPOTS AT BS 785.15-863 S15L. REMOVED SEAT TRACK IAW AMM 53-00-49-000-801. INSTALLED NEW SEAT TRACK IAW AMM 53-00-49-400-801.SDR ASOA2013091909041Seat Track · corrodedSEAT TRACK CORRODED, MULTIPLE SPOTS, BS 677-830.4 LBL 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 SERVICEABLE SEAT TRACK IAW AMM 53-00-49-400-801.
Back to N391CA