N390CA
Service difficulty reports · 287
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 = 'N390CA' 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 = 'N390CA' 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 ASOA201100615Support Angle · crackedLT MLG WHEEL BIN FWD SUPPORT ANGLE CRACKED IN LWR RADIUS. R & R SUPPORT ANGLE IAW SRM 51-41-02.SDR ASOA201100778Seat Track · corrodedSEAT TRACK 2, LBL9 HAS SEVERAL AREAS OF LIGHT CORROSION. REMOVED SEAT TRACK NR 2, LBL 9 AND REPLACED WITH REPAIR TRACK IAW REO 670-53-00-074.SDR ASOA201100718Seat Track · corrodedSEAT TRACK NR 3, LBL9 HAS SEVERAL AREAS OF LIGHT CORROSION. REMOVED NR 3, LBL 9 SEAT TRACK AND REPLACED WITH NEW IAW SRM 51-41-00.SDR ASOA201100717Seat Track · corrodedSEAT TRACK NR 3 RBL9 HAS SEVERAL AREAS OF LIGHT CORROSION. R & R SEAT TRACK IAW SRM 51-41-00-001-A01, & AMM 20-21-00(7).SDR ASOA201100597Placard · fadedCREW ESCAPE HATCH EXTERNAL "OPEN" PLACARD FADED & INSTRUCTION PLACARD MISSING. WORK ACCOMPLISHED ON AP 16 NR 22985.SDR ASOA201100596Bracket · crackedBRACKET IN RT WHEEL WELL AT STA 693 RBL 35 HAS CRACKED ANGLE. R & R BRACKET IAW SRM 51-41-02, PAR 3.SDR ASOA201100595Floorbeam · corrodedUPPER SURFACE OF FLOOR SUPPORT CROSSMEMBER TAB CORRODED AT FS 310.00 & LBL 9. REMOVED CORROSION IAW SRM 51-21-06 TREATED EFFECTED AREA IAW SRM 51-21-11 AND PRIMED IAW SRM 51-25-06.SDR ASOA201100594Floorbeam · corrodedUPPER SURFACE OF FLOOR SUPPORT CROSSMEMBER CORRODED AT FS 318.00 & LBL 9. REMOVED CORROSION IAW SRM 51-21-06 ALODINED EFFECTED AREA IAW SRM 51-21-11 AND PRIMED IAW SRM 51-25-06.SDR ASOA201100593Stringer · corrodedSTR 21L CORRODED AT FS 333.00. REMOVED CORROSION, FOUND TO BE WITNIN LIMTS IAW SRM 53-00-00.SDR ASOA201100592Frame · corrodedFS 349.00 FRAME CORRODED AT STR 27. REMOVED CORROSION IAW SRM 51-21-06. FOUND TO BE WITHIN LIMITS IAW SRM 51-21-06.SDR ASOA201100591Longeron · corrodedLONGERON JUST RT OF STR 27 CORRODED FROM FS 358 TO 364. REMOVED CORROSION IAW SRM 51-12-00 ORIGINAL MATERIAL THICKNESS IS .80", .5 " MATERIAL LOSS . 75, REMAINING WITHIN LIMITS IAW SRM 53-00-00.SDR ASOA201100590Stringer · corrodedSTR 25R CORRODED FROM FS 324 TO 328. REPAIRED STRINGER IAW REO 670-53-21-673.SDR ASOA201100589Frame · corrodedFS 319.00 FRAME CORRODED BETWEEN STR 26L & 27. REMOVED CORROSION IAW SRM 51-21-06 WITHIN LIMITS IAW SRM 53-00-00.SDR ASOA201100588Skin · corrodedSKIN STRAP AT FS 280 CORRODED BETEEN STR 27 & 26L. REMOVED CORROSION IAW SRM 51-21-06, STEP 3D WITHIN LIMITS IAW SRM 53-00-01.SDR ASOA201100587Skin · corrodedSKIN STRAP AT FS280 CORRODED BETEEN STR 27 & 26R. REMOVED CORROSION IAW SRM 51-21-06 STEP 3D WITHIN LIMITS IAW SRM 53-00-01.SDR ASOA201100586Stringer · corrodedSTRINGER 25R CORRODED AT FS 305.00. REPAIRED STRINGER IAW REO 670-53-21-673.SDR ASOA201100585Stringer · corrodedSTR 26R CORRODED AT FS 303.00. REPAIRED STR 26R, STA 303 IAW REO 670-53-21-673.SDR ASOA201100584Frame · corrodedFS 295.00 FRAME CORRODED FROM OTBD SIDE OF STR 26L TO STR 27. REMOVED CORRSION IAW SRM 51-21-06. FOUND TO BE WITHIN LIMITS IAW SRM 51-21-06.SDR ASOA201100583Frame · corrodedFS 310.00 FRAME CORRODED FROM OTBD SIDE OF S25L TO JUST RT OF S27. REMOVED CORROSION IAW SRM 51-21-06 WITHIN LIMITS IAW SRM 53-00-00.SDR ASOA201100582Structure · crackedPASSENGER DOOR LWR EDGE MEMBER CRACKED AT AFT RADIUS. REPAIRED PASSENGER DOOR LOWER EDGE MEMBER IAW EC/TC REO 670-52-11-154.SDR ASOA201100550Strap · corrodedSKIN STRAP IS CORRODED AT FS 280 BETWEEN 24R & 23R. REMOVED CORROSION, TREATED, PRIMED, TOP COATED SKIN STRAP IAW SRM 53-00-01.SDR ASOA201100549Strap · corrodedSKIN STRAP AT FS 280 IS CORRODED BETWEEN 25R & 24R. REMOVED CORROSION, TREATED, PRIMED, TOP COATED SKIN STRAP IAW SRM 53-00-01.SDR ASOA201100548Strap · corrodedSKIN STRAP AT FS280 CORRODED BETWEEN 26R & 25R. REMOVED CORROSION, TREATED, PRIMED, TOP COATED SKIN STRAP IAW SRM 53-00-01.SDR ASOA201100547Support Bracket · corrodedUNDER FLOOR PANEL SUPPORT BRACKET AT FS 280 IS CORRODED. REMOVED SUPPORT BRACKET AND REPLACED WITH NEW IAW SRM 51-42-20.SDR ASOA201100546Unknown · corrodedRIGHT BS 280 FLOORBEAM CORRODED. REPAIRED FLOORBEAM IAW EC/TC REO 670-53-11-047.SDR ASOA201100545Floorbeam · corrodedLEFT BS 280 FLOORBEAM IS CORRODED. REPAIRED FLOORBEAM IAW EC/TC REO 670-53-11-047.SDR ASOA201100544Stringer · corrodedSTRINGER 26R CORRODED AT FS 364. REPAIRED STRINGER IAW REO 670-53-21-673.SDR ASOA201100531Placard · missingCREW ESCAPE HATCH EXTERNAL OPENING INSTRUCTIONS PLACARD MISSING. PLACARD INSTALLED.SDR ASOA201100526Skin · corrodedEXTERNAL SKIN CORRODED BELOW FWD POTABLE WATER SERVICE DOOR FWD HINGE. REMOVED CORROSION IAW REO 670-53-21-670.SDR ASOA201001903Windshield · crackedCAPT WINDSHIELD BURNED AND CRACKED. REPLACED CAPT WINDSHIELD IAW AMM 56-11-01. OPS CHECK AND LEAK CHECK GOOD.SDR ASOA201001517Flashlight · inoperativeAFT F/A FLASHLIGHT INOP. R & R AFT F/A FLASHLIGHT IN REF TO AMM CHAP 25-61-02. OPS CK GOOD NO DEFECTS NOTED.SDR ASOA201001016Placard · damagedPAX DOOR PLACARDS "EXIT", "OPEN" AND "OPEN ARROW" ARE ALL DAMAGED. R & R PAX DOOR "EXIT", "OPEN" AND "ARROW" PLACARDS IAW AMM 20-60-04.SDR ASOA201000923Detector · failedFLAPS FAIL AT FL 350 LANDED IN ATL WITH FLAPS 1 DEGREE IAW QRH. (EMERGENCY DECLARED) R & R LT OTBD SKEW DETECTOR AS REQUIRED IAW AMM 27-50-01, TRIED TO RIG SKEW DETECTOR MDC SHOWED SFECU 2 NO COMM REFER TO AFDL NR 535400-2 FOR CONTINUATION. (CLOSED)SDR ASOA201000922Flap System · failedFLAPS FAIL CAUTION IN CRUISE FLIGHT. (EMERGENCY TRUCKS REQUESTED AS A PRECAUTION - EMERGENCY DECLARED BY TOWER) T/S IAW FIM 27-52-45. PERFORMED CLEAR INHIBITS AND LRU TEST. FLAP FAIL MSG CLEARED. FLAPS AND SLATS OPS CHECK GOOD. (CLOSED)SDR ASOA201000868Placard · deterioratedPAX DOOR OPEN AND EXIT PLACARD DETERIORATED. R & R RT MLG SIDE STAY ACTUATOR IAW AMM 32-32-01. OPS AND LEAK CK GOOD. (CLOSED)SDR ASOA201000860Seat Track · corrodedMAIN CABIN CORROSION ON RT INBD SEAT TRACK STA 349-364 AND 374 TO 379. RT INBD SEAT TRACKS AT FS 349-583 100 PERCENT MATERIAL LOSS. R & R 2 EA SEAT TRACK PN SH670-52159-1 & SH670-33426-1 IAW SRM 51-40-02R. (CLOSED)SDR ASOA201000294Warning Light · false activationSMOKE AFT LAV MASTER WARNING, EMERGENCY DECLARED -- TRUCKS STANDING BY AS A PRECAUTION. INSPECTED AFT LAV NO EVIDENCE OF FIRE AN THE AREA THE TEMPERATURE TAPE WAS IN NORMAL RANGE. SMOKE CLEARED AFTER LANDING REPORTED BY CREW. OK FOR SERVICE IAW AMM 26-16-00.SDR ASOA201000285Bulb · inoperativeSERVICE DOOR RT LWR EMERGENCY EXIT LIGHT & RT OVERWING EXIT LWR EMERGENCY EXIT LIGHT BOTH HAVE BULBS INOP. RELAMPED SERVICE DOOR AND OVERWING EMERGENCY LIGHTS IAW AMM 33-51-15. 02-20-10.SDR ASOA201000174Light · smokeSEAT 1A READING LIGHT MISSING COVER AND SMOKES WHEN ON. LIGHT LENS/ COVERS (INCLUDING EMERGENCY LIGHT) ) FLT 5163 DEL 220 MINS. FLTS 5116,5163 CX. REPLACED MISSING READING LIGHT LENS IAW AMM 33-22-01. DMIL 521170-3 CLEARED. PLACARD REMOVED. ACFT OK FOR SERSDR ASOA201000103Circuit Breaker · failedSTEERING INOP CAUTION MSG AFTER TAKEOFF.QRH RUN. EMERGENCY LANDING DEPARTURE. RESET CIRCUIT BREAKERS INOP CAUTION MSG EXTINGUISHED. (EMERGENCY DECLARED). PERFORMED OPS TEST OF NOSE WHEEL STEERING IAW AMM 32-51-00. NO DEFECTS NOTED.SDR ASOA200901281Sign · inoperative14CD SMALL EMERGENCY EXIT SIGN LIGHTS ARE INOP.SDR ASOA200901125Megaphone · inoperativeAFT MEGAPHONE INOP.SDR ASOA200901109Step · brokenASD BTM STEP FWD SIDE BROKEN. REMOVED AND REPLACED ASD BOTTOM STEP IAW AMM 52-11-04.SDR ASOA200900711Warning System · activatedLEFT ENGINE BLEED CAUTION MSG AFTER TAKEOFF. FLT 5216 CX - A/C RETURNED TO ATL AFTER T/O, EMERGENCY DECLARED.SDR ASOA200900678Light · inoperativeRT EXTERIOR EMERGENCY LIGHT JUST AFT OF RT EMERGENCY EXIT, INOPERATIVE.SDR ASOA200900256Angle · corrodedFR 280 FWD ANGLE CORRODED BEYOND LIMITS. REMOVED ANGLE,INSTALLED NEW ANGLE AND INSTALLED CAMLOCK RECEPTACLES PER SRM 51-42-06.SDR ASOA200900261Spherical Bearin · crackedRT AFT WING TO FUSELAGE ATTACH LINK AT FS 797.00 UPPER SPHERICAL BEARING CRACKED. PERFORMED DETAIL VISUAL INSPECTION OF THE RT UPPER SPHERICAL BEARING TO ENSURE THAT THE BALL IS PROPERLY RETAINED IN THE RACE OF THE BEARING. ALSO PERFORMED A DETAILED INSPECTISDR ASOA200900260Drag Angle · crackedLT VERTICAL STAB LOWER DRAG ANGLE CRACKED (MARKED). CRACK LENGTH WAS VERIFIED IAW SRM NDTM 51-20-006. LEFT VERTICAL STAB TO FUSELAGE DRAG ANGLE REPAIRED BY COMPLIANCE WITH EC/TC REO 670-55-31-018 IAW REO 670-55-31-018 FOR LEFT SIDE ONLY. RESTORED PROTECTIVE SDR ASOA200900251Beam · corrodedRT 280 BEAM CORRODED ON UPPER LEG. REMOVED BEAM, DRILLED UP NEW BEAM, AND INSTALLED NEW BEAM AND DOUBLER. PER SRM 51-40-11, 51-42-06, 51-42-21, 51-42-13, 51-23-00 AND 51-21-16.
SDR ASOA200900250Web · corrodedRT WEB CORRODED ON AFT LOWER SURFACE. INSTALLED NEW WEB PER SRM 51-42-06 AND REO 670-53-11-052 REV A.
Back to N390CA